Viewing 15 posts - 661 through 675 (of 1,082 total)
HI there,
You missing a closing bracket after you 'CONVERT(VARCHAR(5),@____'
AT the end you need a ')'
thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 5, 2008 at 9:18 am
Thanks G,
I was going to actually post something to ask which was a better performer 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 5, 2008 at 9:12 am
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
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 5, 2008 at 9:03 am
thanks again Jack,
This is great, means I get to introduce a whole new world in my knowledge base, can't wait 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 5, 2008 at 7:55 am
I worked out how to do it in VS, still hoping it can be done in SSMS
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 5, 2008 at 7:48 am
HI Jack,
One more question.
How can view what this package is doing?
Can it be viewed in SSMS?
thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 5, 2008 at 7:43 am
Thanks Jack that is awesome 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 5, 2008 at 7:39 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 5, 2008 at 7:33 am
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?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 5, 2008 at 6:55 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 5, 2008 at 2:23 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 4, 2008 at 10:25 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 4, 2008 at 9:58 am
Thanks for the explanation that's perfect 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 4, 2008 at 9:38 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 4, 2008 at 9:25 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 4, 2008 at 8:49 am
Viewing 15 posts - 661 through 675 (of 1,082 total)