How about this?

;WITH SUM_CTE(K, SUM_AMOUNT)

AS

(

SELECT

K, SUM(MONEY) SUM_AMOUNT

FROM

AAA

GROUP BY

K

)

SELECT

K,

...

Glad to have helped you and happy that your issue is resolved 😉 😎

Cheers!!

Malavika, NO LOCK is a TABLE HINT which instructs Query Optimizer (QO) to do a thing in a different way from the way QO actually planned to do..

You can learn...

Yes we can, i have had 2005 and 2008 installed my machine 🙂

Cool, Paul! 🙂

Am not at my desk right now, so when i reach upstairs, i will work on your ask mate 🙂

Meanwhile, as u said , keep trying :cool:!!

Cheers!!

LOL, 😀

Yes there are other ways in doing it.. I will let u know...

Oh ok, u were talking about SET ROWCOUNT only!! OK, i thot u were mentioning about @@ROWCOUNT 😉

Thanks for your time and reply guys... I will...

Hello paul, dont feel embarassed ..

Did u try using my code, Paul?

Thanks Mate!!

Can u provide me a sample of using @@ROWCOUNT to filter the result set?

How about this code buddy??

This will select the rows of a column that dont contain characters from 0 to 9 and a to z

DECLARE @STRING TABLE (STRING VARCHAR(100))

INSERT ...

Hi Buddy,how about you going through this following article and helping us help you?? 🙂

CLICK HERE FOR FORUM POSTING ETIQUETTES - JEFF MODEN[/url]

When u do so, i am sure a...

Yes it will.. look at your...

Thanks Gianluca.. what if i dont have a order by clause? still the top operator is processed only after getting the result set?

Do u think SET ROWCOUNT will be...

Try this then buddy...

DECLARE @SQL VARCHAR(4000)

SET @SQL = ''

SELECT @SQL = @SQL + 'EXEC MASTER.SYS.XP_CREATE_SUBDIR N'''+ COLUMN_NAME +''''+ CHAR(10) FROM TABLE_NAME

PRINT @SQL

Tell us if this code worked for...

Hey Delinda..

Here is the code for you.. this will update if an match is found and will insert if no match is found between the tables..

Tell us if this worked...