Viewing 15 posts - 5,941 through 5,955 (of 8,761 total)
For fun, here is a slightly different way of constructing the desired XML output
😎
USE tempdb;
GO
SET NOCOUNT ON;
GO
;WITH XMLNAMESPACES
(
'http://www.example-namespace.com' AS ns
)
,SAMPLE_DATA AS
(
SELECT * FROM
...
March 27, 2015 at 2:08 am
Quite simple really, here are the two scripts side by side
😎
--SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; ...
March 26, 2015 at 11:24 pm
Quick question, are you looking for a transparent encryption? Maybe its worth while looking at the likes of Corsair Flash Padlock 2 USB flash drive
March 26, 2015 at 3:10 pm
Ed Wagner (3/26/2015)
Jeff Moden (3/26/2015)
Eirikur Eiriksson (3/26/2015)
crookj (3/26/2015)
Eirikur Eiriksson (3/26/2015)
djj (3/26/2015)
Ed Wagner (3/26/2015)
SQLRNNR (3/26/2015)
djj (3/26/2015)
SQLRNNR (3/26/2015)
pursuitHot
blooded
Anger
Management
Board
Game
Theory
Practice
Perfect
Makes
March 26, 2015 at 2:12 pm
crookj (3/26/2015)
Eirikur Eiriksson (3/26/2015)
djj (3/26/2015)
Ed Wagner (3/26/2015)
SQLRNNR (3/26/2015)
djj (3/26/2015)
SQLRNNR (3/26/2015)
pursuitHot
blooded
Anger
Management
Board
Game
Theory
March 26, 2015 at 12:38 pm
djj (3/26/2015)
Ed Wagner (3/26/2015)
SQLRNNR (3/26/2015)
djj (3/26/2015)
SQLRNNR (3/26/2015)
pursuitHot
blooded
Anger
Management
Board
March 26, 2015 at 11:49 am
Ed Wagner (3/26/2015)
crookj (3/26/2015)
Ed Wagner (3/26/2015)
LightSaber
Star Wars
Dark
March 26, 2015 at 8:56 am
Sean Lange (3/26/2015)
This doesn't work. Create has to be the only statement in a batch. You would have to do that with dynamic sql inside your if block.
Good point, this...
March 26, 2015 at 7:28 am
sqlguy-736318 (3/25/2015)
Let's say I have a function named MyCustomFunction and I want to ensure that it exists in the database. Let's say I have a create script for the...
March 26, 2015 at 12:13 am
Quick question, if you run "net start" from a command window, what does it return?
😎
March 26, 2015 at 12:04 am
Eirikur Eiriksson (3/25/2015)
dwain.c (3/24/2015)
I'm a little confused by your examples though. You're using DATEDIFF in one bit of code and then CONVERT...
March 25, 2015 at 10:57 pm
Quick thought, the most efficient way is probably splitting on one of the two delimiter characters and remove the other delimiter character from the output. Manipulating the input is very...
March 25, 2015 at 10:29 pm
Ed Wagner (3/25/2015)
eccentricDBA (3/25/2015)
crookj (3/25/2015)
Ed Wagner (3/25/2015)
Eirikur Eiriksson (3/24/2015)
TomThomson (3/24/2015)
Eirikur Eiriksson (3/24/2015)
djj (3/24/2015)
Eirikur Eiriksson (3/24/2015)
Ed Wagner (3/24/2015)
Revenant (3/24/2015)
whereisSQL? (3/24/2015)
Eirikur Eiriksson (3/24/2015)
Ed Wagner (3/24/2015)
djj (3/24/2015)
Ed Wagner (3/24/2015)
djj (3/24/2015)
CatCaterpillar
Butterfly
Effect
Hurricane
storm
teapot
Boil
Steam
Ship
Deadline
Lifeline
Backup
Restore
Refurbish
Reinvent
Tune
Sharp
March 25, 2015 at 12:40 pm
dwain.c (3/24/2015)
I'm a little confused by your examples though. You're using DATEDIFF in one bit of code and then CONVERT in the...
March 25, 2015 at 2:38 am
SQLRNNR (3/24/2015)
Ed Wagner (3/24/2015)
SQLRNNR (3/24/2015)
Brandie Tarvin (3/23/2015)
Eirikur Eiriksson (3/23/2015)
GilaMonster (3/23/2015)
Eirikur Eiriksson (3/22/2015)
Now where is the Crystal Ball?😎
If you find it, I think this query can only be done if the...
March 24, 2015 at 3:58 pm
Viewing 15 posts - 5,941 through 5,955 (of 8,761 total)