This is a quick test on the date you would be using when run at different times. Are the values correct? Other than the formula, your code doesn't seem to...

Does this help a bit?

Select a.mycolumn,count(distinct(c.mycolumn))

from table1 a with (nolock)

inner join table2 b with(nolock) on a.id=b.id

inner join table3 c with (nolock) on a.mycolumn LIKE '%' + c.mycolumn + '%'

group by...

Have you checked BIML? it might help you create dynamic SSIS packages.

Stairway to Biml[/url]

If I understand correctly, this is a sample code base loosely on AdventureWorks database.

SELECT SUM(LineTotal)

FROM Sales.SalesOrderDetail d

WHERE d.SalesOrderID IN( SELECT i.SalesOrderID

...

If server is 5 hour ahead of CST, but you're still taking the time from the server. Why would you need to change the time? What time defines "today" and...

Less if using a template, or more if he's not...

Alan.B (5/2/2016)

terry999 (5/2/2016)

I got this error on a scheduled integrity check. SQL 2005 sp2

Data row does not have a matching index row in the index '' (ID 2). Possible...

Fluffy

If the procedure is stopped and it's properly written, it might have to rollback everything that has been done. Because you're using a single transaction, right?

Just a small note....

I'm heading out of the office, but the solution is the same as the one I posted on this thread: http://www.sqlservercentral.com/Forums/Topic1782605-3077-1.aspx

Your data makes no sense. How do you define a relation between each fruit and its value?

There's no order in a table, you need additional values. Hopefully, this isn't a...

You just add an INSERT INTO between the CTE and the final SELECT.

WITH CTE AS(

SELECT Something

FROM Somewhere

)

INSERT INTO Destination

SELECT *

FROM CTE;

I understood this a little different from Smendle.

WITH CTE AS(

SELECT *,

ROW_NUMBER() OVER( PARTITION BY CUST_NUMBER, CAST(CASH_DRWR_DATE AS...

Did you modify the report? Or just the call?