crookj (8/19/2010)

Ray K (8/19/2010)

sing4you (8/19/2010)

crookj (8/19/2010)

Just note that...

Looks to me like all the crazy looping is date arithmetic. Try this as a replacement for the entire stored procedure - don't forget to put appropriate values into the...

drew.allen (8/19/2010)

This makes it seem like 1 is a special case when it's actually an exemplar...

Sure. If you remove the filter and instead mark the selected rows in the SELECT, you can see exactly what's happening...

DROP TABLE #VW_AE_SUS

CREATE TABLE #VW_AE_SUS (

PurchCode VARCHAR(5),

Provcode VARCHAR(5),...

Similar to French Connection UK?

Sorry to hear about PASS, Steve.

Hi Richard

Try changing the innermost select

SELECT PurchCode = LEFT(PurchCode, 3),

...

Hi Richard

Your sample output values don't appear to exist in the sample data, however something like this should do the trick:

SELECT PurchCode, Provcode, Duration, Seq, PartitionSize

FROM ( -- final

SELECT...

You're welcome.

Jack's post and invaluable explanation has already found a use here 😎

Run this, look at the columnname in the top resultset 🙂

DECLARE @command VARCHAR(MAX)

SET @command = 'SELECT GETDATE()' + CHAR(10) + 'go' + char(10) + 'SELECT GETDATE()'

PRINT @command

exec (@command)

Use ; as...

Here's the link to Jack's post:

http://www.sqlservercentral.com/Forums/FindPost964392.aspx

The post points out that it's the order of the ON clauses which changes the effect of the query, rather than the order in which...

Jack Corbett posted up a blog link recently which covered this, and the fact that the join sequence and the position of the ON clauses can have a profound effect...

There really is a song?

Richard

You're welcome, come back if you have any questions.

Cheers

ChrisM

Heh Jeff got that porkchop launcher loaded up for the first triangular join post? 😀

Ticky tack