Viewing 15 posts - 931 through 945 (of 1,493 total)
Do you want the manufacture date for each ItemID or max for BOM?
Are you concerned that an item could be from an older run, your initial 10 only 8 removed...
May 5, 2015 at 8:37 am
Are you able to get examples of the data you are searching?
May 5, 2015 at 7:13 am
Ed Wagner (5/4/2015)
Revenant (5/4/2015)
Ed Wagner (5/4/2015)
djj (5/4/2015)
Ed Wagner (5/4/2015)
crookj (5/4/2015)
Ed Wagner (5/4/2015)
Eirikur Eiriksson (5/4/2015)
djj (5/4/2015)
Eirikur Eiriksson (5/2/2015)
TomThomson (5/1/2015)
Revenant (5/1/2015)
Ed Wagner (5/1/2015)
whereisSQL? (5/1/2015)
Eirikur Eiriksson (5/1/2015)
Ed Wagner (5/1/2015)
Eirikur Eiriksson (5/1/2015)
crookj (5/1/2015)
SQLRNNR (5/1/2015)
totemTikki
Raita
Yogurt
Skyr
Lactose
Milk
Run
away
Train
Track
Racer
Snake
mamba
Poison
Dart
Frog
Tongue
Sharp
Point
May 5, 2015 at 7:09 am
Ed Wagner (5/4/2015)
crookj (5/4/2015)
Ed Wagner (5/4/2015)
Eirikur Eiriksson (5/4/2015)
djj (5/4/2015)
Eirikur Eiriksson (5/2/2015)
TomThomson (5/1/2015)
Revenant (5/1/2015)
Ed Wagner (5/1/2015)
whereisSQL? (5/1/2015)
Eirikur Eiriksson (5/1/2015)
Ed Wagner (5/1/2015)
Eirikur Eiriksson (5/1/2015)
crookj (5/1/2015)
SQLRNNR (5/1/2015)
totemTikki
Raita
Yogurt
Skyr
Lactose
Milk
Run
away
Train
Track
Racer
Snake
mamba
Poison
Dart
May 4, 2015 at 7:49 am
Eirikur Eiriksson (5/2/2015)
TomThomson (5/1/2015)
Revenant (5/1/2015)
Ed Wagner (5/1/2015)
whereisSQL? (5/1/2015)
Eirikur Eiriksson (5/1/2015)
Ed Wagner (5/1/2015)
Eirikur Eiriksson (5/1/2015)
crookj (5/1/2015)
SQLRNNR (5/1/2015)
totemTikki
Raita
Yogurt
Skyr
Lactose
Milk
Run
away
Train
Track
May 4, 2015 at 4:58 am
Ed Wagner (5/1/2015)
Eirikur Eiriksson (5/1/2015)
crookj (5/1/2015)
Ed Wagner (5/1/2015)
djj (5/1/2015)
Eirikur Eiriksson (5/1/2015)
Ed Wagner (5/1/2015)
UpDirection
Location
GPS
Garman
Brand
Recognition
Award
May 1, 2015 at 11:43 am
Eirikur Eiriksson (5/1/2015)
Ed Wagner (5/1/2015)
UpDirection
Location
May 1, 2015 at 6:13 am
Revenant (4/30/2015)
Ed Wagner (4/30/2015)
eccentricDBA (4/30/2015)
Ed Wagner (4/30/2015)
Revenant (4/30/2015)
crookj (4/30/2015)
Ed Wagner (4/30/2015)
SQLRNNR (4/29/2015)
Revenant (4/29/2015)
Ed Wagner (4/29/2015)
Eirikur Eiriksson (4/29/2015)
Stuart Davies (4/29/2015)
Eirikur Eiriksson (4/28/2015)
Ed Wagner (4/28/2015)
TomThomson (4/28/2015)
crookj (4/28/2015)
Ed Wagner (4/28/2015)
Revenant (4/28/2015)
SQLRNNR (4/28/2015)
TomThomson (4/27/2015)
SQLRNNR...
April 30, 2015 at 1:25 pm
Luis Cazares (4/30/2015)
By the way, you might be wanting to use DATEADD(day, -90, GETDATE()) if you want rows where time_created is previous to 90 days ago.
Good catch!
April 30, 2015 at 10:18 am
andrew_dale (4/30/2015)
we have a bought in database and looking at one table it has a clustered primary key involving two columns
ALTER...
April 30, 2015 at 5:50 am
Ed Wagner (4/29/2015)
Eirikur Eiriksson (4/29/2015)
Ed Wagner (4/29/2015)
SpaceDistance
Time
Continuum
April 29, 2015 at 1:18 pm
Ed Wagner (4/29/2015)
Revenant (4/29/2015)
Ed Wagner (4/29/2015)
Eirikur Eiriksson (4/29/2015)
Stuart Davies (4/29/2015)
Eirikur Eiriksson (4/28/2015)
Ed Wagner (4/28/2015)
TomThomson (4/28/2015)
crookj (4/28/2015)
Ed Wagner (4/28/2015)
Revenant (4/28/2015)
SQLRNNR (4/28/2015)
TomThomson (4/27/2015)
SQLRNNR (4/27/2015)
marlinspike
hall
fame
Fortune
Teller
Automatic
Tommy
Gun
Smoke
Mirrors
Reflect
surface
Depth
Measurement
April 29, 2015 at 9:38 am
Well I tried it and got 7 and 7.
create table #abc (a int, b int, c int);
INSERT INTO #abc values
(NULL,NULL,3),
(1,NULL,3),
(1,NULL,NULL),
(NULL,2,NULL);
Create table #xyz (x int, y int, z int);
INSERT INTO...
April 29, 2015 at 4:38 am
Viewing 15 posts - 931 through 945 (of 1,493 total)