sampath

is the FK problem solved? like Jack said it should be 'Cascade' option while setting FK relationship. When setting relationship, if you check 'Cascade' you will not get issues when...

Thanks for your reply Barry. I tried it and yes, I got the required results 🙂 I'm using this particular query in at least 2 other functions and in dozen...

well yes. I need a UNION here. I had one inner join to get the desired result. Now due to some enhancements I have to do the matching twice, hence...

here i want to join a few tables and extract the results. The LEFT OUTER JOINS are used on PI_Common p , ABI_Customer ac and Account a tables. Now I...

wowww gr88 john 🙂 I got it. I spent a few hours browsing forums before posting here. I stumbled across 'rowcount' but didn't understand that. I didn't find good materials...

Thanks for your reply John :). I see what you are telling

instead of TOP use ROWCOUNT.

initialize ROWCOUNT with the # of rows I need.

and once the job is done,...

🙁 I made a typo

declare @lastzip int is correct.

i typed wrongly as declare @lastzip varchar(8000)