Viewing 15 posts - 4,666 through 4,680 (of 8,754 total)
To get the desired result set, we only need to do minor changes to the query, note that there is one "FOR XM" for each nesting level in the output.
😎
SELECT
...
August 22, 2015 at 1:21 am
Quick thought, script the restore rather than using same, it is straight forward and doesn't fail as the ui does. If you want I can dig up some of my...
August 21, 2015 at 9:52 am
TomThomson (8/20/2015)
whereisSQL? (8/20/2015)
Luis Cazares (8/20/2015)
DonlSimpson (8/20/2015)
CurvesLines
Parallel
Euclid
Relation
August 21, 2015 at 2:16 am
atulyan.aries (8/20/2015)
Hi Team,While trying to uninstall SQL 2012 I get the below error
sql server error the given key was not present in the dictionary sql 2012
Please help on this
Regards
Atulyan
Have you...
August 20, 2015 at 9:31 am
ARC211 (8/20/2015)
Date8/20/2015 12:55:50 AM
LogSQL Server (Current - 8/20/2015...
August 20, 2015 at 7:55 am
Ed Wagner (8/20/2015)
djj (8/20/2015)
DonlSimpson (8/19/2015)
Ed Wagner (8/19/2015)
Luis Cazares (8/19/2015)
Revenant (8/19/2015)
ZZartin (8/19/2015)
whereisSQL? (8/19/2015)
BL0B_EATER (8/19/2015)
WaterConservation
Fire
Alarm
Clock
Time
Fades
Grave
Dead
Terminal
August 20, 2015 at 5:34 am
Thank you Arun for this write up, good job.
😎
August 20, 2015 at 3:57 am
Quick static solution
😎
USE RDSTEEST;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'dbo.TBL_SAMPLE_DATA') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_DATA;
CREATE TABLE dbo.TBL_SAMPLE_DATA
(
ItemID INT ...
August 20, 2015 at 2:56 am
Sean Lange (8/19/2015)
August 19, 2015 at 10:08 am
Ed Wagner (8/19/2015)
djj (8/19/2015)
Eirikur Eiriksson (8/18/2015)
DonlSimpson (8/18/2015)
Revenant (8/18/2015)
whereisSQL? (8/18/2015)
TomThomson (8/18/2015)
Ed Wagner (8/18/2015)
SQLRNNR (8/18/2015)
Ed Wagner (8/18/2015)
ChrisM@Work (8/18/2015)
djj (8/18/2015)
Ed Wagner (8/17/2015)
Luis Cazares (8/17/2015)
whereisSQL? (8/17/2015)
Eirikur Eiriksson (8/17/2015)
Ed Wagner (8/17/2015)
eccentricDBA (8/17/2015)
whereisSQL? (8/17/2015)
DonlSimpson (8/17/2015)
OptimizerCost-based
low-cost provider...
August 19, 2015 at 5:44 am
DonlSimpson (8/18/2015)
Revenant (8/18/2015)
whereisSQL? (8/18/2015)
TomThomson (8/18/2015)
Ed Wagner (8/18/2015)
SQLRNNR (8/18/2015)
Ed Wagner (8/18/2015)
ChrisM@Work (8/18/2015)
djj (8/18/2015)
Ed Wagner (8/17/2015)
Luis Cazares (8/17/2015)
whereisSQL? (8/17/2015)
Eirikur Eiriksson (8/17/2015)
Ed Wagner (8/17/2015)
eccentricDBA (8/17/2015)
whereisSQL? (8/17/2015)
DonlSimpson (8/17/2015)
OptimizerCost-based
low-cost provider strategy
Low Quality
WYPIWYG
Consultant
Contractor
Temp
Intern
Affairs
Politicians
desk
Resolute
pig-headed
Trump
Hair
Ball
Bearing
August 18, 2015 at 10:58 pm
sgmunson (8/18/2015)
It appears that what's needed is a query that detects differences between the Steps table and the Processes table. How about this rather simplistic one?
Simple solution but not...
August 18, 2015 at 2:50 pm
drew.allen (8/18/2015)
Why do you use a CROSS APPLY here? You can do the same thing with an INNER JOIN, and I think that it's easier to follow.
You are right,...
August 18, 2015 at 2:44 pm
ShuaibV (8/18/2015)
Can you please let me know how we can replace the multiple values in a single select statement? I have to build the output based on values stored...
August 18, 2015 at 11:43 am
TomThomson (8/18/2015)
Jeff Moden (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Jeff Moden (8/14/2015)
Heh... since it's for XML...
Trying to put my finger on this, just cannot find which kind of XML phobia is plaguing you Jeff:Whistling:,...
August 18, 2015 at 11:27 am
Viewing 15 posts - 4,666 through 4,680 (of 8,754 total)