Hi,

I'm not sure what your GetNums function looks like. I used the DelimitedSplit8K which you can find in the following article which explains how it works. http://www.sqlservercentral.com/articles/Tally+Table/72993

Here's my option for...

Something like this would help?

DECLARE @Datedate = GETDATE(),

@sql nvarchar(max)

SELECT @sql = (SELECT 'SELECT ''' + TABLE_NAME + ''', COUNT(*) FROM ' + TABLE_NAME + ' WHERE CreateDate >= ''' +...

Gary Varga (1/16/2014)

Luis Cazares (1/15/2014)

Tom Bakerman (1/15/2014)

Luis Cazares (1/15/2014)

In my experience, doing just enough to complete a job has resulted (most of the times) in errors that require extra work...

I just tried to reproduce...

Here's an example using the VALUES clause instead of UNION ALLs on the CROSS APPLY approach.

SELECT Part#, CustomerID, ca1.Wk_Num, ca1.Qty

FROM MyTable

CROSS APPLY (

VALUES(1,Wk1),

(2,Wk2),

(3,Wk3),

(4,Wk4),

--...

(52,Wk52)

) AS ca1(Wk_Num,...

Code examples are available in the links I provided. To get code examples that...

For unpviot, you might need to use a substring to get the week number and then cast it to the correct data type.

I have nothing to test, but it might...

I'm not sure about this, but you should think of migrating to 2012 for licensing issues. If Microsoft has removed the option to download it, it's very possible that it...

You can try UNPIVOT or CROSS APPLY VALUES[/url]

It really depends on what will work for you.

I guess this could help you get started and then follow a running total option such as the Quirky Update[/url].

SELECT ItemID, [InwardDate] AS [Date], [ItemName], [Qty] AS Inward, 0 ASOutward

FROM...

As I understood, it's not about consecutive lot_nbr values. It's about the groups for owner id resulting when you order by lot_nbr.

If you run the following query, it should become...

Here's an idea. Notice that I'm including DDL and sample data as you should have done to get faster and better answers.

I'm using a function that you can find in...

You have a cross join with dbo.dealer. Is that correct? I suggest you to change the syntax to have only ANSI-92 joins.

For better help, please post DDL and sample data...

You could use @@ROWCOUNT to validate resultset and GOTO or RAISEERROR to stop the procedure.

Tom Bakerman (1/15/2014)

Luis Cazares (1/15/2014)

In my experience, doing just enough to complete a job has resulted (most of the times) in errors that require extra work and more time invested...