My favorite trick to resolving most of the problems stated in this thread is to do a pre-aggregation in a Temp Table and go from there. It limits performance...

t.walker (3/9/2009)

---

SQL Server 2000 is fine for stuff written in the days of SQL Server 2000.

The basic point here is 'if it broke don't fix it'. If it is broken...

jparker2 (3/9/2009)

---

I have seen this issue with any code, and any variation of Oracle Versus SQL ever since the first Java interface for ODBC drivers was released.

It can be...

Chris Morris (3/9/2009)

---

Jeff Moden (3/7/2009)

---

Actually, in SQL Server 2k5, we don't need to solve the running total problem for this because it's just a ranking problem... this should do...

Yep... no need for the extra column...

SET @bcpcommand = 'bcp "SELECT ''"''+title,forename,surname,pafad1,pafad2,pafad3,pafad4,pafad5,pafad6,postcode,urn,emailaddress from ASHLEY.DBO.tablename" queryout c:\work\ashtest.txt -f c:\work\bcpformatfile.fmt -T'

arasan_lotus (3/9/2009)

---

hai..

actually I am new in sqlserver,

EXEC JPCFHONYVLDATA..xp_CmdShell 'Dir C:\'

when i execute above code ,I got "Could not locate entry in...

Bob Hovious (3/9/2009)

---

Yes, I remember that article. I'm old school, in that I think trust is something that has to be earned. It shouldn't be a...

GSquared (3/9/2009)

---

That is too funny! ...

If we can't get this bugger up and running in short order, we'll do the QUOTENAME thing for the export so we don't have to mess with the Format file......

Heh... dammit... I didn't test it and I forgot about that little nuance... My humble appolgogies...

Here's a new BCP Format file with no "skips"...

9.0

12

1 SQLCHAR 0...

Yow... sorry Flo... "OP" can mean either "the Original Poster" or the "Original Post" depending on how it's used in a sentance. And, it can also be a bit...

I don't mind so long as MS stops deprecating stuff... that's a bloody killer.

Heh... dangit, Andrew... you beat me to it. 🙂

The "+1100" indicates the time zone of the date. You may have to substract that as a number of hours and minutes from the date and that will give...

IF EXISTS(Select 1 from t_Names where id = 1234)

BEGIN

Select isNull(fName, 'N/A') from t_Names where id = 1234

END

ELSE

BEGIN

...