Select Based On User Identity Name Included In Insert Into Second Table
I am having issues getting this to work. I have the user login to a page to
put in a request for vacation. When they login, I have a label that isn't
visible that is equal to their User.Identity.Name.
I select the user from the employee table where the username = the label User
Identity Name and pull in the emp_id which is the primary key that identifies
the user.
I need to insert the request into the request table with the emp_id from the
select statement, without showing the em_id on the screen. I tried using a
hidden field and assigning the emp_id as the value, but it isn't working.
Not sure if this is the best way to do this. Really new to ASP.NET 2.0 so I
really appreciate any help.
Thank you!
View Complete Forum Thread with Replies
Related Forum Messages:
- Insert Row In Table With Identity Field, And Get New Identity Back
- Insert Based On A Select Query
-
Filter SqlDataSource Select Based On Membership User Name
- Insert With SELECT@@IDENTITY (sqljdbc 1.2)
-
How To: Create A SELECT To Select Records From A Table Based On The First Letter.......
-
Insert Adjusted Datetime Into Sql Field Based On User Locale
-
Gridview Select Statement With User.identity.name In The Where Clause
-
Problem In Using Sqlbulkcopy To Insert Data From Datatable(no Identity Column) Into Sql Server Table Having Identity Column
- SELECT @@IDENTITY During INSERT STATEMENT Error
- Last GASP On &&"Insert Row In Table With Identity Field, And Get New Identity Back &&" ?
-
GridView Based On SQLServerDataSource Using A Select Union Statement, Impacts On Update And Insert?
- How To Insert Rows To Table B Based On Values In Table A.
- Insert Into A Table With Identity
- How To Insert A Row In A Table With 1 Identity Column
- INSERT Into Table With IDENTITY Column
- Insert A Field (IDENTITY) Into Table
- Insert Into Temp Table Based On If Condition
- Insert Into Tabel Based On Values In The Table!
-
Retrieving Identity Field From Table On INSERT
- Get Next Unique ID From A Table Before Insert @@identity / Sequence
- BULK INSERT Into Table With Identity Column?
- Insert Query On Table With Identity Column
- Insert Data Into A Table Without Identity Column
- Can't Insert Rows In Table With Identity Column
- Insert Values In To A Table Which Is Having Identity Column
- Open A Dialogue Based On User Selected Record From A Report Table
-
Insert Multiple Rows To Table Based On Values From Other 2 Tables.
-
Trying To Create A Proc That Will Insert Values Based On A Condition That Is Another Table
- Default Table Owner Using CREATE TABLE, INSERT, SELECT && DROP TABLE
-
Cannot Insert Explicit Value For Identity Column In Table 'SS_Messeges' When IDENTITY_INSERT Is Set To OFF
-
Cannot Insert Explicit Value For Identity Column In Table 'Gallery' When IDENTITY_INSERT Is Set To OFF.?
- Cannot Insert Explicit Value For Identity Column In Table 'Clients' When IDENITY_INSERT Is Set To OFF
- Create User Only With Permissions, To Select, Insert, Update, Delete, And Exec Sps
-
Select Data From Table Name User
-
How To Insert Into A Table Using A Select From Xml
- INSERT INTO - SELECT With Pk In Table
- Cannot Add Select User Permission For A Person On A Table
-
SqlDataSource Select From One Table And Insert To Another
-
How To Select && Insert Data In The Same Table
- Select Form 1 Table And Insert Into Another
- Select Form 1 Table And Insert Into Another
- Select The Insert Value Into Field In Another Table!!!!!!
- TRIGGER On INSERT INTO SELECT FROM Table
-
Login Failed For User 'NT AUTHORITYANONYMOUS LOGON' (but User.identity.name Is Correct)
-
Need To Insert Data Into A Table Within My User Deifined Function 'GetTable1()'?
- Select Query Results In Multiple Columns Based On &&"type&&" From Another Table
-
SELECT INSERT INTO Other Table With Extra Values
- Identity PK Column Based On Other PK...please Help
-
Select From Multiple Tables, Insert In Temp Table
- Insert Record Into Temporary Table From A Select Statement
Insert Row In Table With Identity Field, And Get New Identity Back
I want to insert a new record into a table with an Identity field and return the new Identify field value back to the data stream (for later insertion as a foreign key in another table). What is the most direct way to do this in SSIS? TIA, barkingdog P.S. Or should I pass the identity value back in a variable and not make it part of the data stream?
View Replies !
Insert Based On A Select Query
Hi,I have a SQL query:select products.name, products.notes, products.purchase_date,products.serial_no, products.total_value, products.product_code,products.quantity, products.product_group, products.lhs1_name,lhs1.department, lhs1.address1, lhs1.city, lhs1.countryfrom products, lhs1where products.lhs1_id = lhs1.idI want to insert the results of this query into a table called 'temp' in thedatabase. I used to copy and paste this into excel then import it but itdoesn't always work.Is there a way to do it all in a SQL script. Please be aware that myknowledge of SQL is fairly basic so please explain things clearly.Thanks,Darren
View Replies !
Filter SqlDataSource Select Based On Membership User Name
I am running into an issue trying to declaratively set up a SqlDataSource. I want to be able to filter some of my queries based on the user that is currently logged into the web site. I want to do it Declaratively as that's one of my favorite 2.0 features.Is there any way to do this with the Membership information? I know I can use the code behind to set the parameter, or store the User Name in Session Variable, and use a <asp:SessionParameter> but I think there should be a way to bind directly to the Membership user...Am I missing another option, or is there no built in way to do this? Any other suggestions...Thanks
View Replies !
Insert With SELECT@@IDENTITY (sqljdbc 1.2)
Hi! We are porting a database from DB2 to SQL-Server 2005. We use WAS 5.1. We have problems with insert staments followed by an SELECT @@IDENTITY. The sql error is that no result set is returned. The syntax is "<insert statment>;SELECT @@IDENTITY. We have no problems with this in the 1.1 version (there we have the known "read date" error). Joachim
View Replies !
Insert Adjusted Datetime Into Sql Field Based On User Locale
Is there a way to adjust a date and time depending on the users locale before inserting into the database? Users login in and their country of residence is stored in the database on signup. My server is in the US and I want to reset part of the users db record when it's the end of the day in their country so I need to enter the date and time into the db plus or minus the time difference, is there a function written to do this already or would i need to write my own?
View Replies !
SELECT @@IDENTITY During INSERT STATEMENT Error
The following SQL statement fails on SQL CE 3.5 but works on SQL Express 2005: "INSERT INTO BOOKINGS VALUES(@now,'"+note+"'," + p + "); SELECT @@IDENTITY;" Compact 3.5 doesnt like the SELECT statement claiming that: There was an error parsing the query. [ Token line number = 1,Token line offset = 72,Token in error = SELECT ] Can anyone suggest the correct SQL to implement this via Compact? i.e. How do I retrieve the Identity value during and insert statement? I have removed the SELECT @@IDENTITY; portion of the statement and it runs fine.
View Replies !
Last GASP On &&"Insert Row In Table With Identity Field, And Get New Identity Back &&" ?
While I have learned a lot from this thread I am still basically confused about the issues involved. .I wanted to INSERT a record in a parent table, get the Identity back and use it in a child table. Seems simple. To my knowledge, mine would be the only process running that would update these tables. I was told that there is no guarantee, because the OLEDB provider could write the second destination row before the first, that the proper parent-child relationship would be generated as expected. It was recommended that I create my own variable in memory to hold the Identity value and use that in my SSIS package. 1. A simple example SSIS .dts example illustrating the approach of using a variable for identity would be helpful. 2. Suppose I actually had two processes updating these tables, running at the same time. Then it seems the "variable" method will also have its problems. Is there a final solution other than locking the tables involved prior to updating them or doing something crazy like using a GUID for the primary key! 3. We have done the type of parent-child inserts I originally described from t-sql for years without any apparent problems. (Maybe we were just lucky.) Is the entire issue simply a t-sql one or does SSIS add a layer of complexity beyond t-sql that needs to be addressed? TIA, Barkingdog
View Replies !
GridView Based On SQLServerDataSource Using A Select Union Statement, Impacts On Update And Insert?
I have a GridView dispalying from a SQLServerDataSource that is using a SQL Select Union statement (like the following): SELECT FirstName, LastNameFROM MasterUNION ALLSELECT FirstName, LastNameFROM CustomORDER BY LastName, FirstName I am wondering how to create Update and Insert statements for this SQLServerDataSource since the select is actually driving from two different tables (Master and Custom). Any ideas if or how this can be done? Specifically, I want the Custom table to be editable, but not the Master table. Any examples or ideas would be very much appreciated! Thanks, Randy
View Replies !
How To Insert Rows To Table B Based On Values In Table A.
I need Insert rows in the OrderDetails Table based on values in the Orders Table In the Orders table i have a columns called OrderID and ISale. In the OrdersDetails i have columns called OrderID and SaleType For each value in the OrderID Column of the Orders Table, anytime the ISale Column in the Orders table = 1, and the SalesType column in the OrderDetails table is empty, I want to add two rows in the OrderDetails table. One row with the value K and another row with the value KD. That is a row will be added and the value in the SalesType column will be K, also a second row will be added and the value in the SalesType column will be KD Also for each value in the OrderID Column of the Orders Table, anytime the ISale Column in the Orders table = 0, and the SalesType column in the OrderDetails table is empty, I want to add two rows in the OrderDetails table. One row with the value Q and another row with the value QD That is a row will be added and the value in the SalesType column will be Q, also a second row will be added and the value in the SalesType column will be QD. I need a SQL Script to accomplish this. thanks
View Replies !
Insert Into A Table With Identity
I have 2 tables with same structure.only difference is, TableA has key colum which is declared as identity starting from 1. I want to insert data from TableB into TableA where TableB.Key is all null with TableA.Key starting from 9000001 when i try to do that iam getting an error "An explicit value for the identity column in table 'lEADlOAN' can only be specified when a column list is used and IDENTITY_INSERT is ON. " even when I turned IDENTITY_INSERT ON for TableA
View Replies !
INSERT Into Table With IDENTITY Column
I'm sure this is a common problem but I can't find any relevant info on this site I have a table that I would like to insert values into. I want to take the values from a secondary table using a select statement. e.g. a simplified version... TABLE1 ( Id INTEGER IDENTITY, UserName VARCHAR(50), Description VARCHAR(50) ) TABLE 2 ( UserName VARCHAR(50), Description VARCHAR(50) ) Runing the insert statement INSERT Table1 (UserName, Description) SELECT * FROM TABLE2 results in the error erver: Msg 515, Level 16, State 2, Line 2 Cannot insert the value NULL into column 'Id', table 'CDS_Live.dbo.Table1'; column does not allow nulls. INSERT fails. The statement has been terminated. I was under the impression that an identity column would be automatically inserted by SQL server. Now I know I could write a piece of anonymous Transact SQL which declares a cursor by selecting all rows from table 2 and inserting rows into table 1 on a row by row basis, but is there any way I could do the Insert with a single INSERT statement? thanks neill
View Replies !
Insert A Field (IDENTITY) Into Table
Hi, I have a table with 1000000 records i try to add a field with following`spec. [mkey] [int] IDENTITY(1,1) NOT NULL I get the following meassage:- yearly' table - Saving Definition Changes to tables with large amounts of data could take a considerable amount of time. While changes are being saved, table data will not be accessible. Then I Have the following error:- Time out error - How is the best way to copy a large table from one to anther. regards
View Replies !
Insert Into Temp Table Based On If Condition
hello all,this might be simple:I populate a temp table based on a condition from another table:select @condition = condition from table1 where id=1 [this will giveme either 0 or 1]in my stored procedure I want to do this:if @condition = 0beginselect * into #tmp_tablefrom products pinner joinsales s on p.p_data = s.p_dataendelsebeginselect * into #tmp_tablefrom products pleft joinsales s on p.p_data = s.p_dataendTha above query would not work since SQL thinks I am trying to use thesame temp table twice.As you can see the major thing that gets effected with the condictionbeing 0/1 is the join (inner or outer). The actual SQL is much biggerwith other joins but the only thing changing in the 2 sql's is the joinbetween products and sales tables.any ideas gurus on how to use different sql's into temp table based onthe condition?thanksadi
View Replies !
Insert Into Tabel Based On Values In The Table!
Hi i am trying to create an insert statement that will insert rows into a table based on the information in the table already. the table looks like this Groupid field1 field2 -1 100 200 -1 100 300 -1 300 500 -1 300 600 -1 400 100 the insert looks like this INSERT Into table1(groupid,field1,field2) select -1,@passedvalue,field2 from table1 where field1 = @passedvalue1 assume @passedvalue = 700, @passwedvalue1 = 100 Now this is fine however i cannot have a duplicate key (key is comibantion of all 3 fields) thus the first time this runs it works however if it runs again it fails - how can i change the where clause to ignore rows that already exist? eg if @passedvalue = 300 and passedvalue1 = 500
View Replies !
Retrieving Identity Field From Table On INSERT
I have 2 tables - tblOrders and tblOrderDetails. Every time an order is placed, 2 INSERT statements are executed. The first one enters the general order and customer information in the tblOrders table:INSERT INTO tblOrders (custname, custdetails, orderdate) VALUES (@custname, @custdetails, @orderdate)The primary key in this table is OrderID which is an Identity column. This is the foreign key in the tblOrderDetails table.I'm trying to get the Identity value from the first INSERT statement to use in the second INSERT statement:INSERT INTO tblOrderDetails (orderid, productid, productcost) VALUES (@orderid, @productid, @productcost) How do i obtain this value and how would I supply it to the second INSERT statement?
View Replies !
Get Next Unique ID From A Table Before Insert @@identity / Sequence
How do I get the next int value for a column before I do an insert inMY SQL Server 2000? I'm currently using Oracle sequence and doingsomething like:select seq.nextval from dual;Then I do my insert into 3 different table all using the same uniqueID.I can't use the @@identity function because my application uses aconnection pool and it's not garanteed that a connection won't be usedby another request so under a lot of load there could be major problemsand this doens't work:insert into <table>;select @@identity;This doesn't work because the select @@identity might give me the valueof an insert from someone else's request.Thanks,Brent
View Replies !
BULK INSERT Into Table With Identity Column?
I have a file I'm trying to do some non-set-based processing with. Inorder to make sure I keep the order of the results, I want to BULKINSERT into a temp table with an identity column. The spec says thatyou should be able to use either KEEPIDENTITY or KEEPNULLS, but I can'tget it to work. For once, I have full code - just add any file of yourchoice that doesn't have commas/tabs. :)Any suggestions, folks?--create table ##Holding_Tank ( full_record varchar(500)) -- thisworkscreate table ##Holding_Tank (id int identity(1,1) primary key,full_record varchar(500)) --that doesn't workBULK INSERT ##Holding_TankFROM "d: elnet_scriptspsaxresult.txt"WITH(TABLOCK,KEEPIDENTITY,KEEPNULLS,MAXERRORS = 0)select * from ##Holding_tank
View Replies !
Insert Query On Table With Identity Column
I cannot insert into my appointments table because the primary key and identity column, appt_id, cannot be added. What do I have to change in my SQL statement to add new records into this table? I'm using SQL Server 2000 BE with Access Data Project FE.tbl_appointment-------------------1. appt_id (pk) --- identity column, seed 25, increment 12. date_id3. time_start4. time_end5. appt_details6. lkp_emp_idPrivate Sub btnAddAppts_Click()On Error GoTo Err_btnAddAppts_ClickDim strsql As StringDoCmd.SetWarnings Falsestrsql = "INSERT INTO [tbl_appointments] (lkp_emp_id, date_id, time_start, time_end, appt_details) values ('" & txtLkpEmpID & "', '" & txtDateID & "', '" & txtStartTime & "', '" & txtEndTime & "', '" & txtApptDetails & "')"DoCmd.RunSQL strsqlDoCmd.SetWarnings TrueDoCmd.CloseExit_btnAddAppts_Click:Exit SubErr_btnAddAppts_Click:MsgBox Err.DescriptionResume Exit_btnAddAppts_ClickEnd Sub I did check through Access and through Enterprise Manager and it is setup correctly. So I returned all rows in enterprise manager to manually enter an appointment to the table. I get the same error when doing data-entry straight to the table. [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot update identity column 'appt_id'. It does not automatically populate the appt_id field the way it's supposed to. When I try to manually set a value in there, i get an error: "Cannot edit this cell."
View Replies !
Can't Insert Rows In Table With Identity Column
Hello, I have a problem. I am trying to pull data out of one system and bring it into a SQL Server database for faster retrieval. The original table does not have an identity column and has a composite primary key. The table I am inserting the data into matches the original table exactly except I have an Identity column that I need for the removal of duplicates. The task gets to the final commit and then fails telling me that it can't insert a NULL into an identity field. Why is it trying to insert a NULL, the field should be auto-populating. I did add the Identity field to the table after the SSIS package was already built, but I did go into the destination and fix the column mappings. For the Identity column I just selected the "skip" option or whatever it was. Why are the identities not being auto-inserted and why is SSIS throwing this error? Can anyone help??? Thanks!
View Replies !
Open A Dialogue Based On User Selected Record From A Report Table
I have a scenario of client side reporting, I want to have a drillthrough like capability but instead of drilling down to a another report I have to open a dialogue window that would have information displayes based on the record selected by the user from the main report. I know it can be done in drillthrough which also gets the the selected record values: ReportParameterInfoCollection DrillThroughValues = e.Report.GetParameters(); But can I have the same functionality but unstead of opening another report it pops up a dialogue window with the information selected by the user. Any help would be appreciated. Thanks
View Replies !
Insert Multiple Rows To Table Based On Values From Other 2 Tables.
I have a form to assign JOB SITES to previously created PROJECT. The JOB SITES appear in the DataList as it varies based on customer. It can be 3 to 50 JOB SITES per PROJECT. I have "PROJECT" table with all necessary fields for project information and "JOBSITES" table for job sites. I also created a new table called "PROJECTSITES" which has only 2 columns: "ProjectId" and "SiteId". What I am trying to do is to insert multiple rows into that "PROJECTSITES" table based on which checkbox was checked. The checkbox is located next to each site and I want to be able to select only the ones I need. Btw the Datalist is located inside of a formview and has it's own datasource which already distincts which JOBSITES to display. Sample: ProjectId - SiteId 1 - 5 1 - 9 1 - 16 1 - 18 1 - 20 1 - 27 1 - 31 ProjectId stays the same, only values for SiteId are being different. I hope I explaining it right. Do I have to use some sort of loop to go through the automatically populated DataList records and how do I make a multiple inserts to database table? We use SQL Server 2005 and VB for code behind. Please ask if I missed on some information. Thank you in advance.
View Replies !
Trying To Create A Proc That Will Insert Values Based On A Condition That Is Another Table
Can someone give me a clue on this. I'm trying to insert values based off of values in another table. I'm comparing wether two id's (non keys in the db) are the same in two fields (that is the where statement. Based on that I'm inserting into the Results table in the PledgeLastYr collumn a 'Y' (thats what I want to do -- to indicate that they have pledged over the last year). Two questions 1. As this is set up right now I'm getting NULL values inserted into the PledgeLastYr collumn. I'm sure this is a stupid syntax problem that i'm overlooking but if someone can give me a hint that would be great. 2. How would I go about writing an If / Else statement in T-SQL so that I can have the Insert statement for both the Yes they have pledged and No they have not pledged all in one stored proc. I'm not to familar with the syntax of writing conditional statements within T-SQL as of yet, and if someone can give me some hints on how to do that it would be greatly appriciated. Thanks in advance, bellow is the code that I have so far: RB Select Results.custID, Results.PledgeLastYr From Results, PledgeInLastYear Where Results.custID = PledgeInLastYear.constIDPledgeInLastYear Insert Into Results(PledgeLastYr) Values ('Y')
View Replies !
Default Table Owner Using CREATE TABLE, INSERT, SELECT && DROP TABLE
For reasons that are not relevant (though I explain them below *), Iwant, for all my users whatever privelige level, an SP which createsand inserts into a temporary table and then another SP which reads anddrops the same temporary table.My users are not able to create dbo tables (eg dbo.tblTest), but arepermitted to create tables under their own user (eg MyUser.tblTest). Ihave found that I can achieve my aim by using code like this . . .SET @SQL = 'CREATE TABLE ' + @MyUserName + '.' + 'tblTest(tstIDDATETIME)'EXEC (@SQL)SET @SQL = 'INSERT INTO ' + @MyUserName + '.' + 'tblTest(tstID) VALUES(GETDATE())'EXEC (@SQL)This becomes exceptionally cumbersome for the complex INSERT & SELECTcode. I'm looking for a simpler way.Simplified down, I am looking for something like this . . .CREATE PROCEDURE dbo.TestInsert ASCREATE TABLE tblTest(tstID DATETIME)INSERT INTO tblTest(tstID) VALUES(GETDATE())GOCREATE PROCEDURE dbo.TestSelect ASSELECT * FROM tblTestDROP TABLE tblTestIn the above example, if the SPs are owned by dbo (as above), CREATETABLE & DROP TABLE use MyUser.tblTest while INSERT & SELECT usedbo.tblTest.If the SPs are owned by the user (eg MyUser.TestInsert), it workscorrectly (MyUser.tblTest is used throughout) but I would have to havea pair of SPs for each user.* I have MS Access ADP front end linked to a SQL Server database. Forreports with complex datasets, it times out. Therefore it suit mypurposes to create a temporary table first and then to open the reportbased on that temporary table.
View Replies !
Cannot Insert Explicit Value For Identity Column In Table 'Clients' When IDENITY_INSERT Is Set To OFF
Code Snippet Private Sub AddClientToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AddClientToolStripMenuItem.Click Dim addclient As New newclient() newclient.ClientID = 0 Dim result As DialogResult result = addclient.ShowDialog If result = DialogResult.OK Then Dim Client As clients_and_sitesDataSet1.ClientsRow Client = Clients_and_sitesDataSet1.Clients.NewClientsRow Client.ClientID = addclient.ClientID Client.Clientname = addclient.Clientname Client.Street_and_number = addclient.Street_and_number Client.Zipcode = addclient.Zipcode Client.Place = addclient.Place Client.Phone = addclient.Phone Client.Email = addclient.Email Client.Contact_person = addclient.Contact_person Clients_and_sitesDataSet1.Clients.AddClientsRow(Client) ClientsTableAdapter.Update(Client)------------------------------problem MessageBox.Show("New Client is saved") Else MessageBox.Show("User cancelled operation") End If addclient = Nothing End Sub Code in VB (2005 express edition) Hi all above is aa snipped from the code I am using. all works fine exxept the ------problem line. when i try to run the program, i get an exeption Cannot insert explicit value for identity column in table 'Clients' when IDENITY_INSERT is set to OFF how can i turn this on???? I seem to be stuck, vieuwed the msdn video on the subject and cant find what I am doing wrong. I hope u guys can help me out. And please give me specific guide lines on how to put in the code and code lines. I tried using SET IDENTITY_INSERT Clients ON But than I get all errors bout things not being declared, set not being supported anymore, things like that. Thanks for the effort you will put into helping me out and becomming a "self supported programmer"
View Replies !
Create User Only With Permissions, To Select, Insert, Update, Delete, And Exec Sps
Hello, I recently view a webcast of sql injection, and at this moment I created a user, and give dbo to this user, and this same user, is the one I have in the connection string of my web application, I want to create a user to prevent sql injection attacks, I mean that user wont be able to drop or create objects, only select views, tables, exec insert,update, deletes and exec stored procedures. Is any easy way to do this? A database role and then assing that role to the user?
View Replies !
Select Data From Table Name User
Hi,I using vb.net to do this. I need to retrieve data from a table name "User". The table is in a sql server. I having trouble retrieve data from it. This is my code Dim strsql As String = "SELECT DISTINCT NameID FROM User"Dim cmd As New sqlCommand(strsql, cn)Dim das As New sqlDataAdapter(cmd)Dim da As DataSet = New DataSetdas.Fill(da)This is the error message. Syntax error in FROM clause. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Source Error: Line 31: Dim das As New sqlDataAdapter(cmd) Line 32: Dim da As DataSet = New DataSet Line 33: das.Fill(da) Line 34: Line 35: DropDownList1.DataTextField = "NameID"I have tried other table, no problem, data is retrieved. Seem like "User" is restricted word... Worse is i cannot change the table name, only thing i can do is get data from it. So hope someone can help me on this. thanks in advance!!
View Replies !
How To Insert Into A Table Using A Select From Xml
Good Day, I am passing some XML into a stored procedure: <answers> <answer id="60" text="" /> <answer id="65" text="A moderate form of learning disability" /> <answer id="68" text="We will keep ASD checked" /> <answer id="70" text="" /> </answers> Along with a memberid and questionid. I was wondering how I can get this into a table CREATE TABLE [dbo].[Answers]( [PrimaryKeyID] [int] NOT NULL, [MemberID] [int] NOT NULL, [QuestionID] [int] NOT NULL, [AnswerID] [int] NOT NULL, [FreText] [varchar](255) COLLATE Latin1_General_CI_AS NULL ) ON [PRIMARY]What I would also like to do is if the text attribute is empty then put a NULL in the FreText field.I think I am looking for Insert into MyTable ( Select @MemID, @QuesID, 'somexpathforanswer', 'somexpathfortext' -- if empty then NULL From @MyXML ) Any ideas - places to to look - thoughts AprreciatedKal
View Replies !
INSERT INTO - SELECT With Pk In Table
Is it possible to use the INSERT INTO - SELECT syntax with a pk in the target table that has no auto increment? The tables structure is: CREATE TABLE objectlang ( objectlangID integer NOT NULL, <== PK objectID integer NOT NULL, langID integer NOT NULL, somedata integer NOT NULL, [[...more columns here...]] ) The statement should look like: INSERT INTO objectlang SELECT [[??set pk here??]], o.objectID, l.langID, 1, [[...more data here...]] FROMobject o, lang l WHERE[[...conditions...]] I thought of something like reading the current max value of objectlangID and adding a value, but no idea where this value should come from. I need this for more than one project in mssqlserver 2000/2005, postgresql and oracle. tia
View Replies !
Cannot Add Select User Permission For A Person On A Table
Hello, I am trying to grant solely the SELECT privilige to a particular user and to a particular database.I am using Sql server management studio express to do this and SQL Server 2005. I have created a new login and set the server roles to public, then on the user mapping page, I have checked the box next to the table I wish the user to access and have selected the database membership role - public. Next, On the Table Properties, I have added the user on the Permissions Page and Selected "Select" under the grant column When I click on effective permissions, the select command does not show and when I try to login with that user, the table does not display. What I am doing wrong? Thanks
View Replies !
SqlDataSource Select From One Table And Insert To Another
Is it possible within a Sqldatasource to select data from one database table and the insert that data into another? eg: 1 <asp:SqlDataSource ID="SqlDataSource" runat="server" 2 ConnectionString="<% Something %>" 3 InsertCommand="INSERT INTO [Resumes] ([ResumeID], [UserID], [CompanyID], [ResumeTitle], [ResumeDesc]) VALUES (@ResumeID, @UserID, @CompanyID, @ResumeTitle, @ResumeDesc)" 4 SelectCommand="SELECT [UserId], [CompanyID], [CompanyName] FROM [Info] WHERE ([UserId] = @UserId)" <SelectParameters> 5 <skm:MembershipUserIdParameter Name="UserId" /> 7 </SelectParameters> 8 <InsertParameters> 9 <skm:MembershipUserIdParameter Name="UserId" /> 10 <asp:Parameter Name="CompanyID" Type="Int32" /> 11 <asp:Parameter Name="ResumeTitle" Type="String" /> 12 <asp:Parameter Name="ResumeDesc" Type="String" /> 13 </InsertParameters> 14 </asp:SqlDataSource>
View Replies !
How To Select && Insert Data In The Same Table
Hi I have a table called Version and its attributes are Version_ID, Project_ID , Hospital_ ID , Date_Created and comments. I want to select the data by Version_ID,Project_ID and Hospital_ID and the selected data is inserted in the same table(Version) as new row . Table: Version (Version_ID(Primary_key), Project_ID(Foreign_Key),Hospital_ID(Foreign_Key),Date_Created,Comments). Iam using Visual Web Developer Express and SQL Server 2005. Iam doing on asp.net 2.0. Could anyone please send me the code asp.net 2.0 for the above problem.
View Replies !
Select Form 1 Table And Insert Into Another
Can someone point me in the right direction or show me a sample that may assist me in the following. Thanks, -dw I need to select some data from 1 table and insert it into another using a stored procedure. I also would like to select data from table 1 and insert a new record into table 1 modifying a field with new data passed by parameter. Is it something like: parameters passed = @selectJobNumber, @newJobNumber declare @DeliveryMethodIDint SELECT @DeliveryMethodID=DeliveryMethodID, ... etc - more fields FROM jobDeliveryAddress WHERE (JobNumber= @selectJobNumber) INSERT INTO [jobDeliveryAddress] ( [JobNumber], [DeliveryMethodID], ... etc - more fields ) VALUES ( @newJobNumber, @DeliveryMethodID, ... etc )
View Replies !
Select Form 1 Table And Insert Into Another
Can someone point me in the right direction or show me a sample that may assist me in the following. Thanks, -dw I need to select some data from 1 table and insert it into another using a stored procedure. I also would like to select data from table 1 and insert a new record into table 1 modifying a field with new data passed by parameter. Is it something like: parameters passed = @selectJobNumber, @newJobNumber declare @DeliveryMethodIDint SELECT @DeliveryMethodID=DeliveryMethodID, ... etc - more fields FROM jobDeliveryAddress WHERE (JobNumber= @selectJobNumber) INSERT INTO [jobDeliveryAddress] ( [JobNumber], [DeliveryMethodID], ... etc - more fields ) VALUES ( @newJobNumber, @DeliveryMethodID, ... etc )
View Replies !
Select The Insert Value Into Field In Another Table!!!!!!
i have tbl_location which includes userid, building, room. i combine the building and room into one feild called mailstop SELECT Userid, Building +'/'+Room AS mailstop FROM tbl_Location i then want to take this recordset and insert it into a field called mailstop in my employee table. but they must based upon the userid of the location table and the userid of the employee table. so the userid of the location table must match the userid of the employee table and insert that mailstop value into the mailstop feild in employee table. i want to get this right the first time. any help would be greatly appreciated.
View Replies !
TRIGGER On INSERT INTO SELECT FROM Table
hi need help how to do this TRIGGER on INSERT INTO SELECT FROM table + add one row for evry employee (on insert) this is table tb_test1 empid fname unit fld1 fld2 fld3 fld4 fld5 ---------------------------------------------------------------------------------------- 111 aaa 1 a b c d d 222 bbb 3 a c e g g 333 cccc 5 s h t u j INSERT INTO [nili].[dbo].[tb_test2] ([empid] ,[fname] ,[unit] ,[fld1] ,[fld2] ,[fld4] ,[fld5]) SELECT [empid] ,[fname] ,[unit] ,[fld1] ,[fld2] ,[fld4] ,[fld5] FROM [nili].[dbo].[tb_test1] i need to insert into tb_test2 + add TRIGGER ADD one row for evry employee val_orginal=1 (the orginal ROW) val_orginal=2 (the extra ROW) this is table tb_test2 after the insert HOW TO THIS empid fname unit fld1 fld2 fld3 fld4 fld5 val_orginal ------------------------------------------------------------------------------------------------- 111 aaa 1 a b c d d 1 111 aaa 1 - - - - - 2 222 bbb 3 a c e g g 1 222 bbb 3 - - - - - 2 333 cccc 5 s h t u j 1 333 cccc 5 - - - - - 2 and tnx for the help
View Replies !
Login Failed For User 'NT AUTHORITYANONYMOUS LOGON' (but User.identity.name Is Correct)
I need help. The security principal is the correct DomainUser, but the error message says I am not authenticated. So here is my error Message: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. Me.User.Identity.Name=CompanyDomainRyan; System.Security.Principal.WindowsIdentity.GetCurrent=CompanyDomainRyan; HttpContext.Current.User.Identity.Name=CompanyRyan Generated by: Dim secPrinc As System.Security.Principal.WindowsIdentity = System.Security.Principal.WindowsIdentity.GetCurrent Me.lblError.Text = ex.Message & vbCrLf & vbCrLf & "Me.User.Identity.Name=" & Me.User.Identity.Name & "; System.Security.Principal.WindowsIdentity.GetCurrent=" & secPrinc.Name & "; HttpContext.Current.User.Identity.Name=" & HttpContext.Current.User.Identity.Name Here is the Connection String: Private ConnString As String = "Server=10.144.162.111;Database=DNS;Trusted_Connection=True" IIS has 4 websites hosted on it. The parent level allows anonymous with windows auth off, but the website level has anonymous off with widnows auth and digest. In IIS, is there a problem with having the parent level anonymous and website level windows auth?
View Replies !
Select Query Results In Multiple Columns Based On &&"type&&" From Another Table
Using SQL Server 2005 Express: I'd like to know how to do a SELECT Query using the following tables: Miles Table: Date/Car/Miles/MilesTypeID =============== (some date)/Ford/20/1 (some date)Ford/20/2 (some date)Chevy/30/1 (some date)Toyota/50/3 (some date)Ford/30/3 Miles Type Table MilesTypeID/MilesType ================= 1/City 2/Highway 3/Off-Road I'd like the results to be like this: Date/Car/City Miles/Highway Miles/Off-Road Miles ===================================== (date)-Ford-20-0-0 (date)-Chevy-0-20-0 (date)-Ford-20-0-0 (date)-Toyota-0-0-50 (date)-Ford-0-0-30 Anyone? Thanks in advance!
View Replies !
SELECT INSERT INTO Other Table With Extra Values
Hi, I've got a table with trialsubscriptions. When someone orders a trialsubscription he has to fill in a form. With the values in the form I like to fill a database with some extra fields from the trialsubscription table. I get those extra fields with a datareader. But when I insert I can't use the same datareader (its an insert), I can't make two datareaders because I have to close the first one etc. Does someone had the same problem and has some example code (or make some :-)) Some keywords are also possible! Thanks! Roel
View Replies !
Identity PK Column Based On Other PK...please Help
I have this table where there is tow primary keys ,one for Year and the other for DocNumber. In this table the DocNumber takes a number based on each year,for example in year 2008 the DocNumber should start counting from 1 and increment by one for every record,when the year changes to 2009 the DocNumber should start again from 1 until and seed by one again. Those columns are PKs because there must be one doc Number for each year and they can not be null . Is there any simple way to approach this in Sql Server 2005 ,or do I have to work on trigger to do so...??? Any ideas will be really appreciated. Eng.Osman Hamad http://arabic.aspose.com
View Replies !
Select From Multiple Tables, Insert In Temp Table
What's the best way to go about inserting data from several tables that all contain the same type of data I want to store (employeeID, employerID, date.. etc) into a temp table based on a select query that filters each table's data? Any ideas? Thanks in advance.
View Replies !
Insert Record Into Temporary Table From A Select Statement
Hi guys, anyone can help me? i using sp to select a select statement from a join table. due to the requirement, i need to group the data into monthly/weekly basic. so i already collect the data for the month and use the case to make a new compute column in the selete statement call weekGroup. this is just a string showing "week 1", "week 2" .... "week 5". so now i want to group the weekgroup and disply the average mark. so i need to insert all the record from the select statement into the temporary table and then use 2nd select statement to collect the new data in 5 record only. may i know how to make this posible? regards terence chua
View Replies !
|
TRACKER
