The SUM1, SUM2, SUM3, and Ledger are table ALIASes.

-SQLBill

I wouldn't worry about the message then. Like I said, SQL Server creates that message based on the size (length) of the column. It compares the NVARCHAR(50) to the...

Vinny,

Thanks for the reminder, but I set the SA account and my account is a Windows account with SQL Server sysadmin privileges. My problem was my method of testing....

You decide. But here is some information on which to base your decision.

Before. Doing a full backup before truncating, ensures that you can return the database to its original...

Brian and everyone else,

Thanks for the input. It looks like I shot myself in the foot by using DENY ACCESS on the account to test it and that if I...

I believe you are getting that message because the two fields are of different size. Your NVARCHAR is 50 characters but DATETIME is only 8 bytes. SQL Server doesn't...

Also, we probably should add....this is a SQL Server site, not a DB2 site. The two SQL versions are different. JKSQL provided you the syntax for SQL Server.

-SQLBill

JKSQL DID give you the exact syntax. Pay attention, here it is again:

Select Sum1,Sum2,Sum3,

From

(

(SELECT sum(LDGR_BAL_AM) as [Sum1]

FROM DEVL8SGA.A_SGA_GRP_PSTN_SNP

WHERE ACCT_GRP_NO ...

Does it give an error or just return the data incorrectly?

_SQLBill

If it's VARCHAR, you might try:

SET MDY

SELECT BirthDate

FROM tablename

ORDER BY CONVERT(DATETIME, BirthDate) ASC

-SQLBill

For backups, I use the 'native' SQL Server backup commands to backup my databases and logs to disk (free). Then I use Veritas Backup Exec to copy the backup file...

What DATATYPE is your column? If it's VARCHAR, it will sort by dictionary sort.

1

11

12

2

3

4

etc.

If it's DATETIME, you could try:

SELECT CONVERT(VARCHAR(10), BirthDate, 101)

FROM tablename

ORDER BY BirthDate ASC

-SQLBill

Not only isn't there a query, but it looks like it's a repeat.

-SQLBill

Yes, I know of Brian Knight. I would suggest checking out the articles on this website. You can check out articles by specific authors or just all the articles....

What is the job that is failing? Is it trying to do a backup? If so, could the backup file be in use at the time? Could it be trying...