Viewing 15 posts - 5,581 through 5,595 (of 8,416 total)
Written independently of Kingston's solution, this is my take on the recursive CTE, without ROW_NUMBER:
DECLARE @T
TABLE (
DateFrom ...
March 10, 2010 at 6:58 am
Roy Ernest (3/10/2010)
This OP does not want to fix the error... 🙂
Bizarre. I won't be contributing...;-)
Roy Ernest (3/10/2010)
And this is my 2000th post... 🙂
Congrats. You are now officially...
March 10, 2010 at 6:09 am
Hey Phil,
You are right - it doesn't seem sensible to include change details for the informational Date and User columns.
I have updated the example code to match - all I...
March 10, 2010 at 4:13 am
GilaMonster (3/10/2010)
Grant Fritchey (3/8/2010)
An unique index and a unique constraint are the same thing (in fact, creating a unique constraint creates a unique index).
Except for 2 points
Unique index can have...
March 10, 2010 at 2:12 am
xnl28-574517 (3/10/2010)
Before I populate a VARCHAR field from a NVARCHAR field, I want to check if it is possible to do without raising an error.
Converting Unicode to ASCII in SQL...
March 10, 2010 at 1:49 am
roelofsleroux (3/9/2010)
March 10, 2010 at 1:41 am
SELECT OC1.ordernum
FROM #orders_company1 OC1
INTERSECT
SELECT OC2.ordernum
FROM #orders_company2 OC2;
March 10, 2010 at 1:34 am
mjarsaniya (3/9/2010)
my dotnet application generate new records based on some criteria and it is always row by row.and i have to insert them same way one by one.
Can you not...
March 10, 2010 at 1:27 am
Whatever the requirements turn out to be, you can remove NULLs and get the data into an easy format with UNPIVOT:
DECLARE @T
TABLE (
...
March 10, 2010 at 1:24 am
WITH Selection
AS (
-- The Product History records to summarize
...
March 10, 2010 at 1:10 am
Roust_m (3/9/2010)
March 9, 2010 at 9:47 pm
Ok, so I'm going to proceed on the basis that you just want to see one row per product, and that row should contain values for just the columns that...
March 9, 2010 at 7:14 pm
Goldie Graber (3/9/2010)
Paul, why do you say your second query is better?
Compare the execution plans 😉
EXCEPT
NOT EXISTS
The SORT DISTINCT is omitted from the NOT EXISTS plan. Primary keys on...
March 9, 2010 at 11:58 am
Viewing 15 posts - 5,581 through 5,595 (of 8,416 total)