It still gives me the following error  :

Server: Msg 207, Level 16, State 3, Line 4

Invalid column name 'St.Mary's County'.

thanku....works well.

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...

Thanku for your response. I will try the options that you have mentioned .

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...

thanku. that works

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...

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...

 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...

I would like to have 4 variables from 1 select.

thanks to both of you . defining the variables  as OUTPUT makes it work now !

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...

Thanku very much friends. The sproc works well now.

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...

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...