Viewing 15 posts - 541 through 555 (of 1,195 total)
PurpleLady (10/16/2014)
October 16, 2014 at 6:39 am
hakan.winther (10/16/2014)
Vimal Lohani (10/15/2014)
twin.devil (10/15/2014)
Comments posted to this topic are about the item <A HREF="/questions/unpivot/117130/">Unpivot</A>
HAHA,
Still wrong answer
admin has not tested it.
Answer should be two rows.
OrderIDProductNameProductQty
1 ...
October 16, 2014 at 2:37 am
Ed Wagner (10/15/2014)
Jim_K (10/15/2014)
Ed Wagner (10/15/2014)
Stuart Davies (10/15/2014)
SQLRNNR (10/14/2014)
Ed Wagner (10/14/2014)
SQLRNNR (10/14/2014)
Ed Wagner (10/14/2014)
crookj (10/14/2014)
SQLRNNR (10/14/2014)
djj (10/14/2014)
Ed Wagner (10/14/2014)
Stuart Davies (10/14/2014)
BWFC (10/14/2014)
Ed Wagner (10/13/2014)
djj (10/13/2014)
Ed Wagner (10/13/2014)
SQLRNNR (10/13/2014)
djj (10/13/2014)
SQLRNNR (10/13/2014)
DanishPastry
creme
Brulee
Fire
Torch
Singer
sewing...
October 15, 2014 at 6:21 am
BWFC (10/15/2014)
Am I being cynical in thinking that 'cracked it' means 'can't be bothered to provide sample data'?
Possibly, in the cases when I posed a question then found the answer...
October 15, 2014 at 6:01 am
Hi ,
I normally get that error if I try to use a variable without declaring it first.
e.g
set @startdate = getdate()
will cause the error, but;
declare @startdate smalldatetime
.........
set @startdate = getdate()
doesn't.
If...
October 15, 2014 at 12:57 am
SQLRNNR (10/14/2014)
Ed Wagner (10/14/2014)
SQLRNNR (10/14/2014)
Ed Wagner (10/14/2014)
crookj (10/14/2014)
SQLRNNR (10/14/2014)
djj (10/14/2014)
Ed Wagner (10/14/2014)
Stuart Davies (10/14/2014)
BWFC (10/14/2014)
Ed Wagner (10/13/2014)
djj (10/13/2014)
Ed Wagner (10/13/2014)
SQLRNNR (10/13/2014)
djj (10/13/2014)
SQLRNNR (10/13/2014)
DanishPastry
creme
Brulee
Fire
Torch
Singer
sewing (machine)
Needle
Thread
Doe
Buck
Rifle
shotgun
Venison
cow heart
Dissection
October 15, 2014 at 12:45 am
BWFC (10/14/2014)
Ed Wagner (10/13/2014)
djj (10/13/2014)
Ed Wagner (10/13/2014)
SQLRNNR (10/13/2014)
djj (10/13/2014)
SQLRNNR (10/13/2014)
DanishPastry
creme
Brulee
Fire
Torch
Singer
sewing (machine)
October 14, 2014 at 3:09 am
Sean Lange (10/10/2014)
SQLRNNR (10/10/2014)
hibernateparty
Line
October 13, 2014 at 12:53 am
SQLRNNR (10/7/2014)
Ed Wagner (10/7/2014)
TomThomson (10/7/2014)
whereisSQL? (10/7/2014)
Ed Wagner (10/7/2014)
crookj (10/7/2014)
Ed Wagner (10/7/2014)
BWFC (10/7/2014)
Ed Wagner (10/7/2014)
djj (10/7/2014)
Ed Wagner (10/6/2014)
whereisSQL? (10/6/2014)
Sean Lange (10/6/2014)
SQLRNNR (10/6/2014)
geoduckYummy!!!
Delicious
Taste
Bud
Spring
Pogo
Jump
Rope
Hang
Tight
Wad
Shot
bird
flu
October 7, 2014 at 8:56 am
venoym (10/6/2014)
Eric M Russell (9/30/2014)
GilaMonster (9/30/2014)
Eric M Russell (9/30/2014)
October 6, 2014 at 7:02 am
Ed Wagner (10/6/2014)
djj (10/6/2014)
Ed Wagner (10/5/2014)
SQLRNNR (10/5/2014)
piggeryGluttony
Sloth
Pride
London
October 6, 2014 at 6:16 am
Ed Wagner (10/2/2014)
TomThomson (10/1/2014)
SQLRNNR (10/1/2014)
brokenchain
Saw
Bones
October 2, 2014 at 5:40 am
BWFC (9/30/2014)
[snip]
'You work in IT, you run the website', said the committee.
'Err', said I.
I feel your pain - that's how I ended up with the website for my wife's workplace
October 1, 2014 at 2:48 am
It's quite common for me to copy a backup - not just the mdb / ldb files to my local pc to work on off line.
This works fine for me...
October 1, 2014 at 2:24 am
Viewing 15 posts - 541 through 555 (of 1,195 total)