Search results for query: *

Have written a stored procedure to read table values differently, i.e. the table structure is as follows: SurveyID QuesttionID Answer 1 3 Yes 1 4 Unsure 2 3 No 2 4 Yes want to create a temp...

A stored procedure that was previously working under Win 95 / Crystal Reports 7 is now not working under Windows 2000 Professional with Crystal Reports 8.5! The error message "ODBC SQL Server Driver - Invalid Cursor State" appears when I try to run the reports using this particular...

A stored procedure that was previously working under Win 95 / Crystal Reports 7 is now not working under Windows 2000 Professional with Crystal Reports 8.5! The error message "ODBC SQL Server Driver - Invalid Cursor State" appears when I try to run the reports using this particular...

We've had to specify a database date field as a VarChar as product will be used internationally with varying date formats. However, need to use this field with Date / Time functions. I'd like to be able to create another field in a stored procedure which changes this VarChar to a proper DateTime...

Attn Rajeev thanks very much -- Populate temporary table with data where [datSurvey].[Status] <> 'D' DECLARE curSurvey CURSOR FOR SELECT [column names] FROM [datSurvey] LEFT OUTER JOIN [datUser] ON [datSurvey].[Link] = [datUser].[Link] WHERE [datSurvey].[Status] <> 'D' ORDER BY...

I'm new to stored procedures. Am trying to create a procedure to 1) use a cursor to dump data into a temp table and 2) to then use IF statements with 2 different SELECT statements, based on the temp table, dependent upon user parameters. Have only got to stage (1). Can see the stored procedure...