Viewing 15 posts - 271 through 285 (of 3,348 total)
January 12, 2017 at 4:44 am
Grant Fritchey (1/11/2017)
GilaMonster (1/11/2017)
I really would like to attend Bits this year (hint, hint)DITTO!
(nudge, nudge, wink, wink).
I will definitely attend (present a precon so need to be there anyway). But...
January 11, 2017 at 7:41 am
Ed Wagner (1/11/2017)
Grumpy DBA (1/11/2017)
Manic Star (1/11/2017)
StoryNarrative
Subtext
Actor
January 11, 2017 at 7:38 am
Indianrock (1/7/2017)
January 7, 2017 at 9:09 am
GilaMonster (1/4/2017)
Hugo Kornelis (1/4/2017)
Note that both for the versions in your post as well as for the versions given by Eirikur, only some work correctly for nullable columns.
I don't think...
January 4, 2017 at 8:55 am
Eirikur Eiriksson (1/4/2017)
GilaMonster (1/4/2017)
Research for a blog post: What are the common forms of 'catch-all' / 'multi-parameter query' you've seen?
I've seen:
(Col = @C1 or @C1 is NULL)...
January 4, 2017 at 8:20 am
Manic Star (12/20/2016)
Ed Wagner (12/20/2016)
Stuart Davies (12/20/2016)
Ray K (12/19/2016)
DamianC (12/19/2016)
djj (12/19/2016)
TomThomson (12/19/2016)
whereisSQL? (12/19/2016)
crookj (12/19/2016)
Manic Star (12/19/2016)
djj (12/19/2016)
Revenant (12/19/2016)
ZZartin (12/19/2016)
Manic Star (12/19/2016)
whereisSQL? (12/19/2016)
Grumpy DBA (12/19/2016)
Manic Star (12/19/2016)
BaconKevin
Hart
Deer
Bullseye
Arrow
Crossbow
Zombie
Voodoo
Spell
Cast
Fish
chips
poker
Face
Off
Power
People
December 20, 2016 at 6:50 am
BLOB EATER (12/20/2016)
Hugo Kornelis (12/19/2016)
BLOB EATER (12/19/2016)
I am 90% sure that I will be going to sqlbits in April, anyone else know if they will be there?
I've been chosen to...
December 20, 2016 at 1:40 am
rodjkidd (12/19/2016)
Hugo I assume you will be submitting regular sessions?
Already did.
And thanks for the congrats!
December 19, 2016 at 4:13 pm
BLOB EATER (12/19/2016)
I am 90% sure that I will be going to sqlbits in April, anyone else know if they will be there?
I've been chosen to present a 400-level precon...
December 19, 2016 at 3:27 pm
Phil Parkin (12/16/2016)
I think you got hit by the infamous 'quote bug'. But don't let that prevent the additional coffee intake.
Which, for the record, occurs consistently when someone else posts...
December 16, 2016 at 7:41 am
**DELETED**
Made no sense because of quote bug, and would now no longer respond to the last post. Please ignore.
(I'm sure there are at least a few people who now think...
December 16, 2016 at 7:37 am
Manic Star (12/15/2016)
Ed Wagner (12/15/2016)
Grumpy DBA (12/15/2016)
Manic Star (12/15/2016)
AirplanesD. B. Cooper
Hijack
Lumberjack
Suspendies and a bra
December 15, 2016 at 2:09 pm
That's what the XML method .modify is for. Try the code below:
Declare @xmlVar xml =
'<planBean>
<intPlanID>1</intPlanID>
<intStatusID>2</intStatusID>
</planBean>';
Declare @SuppXml xml =
'<supplierGroup>
<intPlanSupplierGroupID>2</intPlanSupplierGroupID>
<intPlanID>1</intPlanID>
<supplierList>
<intSupplierID>3</intSupplierID> <intPlanSupplierGroupID>2</intPlanSupplierGroupID>
</supplierList>
</supplierGroup>';
SET @xmlVar.modify('
insert sql:variable("@SuppXml")
as last
into (/planBean[1])');
SELECT @xmlVar;
December 14, 2016 at 9:29 am
Jack Corbett (12/13/2016)
Any chance you could normalize the structure so the Yes/No columns are in a separate or separate table(s). Maybe...
December 13, 2016 at 10:46 am
Viewing 15 posts - 271 through 285 (of 3,348 total)