HI there,

You missing a closing bracket after you 'CONVERT(VARCHAR(5),@____'

AT the end you need a ')'

thanks

Chris

Thanks G,

I was going to actually post something to ask which was a better performer 🙂

well when you put

GO

on the first line of a script that defines the end of a batch.

It will also mean that the variables leave scope etc.

Thanks

Chris

thanks again Jack,

This is great, means I get to introduce a whole new world in my knowledge base, can't wait 🙂

I worked out how to do it in VS, still hoping it can be done in SSMS

HI Jack,

One more question.

How can view what this package is doing?

Can it be viewed in SSMS?

thanks

Chris

Thanks Jack that is awesome 🙂

HI,

Here is another example using the new SQL 2005 UNPIVOT operator:

DROP TABLE #Temp

CREATE TABLE #Temp ([Code] VARCHAR(6), [Panel No] INT, [Bay No] INT, [Closing Code] CHAR(1),

[Test Product] VARCHAR(3), [Oil...

mmmm

Interesting , I'm pretty sure view have the same execution plan as the same query run outside the view.

Do you have test data for us to examine this?

OK if you create a temp table then do the first output into that temp table then you all the data in there to use to input into as many...

HI there,

try to look up the OUTPUT command in BOL

This will help you do the inserts without having to do a loop.

By the way to loop in SQL you can...

IS this sort of what you looking for?

DECLARE @Orders table

(Order_Number INT , Total_Cases INT)

INSERT INTO @Orders

SELECT 1,4 UNION ALL

SELECT 2,6 UNION ALL

SELECT 3,3 UNION ALL

SELECT 4,2 UNION ALL

SELECT 5,5

DECLARE @OrderLines...

Thanks for the explanation that's perfect 🙂

HI Jack,

Interesting article thanks.

I have a few questions.

Firstly our DB has Ansi_Padding Enabled = False

I take it this is the same as SET Ansi_Padding Off ?

IF the above is...

thanks

WOW I'm a bit embarressed that I never knew that SQL did out RTIMMING.

Maybe it's just that the environment that I work in before at the different padding setting...