Forum Replies Created
Viewing 15 posts - 5,581 through 5,595 (of 8,416 total)
-
RE: using replication in development environment?
I vote yes to carpet.
-
RE: Removing overlapping rows based on dates
Written independently of Kingston's solution, this is my take on the recursive CTE, without ROW_NUMBER:
DECLARE @T
TABLE (
DateFrom ...
-
RE: Are the posted questions getting worse?
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...
-
RE: Compare 2 Tables
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...
-
RE: Question about unique constraint
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...
-
RE: parse Real data type
No worries. 🙂
-
RE: How to check if a field contains unicode data
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...
-
RE: Enormous Tables - How to still get Best Performance
roelofsleroux (3/9/2010)
The company are currently running SQL 2005 Standard Edition, but looking into the future they will invest in SQL 2008 Enterprise. Will this mean that some of the mentioned... -
RE: t-sql help
SELECT OC1.ordernum
FROM #orders_company1 OC1
INTERSECT
SELECT OC2.ordernum
FROM #orders_company2 OC2;
-
RE: procedure or direct query?which one is best
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...
-
RE: select all field except field wich have NULL value
Whatever the requirements turn out to be, you can remove NULLs and get the data into an easy format with UNPIVOT:
DECLARE @T
TABLE (
...
-
RE: Compare 2 Tables
WITH Selection
AS (
-- The Product History records to summarize
...
-
RE: CLR, to be or not to be, that is the question!
Roust_m (3/9/2010)
Just one more question though. Does this method guarantee uniqueness? Let's say I convert 10 million different values, can some Hex values be the same for different... -
RE: Compare 2 Tables
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...
-
RE: Return data from one list which applies to all data in a second list
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...
Viewing 15 posts - 5,581 through 5,595 (of 8,416 total)