Well, it's probably somewhere else in your query or procedure. Can...

One thing that is missing from the query is ordering. Do you want the column names ordered alphabetically, or by their position in the table, or is random acceptable?

GSquared (11/16/2010)

---

Alvin Ramard (11/16/2010)

---

GSquared (11/16/2010)

---

Chris Morris-439714 (11/16/2010)

---

No idea, Wayne.

That really...

jcrawf02 (11/16/2010)

---

At the...

Think he'll PM you again for more help?

ps. (11/16/2010)

---

You either need to run profiler to capture the deadlock graph OR enable trace flag 1222 on your system

dbcc traceon(1222)

This will capture deadlock graph in the SQL Server's errorlog.

You...

Then I assume you will need to partition this by some other column (acct #?). Just ensure you have an appropriate index on the partitioning column(s) and the date column.

You'll...

I'd say that you've been overly patient. OP has posted the sample data numerous times in a completely unusable format, and...

Absolutely. It irritates me to see people that are complacent with what they know. However,...

jcrawf02 (11/15/2010)

---

Alvin Ramard (11/15/2010)

---

I'm definitely going to try to make it to that one, especially after not...

MAX(Audit_Date_Time) GROUP BY ClientNumber;

TOP (1) ORDER BY Audit_Date_Time DESC

SELECT ...

RN = ROW_NUMBER() OVER (PARTITION BY ClientNumber ORDER BY Audit_Date_Time DESC)

FROM view

...

BOL explains it pretty good

Duplicate post, please post all replies here

mj,

You're close, but to finish it up you need to utilize the CONVERT function, with the appropriate style for money datatypes.

DECLARE @test-2 TABLE (MoneyField money);

INSERT INTO @test-2 VALUES (1234567.5555);

SELECT REPLACE(CONVERT(varchar(20),...

I think you will want to add this expression to the filespec property:

"File-" + RIGHT("00"+ (DT_STR, 2, 1252) DAY( GETDATE() ), 2) +

...