Worked perfect. Thank you.

I have tried setting nocount and it still is not working. I ran the procedure with sql analyzer and it returned to sets of data the first being empty and...

I just want the date (1/1/1900) part of the row instead of the date and time (1/1/1900 12:00)

My statement is a basic SELECT statement

That didn't work.

I have tried moving

IF @rowcount > 0

Return -1

to the end of the insert statement, and it added the data and it also returned -1

Thank you all!

I have never done that before. Can you give me some advice on where to begin?

So then on my asp.net page I can just test to see if the value entered into the textbox is greater than 1 and then fire the sp based on...

There are 214 text boxes on the page.

Let's say I enter values into 5 of the text boxes, then I will need to enter those 5 values in the database

My...

(

@UserID INT,

@test INT

)

AS

INSERT dbo.MySurvey_Marketing_Skills_User(User_ID, Skill_Rank, Skill_ID )

Values (@UserID, @Test, 97)

I hand keyed the 97 value because I am not sure how that will work on the asp.net page to pass...

I tried doing my stored procedure the same way you did. I tested it with two text boxes.

cmdSave.Parameters.Add("@test", TextBox1.Text)

cmdSave.Parameters.Add("@test", TextBox2.Text)

but I am given this message

Procedure or function Test has...

I don't understand your reply. Here is what I have so far for my stored procedure.

(

@UserID Int

)

AS

SELECT User_ID, Position_ID, Company_Name, Position_Title, Start_Date, End_Date

FROM dbo.MySurvey_Positions

WHERE User_ID = @UserID

I need to...

I am not a SQL expert so I am not familiar with the method you are talking about. Will it make a big difference in performance?

Declare @Date datetime

Set @Date...

I check to see if the User_ID exists and if it does then I update the information, and if it doesn't then I add the user's information to the table....

That worked, thank you. I have been trying to figure it out all day.

it tells me "Incorrect syntax near the keyword 'Else'

IF EXISTS(SELECT User_ID FROM dbo.User_Information WHERE User_ID = @UserID)

UPDATE dbo.User_Information SET Salutation = @Salutation, Email_1 = @Email1, Address_1 = @Address1, Address_2 =...