Thanks all for your reply. I reverted to CSV string and used a function to return table from it. This table is used in my join query. I was amazed...

I am using approach mentioned in post to do a master detail insert with following query,

INSERT INTO LISTDTL(ListDtl_ListHdrID,ListDtl_ProductID,ListDtl_ISBN_Number) SELECT @ListHdr_ID,P.PROD_PRODUCT_ID,ISBN.ISBNNumber FROM PRODUCT P INNER JOIN (SELECT ParamValues.ID.value('.','VARCHAR(20)') as...

I tried the query on SQL SERVER 2005 and it ran fine with giving result as specified in choice (a).

I will some what agree with TheSQLGuru in saying that myself being 2+ years experienced progarmmer am mediocre in writing efficient SQL queries as  I have other things to concentrate on....

I have got the adventureworks database installed but I see few samples there  for it in BOL. I know I am trying to get too much in too little time...

Hi ,

I downloaded latest BOL version from microsoft.I looked at SQL books online and saw Samples and Sample Databases link.Is that you are talking of samples? I am not able...

Thanks for all the posts i have received. I will surely follow the book as well as run samples from BOL. I sincerely hope that I will improve and get...