Viewing 15 posts - 4,276 through 4,290 (of 5,504 total)
How to generate tid? tid is a running no with prefix t000000000x
It depends. You could use ROW_NUMBER and a temp table or, if you need to get the ID based...
February 14, 2010 at 11:20 am
Copied straight from this post:
SSIS samples rows in Excel. It looks like it examines the first 8 rows.
Search for this phrase to learn more. 'ssis typeguessrows excel'
February 14, 2010 at 9:22 am
Where exactly did you get stuck?
Do you have difficulties to shred the xml data?
If so, the following might help you.
If you want us to do the complete work for you...
February 14, 2010 at 8:54 am
What is the result of the following query?
SELECT * FROM myTable WHERE myField like '%[^0-9]%'
It will return all rows that might cause problems when converting to INT.
Maybe this will help...
February 14, 2010 at 7:37 am
AFAIK there's no way to force a table to be hold in cache when using SS2K5.
SQL Server manages the cache internally and will hold data in cache if possible and...
February 14, 2010 at 7:23 am
Looks like I'm getting too addicted to CTEs... 😛
February 14, 2010 at 2:39 am
Jeff Moden (2/13/2010)
Lutz,I'm possibly missing the bubble here... why wouldn't the following two entries be added together for a single "period"?
SELECT '2','2','20090205','200','80' UNION ALL
SELECT '2','2','20090207','200','80'
I'm not the OP so I...
February 13, 2010 at 5:04 pm
Jeff Moden (2/13/2010)
...A bit anti-American and a bit over the top in any case for any international forum such as this.
Under the "given circumstances" (XXI. Olympic Winter Games just...
February 13, 2010 at 3:36 pm
Lynn Pettis (2/13/2010)
...Doc only gave me the 5 year warrenty...
You actually have doctors over there that'll give you any kind of warranty? Wow!
February 13, 2010 at 11:48 am
ChrisM@home (2/13/2010)
lmu92 (2/13/2010)
And here's what I came up with (@ Chris: yes, a bunch of CTE's again :-D)Who needs CTE's? 😛
Maybe someone who looks at execution plans and wonder why...
February 13, 2010 at 11:41 am
It's charity Saturday so I took the time to clean up the sample data you provided...
Additionally to the errors Chris already mentioned: there is no '4/31/09'. At least not in...
February 13, 2010 at 3:44 am
ChrisM@home (2/12/2010)
...I think it works with
INSERT INTO #Temptable EXECUTE (@Query)
but of course you have to create #Temptable beforehand.
@Lutz - that was too funny, man! 😀 Go home, have beer!
The...
February 12, 2010 at 3:38 pm
Es scheint, als ob nunmehr die jeweilige Muttersprache für Beiträge in "The Thread" genutzt wird. Ich bin mir nicht sicher, ob dadurch die Kommunikation vereinfacht wird... 😉
Translation for those who...
February 12, 2010 at 2:28 pm
I couldn't find an elegant way but here's what might work if you have to have a paramterized option for ASC/DESC:
DECLARE @SortOrder INT
SET @SortOrder=2
DECLARE @SortOrder2 INT
SET @SortOrder2=2
;WITH cte AS
(
SELECT...
February 12, 2010 at 2:18 pm
Arrgghhh!
My fault!
I totally forgot/overlooked/ignored that the EXEC() command will run under a separate session.. I'M SORRY!!!
One option would be to use a permanent table instead of a temp table. But...
February 12, 2010 at 1:41 pm
Viewing 15 posts - 4,276 through 4,290 (of 5,504 total)