I tryed adding this statement with zero results
WHERE date >= (select DATEADD(year, 1, MAX(Date)) FROM dbo.[T01_TransactionMaster]) and date < (select Max(date)FROM dbo.[T01_TransactionMaster])

I'm adding it to...

I can not use the clause W

November 14, 2018 at 7:32 pm

#2013590

Is it possible to pull from date range from 12 months from the most recent transaction date  and the recent date.  Performance is not an issue because I would only...

the results:
131 1 25.00
650 2 50.00
7500 2 100.00
9608 2 25.00
10893 2 10.00
11227 2 20.00
12216 2 50.00
12497 2 25.00
16326 2 25.00
17028 2 200.00
18196 2 90.00
18230 1 500.01
19719 2 150.00
21091 2 20.00

I would like to add to this code.   I would like to reference another table with gift arrays.   I would like to compare the amount against the ask array table.  ...

I need a single top transaction for each account but if the first top transaction is 2 * more than the second top transaction then use the second top transaction. ...

I need a single top transaction for each account but if the first top transaction is 2 * more than the second top transaction then use the second top transaction. ...

If I want the year and month I would need to add the right and left.  correct

UPDATE [EC_StoreAttributes]

  SET AttributeValue = RIGHT(CONVERT(VARCHAR(10), GETDATE(), 101), 2)...

Can you help explain the script?  

Can you help explain this part of the script. 

SELECT modified_string=STUFF(LEFT(CONVERT(VARCHAR,GETDATE(),12),4),3,0,

This is the length that starts at position...

I'm getting an error message Incorrect syntax near the keyword 'Left'.