Viewing 15 posts - 271 through 285 (of 417 total)
Luis Cazares (6/18/2015)
Here's an example using AdventureWorks2012
SELECT a.AddressID,
a.AddressLine1,
a.AddressLine2,
...
June 19, 2015 at 9:33 am
paul.farnell (6/18/2015)
June 18, 2015 at 11:32 am
crookj (6/18/2015)
BL0B_EATER (6/18/2015)
Ed Wagner (6/18/2015)
TomThomson (6/18/2015)
Revenant (6/17/2015)
StuporDementia
Confusion
Mental
Case
Brief
June 18, 2015 at 10:02 am
Ed Wagner (6/18/2015)
TomThomson (6/18/2015)
Revenant (6/17/2015)
StuporDementia
Confusion
Psychic
June 18, 2015 at 9:45 am
What's surprising to me here is that no one has brought up the idea of using a source control system. sp_helptext is great if you want to see if...
June 18, 2015 at 9:21 am
** didn't see second page of topic and my question was already answered.
June 17, 2015 at 3:40 pm
djj (6/17/2015)
Ed Wagner (6/17/2015)
djj (6/17/2015)
Ed Wagner (6/17/2015)
Eirikur Eiriksson (6/17/2015)
ChocolateDark
Light
Sabre
Tooth
Tiger (I don't think I had a choice)
June 17, 2015 at 11:17 am
Jeff Moden (6/16/2015)
DonlSimpson (6/16/2015)
A calendar or "dimDate" table will make this a much simpler task.
How? He already supposedly has the dates he wants and just wants to number the...
June 17, 2015 at 11:15 am
pederson1234 (6/16/2015)
This is what my table looks like:
Customers
Name, Date
‘John’, ‘2015-01-01’
‘John’, ‘2015-01-02’
‘John’,...
June 16, 2015 at 4:25 pm
Ed Wagner (6/16/2015)
Narud (6/16/2015)
Eric M Russell (6/16/2015)
Revenant (6/16/2015)
Eric M Russell (6/16/2015)
Ed Wagner (6/16/2015)
Eric M Russell (6/16/2015)
Ed Wagner (6/16/2015)
BL0B_EATER (6/16/2015)
TomThomson (6/15/2015)
Ed Wagner (6/15/2015)
djj (6/15/2015)
Eirikur Eiriksson (6/15/2015)
Ed Wagner (6/15/2015)
Revenant (6/15/2015)
Ed Wagner (6/15/2015)
djj...
June 16, 2015 at 2:56 pm
Ed Wagner (6/16/2015)
crookj (6/16/2015)
BL0B_EATER (6/16/2015)
Ed Wagner (6/16/2015)
djj (6/16/2015)
Ed Wagner (6/16/2015)
BL0B_EATER (6/16/2015)
TomThomson (6/15/2015)
Ed Wagner (6/15/2015)
djj (6/15/2015)
Eirikur Eiriksson (6/15/2015)
Ed Wagner (6/15/2015)
Revenant (6/15/2015)
Ed Wagner (6/15/2015)
djj (6/15/2015)
crookj (6/15/2015)
GuzzledGin (reference to the late Red Skelton)
Rum
Captain
Picard
Packard
Automobile
Repair
Mend
patch
Update
Version
Stability
Strong
Odor...
June 16, 2015 at 10:47 am
djj (6/12/2015)
Ed Wagner (6/12/2015)
Revenant (6/12/2015)
Ed Wagner (6/12/2015)
crookj (6/12/2015)
ZZartin (6/12/2015)
Ed Wagner (6/12/2015)
BL0B_EATER (6/12/2015)
djj (6/12/2015)
ShapeMOLD
Fungus
Trip
Vacation
Family
Mafia
Godfather
Gun
Cannoli
June 12, 2015 at 11:08 am
g.britton (6/12/2015)
June 12, 2015 at 11:06 am
ZZartin (6/5/2015)
June 9, 2015 at 5:38 pm
Lynn Pettis (6/8/2015)
Personally, I think the query is correct. Masking of the subsequent sales amounts should occur in the front end application or report, not at the back end.
+1
It...
June 8, 2015 at 2:17 pm
Viewing 15 posts - 271 through 285 (of 417 total)