Viewing 15 posts - 31 through 45 (of 46 total)
It still gives me the following error :
Server: Msg 207, Level 16, State 3, Line 4
Invalid column name 'St.Mary's County'.
February 6, 2004 at 9:21 am
A section of my data will look like this:
book | page .........other fields
1 2
2 1
2 3
2 2
1 1
1 2
3 1
2 3
You will notice that the combination 1 ,1 appears twice in...
February 5, 2004 at 12:07 pm
Thanku for your response. I will try the options that you have mentioned .
January 22, 2004 at 12:31 pm
Sorry, I thought this might be a SQL server question and that is why I posted it in this discussion group.
Thanks for your response , kelseyv......
Actually I do not have a...
January 22, 2004 at 8:58 am
First of all , Thanku Gabor, your suggestion worked out very well and took a lot of messiness from SQL stmt.
ThomasH, thanku for your suggestion too, I will try it...
January 9, 2004 at 9:01 am
yes, i can wait till tomorrow and i am willing to try any changes to make the code better and work efficiently.
there is some more to this stored procedure and...
January 8, 2004 at 4:16 pm
ThomasH ,Thanku for your suggestion. I should have pasted the entire code to show you that these statements are executed using sp_executesql in a sproc. My question is , how...
January 8, 2004 at 1:48 pm
I would like to have 4 variables from 1 select.
January 8, 2004 at 1:17 pm
thanks to both of you . defining the variables as OUTPUT makes it work now !
January 6, 2004 at 10:59 am
Thanku for your response. When I tried sp_executesql just as you have mentioned above, I get the following error:
Server: Msg 141, Level 15, State 1, Line 1
A SELECT statement that...
January 6, 2004 at 7:09 am
Thanku very much friends. The sproc works well now.
December 22, 2003 at 12:31 pm
Thomas, Per @countyt I could have 100 to 150 rows. I will try out the sql stmt that you have mentione and get back on how it worked.
Jonathan, This...
December 19, 2003 at 3:02 pm
The number of tables are about 150 now and the number of rows anywhere from 0 to a million in each table. The number of tables and rows can...
December 19, 2003 at 11:05 am
Viewing 15 posts - 31 through 45 (of 46 total)