Hi Adi,

Your query workls perfectly.

Hi mayank,

This is not working. It only insetts 1 for every row but not incrementing.

Hi markus,

I should admit that still I have not faced any real...

Hi everybody,

Thanks to all specially MArk and DMW. I have got my answer.

Thanks again.

Hi everyone,

Sorry for late replying. The code I have published is very official, hence cant publish the actual code.

But my actual question is, are the SQL statements running parallel...

Hi Jack and GSquared ,

Thanks 4 ur time. But still I m facng the problem without GO.

Is it something like the first statement and second statement clashes, because the first...

Hi Ken,

Both queries are working fine.

Actually I have tried with left outer join also, but not used the null.

Many thanks for ur help.

Hi Babar,

1. Using temp table is always faster than cursors.

2. U have used dynamic SQL. it slows down the performance.

3. In report, try to use some group by so that...

Thanks to everybody. Its a great plasure 2 me to receive such complements.

Thanks adi, I will try ur solution.

The question is a bit ambiguous

Hi adi,

I have checked the second method you have described. But its not throwing any error from JAVA frontend, though raising error from SQLMS.

What 2 do?

Hi, another question:

RAISERROR raising errors properly from SQL MS.

But from front end (it is in JAVA), no error message is showing. But the SP is working fine. It is giving...

Hi Mahesh ,

i want to do the same through TRY_catch BLOCK.

Thanks for your help.

Hi Adi,

Thanks.

It solves my problem.

Hi All,

Really this is a great help for me. I have faced this question several times.

Thanks again.

"call Portal_GetNextMessageID (pStrItemID),out nextMessageID ;

call Portal_GetPrevMessageID (pStrItemID ) ,out prevMessageID ;"

what is "Portal_GetNextMessageID"? If it is another stored procedure, then use EXECUTE instead of call.

Other as per Gill,...