GSquared, thanks a lot. You're right. The loop is ended correctly now. I still have the other variable insert null, but I think I probably need to do another loop...

i see, i will try both of your method and see if it would work for me. But for

Noel's suggestion, what is @x for in your query? Thanks a...

Thanks Noel, but I wanted to be able to do just a set of row, say 10,000 or

100,000 at a time. How do i do it so that the query...

Hi bitbucket, thanks for replying.

I see what you meant after I ran your query

in text display in ssms. 'll keep play around with this

to see if I can use...

I'm trying to display them in the list box in asp.net

as one search that would show multiple columns.

I tried to do it at the presentation layer, but html

ignore blank...

thank you all for your inputs, really helpful and appreciated a lot. i got it to work now by your suggestions, so you made my day...have a happy halloween.

I see, thanks so much Seth and Gail for your quick responses.

really appreciated.

Thanks Jacob for responding. I found out that I could pass it

as string to stored procedure and leave it as windows identity type

in asp.net, then it works.

thanks. michelle.

Cool, it works. thanks a lot Todd. You are genius.

Thanks Brian for responding. DBConcurrencyException is the first time I heard of.

I'll check it out. I thought it's database update concurrency handle

in the database, that is why I...

Jeff, your procedure works wonderfully.

Thanks so much for going above-and-beyond for helping

me in creating the proc and for giving me guidance

on doing things the proper ways. You should...

Thanks Jeff for the link and info. I have never heard of it until Matt wrote it to me.

It is very helpful and agree that better with proper index.

I was...

hi happycat59

your cursor was right, I just had to change the right(year) portion

to right(reportdate) and added one more end.

however, even after it has inserted all the correct years

and date,...

Thanks very much Matt Miller.

I am still working the cursor into my solution

and certainly will try yours as well, because

you are right, if it can be done without cursor

it...

thanks very much happycat59 , let me try in my procedure.

Even if it does not work perfectly, you gave me idea and modify

to my needs and some lights at the...