Not only

It's SQL Syntax error not using the CAST function but SQL Syntax error NEAR the CAST function.

Would you mind to check commas in your statement?

NO CURSORS!!!

UPDATE Table1

SET FY500 =  DT.FY500 ,

FY1000 =  DT.FY1000 

FROM (

SELECT T1.memberID, T1.PeriodStart, T1.PeriodEnd,

case when SUM(T2.DonatedAmount) >= 500 then 1 else 0 end as FY500 ,

case when SUM(T2.DonatedAmount) >= 1000 then 1 else...

GETDATE() - 1  is actually 24 hours ago. So,it's everything happend after same time yesterday.

Any reason you shouldn't use this? You know better.

If you need start of today's day use...

GETDATE() is not a date. It's current moment of time. With precision of 3ms.

">= GETDATE()" means now or in future. Everything wat happened today before now is the past and...

EEEEW!

To write files people actually use bcp.

Remove open bracket after "SELECT"

What do you mean "proper"?

If there is a clustered index on Tabl2.Id?

Actually the structure you described repeates the structure of system tables sysobjects and syscolumns. And it takes no time...

Apply index on Tabl1.id, clustered index on (Tabl2.Id + Tabl2.col2)

And think again if you really need such fat recordset.

Problem is not in LEFT JOIN, problem is in application design.

What you wanted to trim?

I posted full script of your SP as it should be. With the correction from Jeff.

Is it too hard for you to Copy-Paste?

Thanks, Jeff.

You've got it 5 min before me.

CREATE PROCEDURE [dbo].[spCreateJonesReport]

@REPORTNUMBER VARCHAR(50)

AS

INSERT INTO INET.dbo.jones_report (ReportNumber, Adjuster, RGnameLast, ClientOffice, IOofficeName, WRworkOfficeID, WRid, Subject, FilterDate, ClaimNumber, VideoAmount, CaseCost, Results, WRinjury, WRnotes)

SELECT (@REPORTNUMBER, Adjuster, RGnameLast, ClientOffice, IOofficeName,...

F**k!!!

Stupid forum!!!

I spent half an hour writing a post about hungarian notation in TSQL and this thing wiped it out!

Sorry, have not time to repeat this exersise. The main idea...

The only point I see for disabling IDENTITY is to perform the favourite exersise of most of developers - "row by agonising row". Except those ones, of course, who is...