Viewing 15 posts - 811 through 825 (of 4,081 total)
You can direct the OUTPUT into a table or table variable for subsequent processing.
From BOL:
USE AdventureWorks2012;
GO
DECLARE @MyTableVar table(
EmpID int NOT NULL,
OldVacationHours int,
...
October 10, 2012 at 11:57 am
Good lord, a blast from the past.
John, have you discovered actual documentation for DBCC TIMEWARP?
September 21, 2012 at 12:34 pm
ScottPletcher (9/7/2012)
If you want precise control over shortening the results returned from a float column, there is always the ROUND() function.
If you want precise values, just use decimal to begin...
September 18, 2012 at 4:31 pm
I'm compelled to ask WHY you even feel the need to ltrim(rtrim()) floating point columns. Did you think they might have leading or trailing spaces?
Gail has...
September 7, 2012 at 4:12 pm
GilaMonster (8/24/2012)
It's potential energy is negative to the entire universe.
WHICH entire universe?
How about:
It's so low that it's at the bottom of every universe in the many-worlds interpretation.
August 25, 2012 at 10:17 pm
Lynn Pettis (8/6/2012)
SQLRNNR (8/6/2012)
Lynn Pettis (8/6/2012)
The Dixie Flatline (8/6/2012)
In that case I respectfully decline to volunteer.
It has to be a Monday, my mind immediately hit the sewer when I read...
August 7, 2012 at 9:40 am
CTEs actually do operate like views, they just don't persist for more than one query.
They are used like subqueries (or derived tables). But...
August 6, 2012 at 8:18 pm
In that case I respectfully decline to volunteer.
August 6, 2012 at 5:45 pm
The optimizer is choosing to scan the lookup table because it thinks that is the fastest way for it to deliver the data. Consider that for...
August 6, 2012 at 5:39 pm
Whenever you use NULL in an expression, the result is NULL.
A CASE statement should also work here.
SELECT Test, CASE WHEN Test = '?' THEN NULL ELSE Test END
FROM #Test
June 30, 2012 at 10:07 pm
RBarryYoung (5/24/2012)
Is it my imagination or is Paul getting younger?😀
Maybe he was experimenting with DBCC TIMEWARP and accidentally restored a backup copy of himself...
May 25, 2012 at 7:14 am
Lynn Pettis (5/23/2012)
AAARRRRRGGGGGGG!!!!!!!Really, he just needs to go away. He isn't helpful at all.
Hi, Lynn.
I'm enjoying a cruel chuckle at your expense. 😀
May 24, 2012 at 3:01 pm
Viewing 15 posts - 811 through 825 (of 4,081 total)