Buddy, how are u trying to import it? BCP , BULK insert, SSIS package, how?

coool 😎

You're welcome mate 🙂

Will the below code help you buddy??

WITH MAX_DATE_FOR_A_MACHINE_CTE(MACHINE_NAME, MAX_DATE)

AS

(

SELECT

NAME

, MAX(DATE) MAX_DATE

FROM

...

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...