Viewing 15 posts - 16 through 30 (of 417 total)
TomThomson (5/6/2016)
Ed Wagner (5/6/2016)
Grumpy DBA (5/6/2016)
Ed Wagner (5/6/2016)
SoupStew
Braise
Steak
Grill
Don Simpson
May 6, 2016 at 8:49 am
Sean Lange (5/6/2016)
tripleAxe (5/6/2016)
Ed Wagner (5/6/2016)
Yes, we all know this by now and it was a simple mistake.
I agree. I don't undertand why some peoples get so upset...
Don Simpson
May 6, 2016 at 8:40 am
Ed Wagner (5/5/2016)
djj (5/5/2016)
Ed Wagner (5/5/2016)
Luis Cazares (5/5/2016)
Ray K (5/5/2016)
Ed Wagner (5/5/2016)
Eric M Russell (5/5/2016)
ThomasRushton (5/4/2016)
TomThomson (5/3/2016)
Ed Wagner (5/3/2016)
RandyThe Band
Bonzo
Garbonzo (the bean, otherwise known as chickpea)
Hummus
Garlic
Onion
Peppers
Chili
Capsaicin
Habanero
Don Simpson
May 5, 2016 at 4:42 pm
Phillip.Putzback (4/29/2016)
Is there a reason to use Row_number instead of dense_rank on the first column. It appears dense_rank did the same thing.
When TXID is unique, they will do the same...
Don Simpson
May 4, 2016 at 11:13 am
Manic Star (5/4/2016)
whereisSQL? (5/4/2016)
ZZartin (5/4/2016)
Ray K (5/4/2016)
Grumpy DBA (5/4/2016)
djj (5/4/2016)
ThomasRushton (5/4/2016)
TomThomson (5/3/2016)
Ed Wagner (5/3/2016)
RandyThe Band
Bonzo
Bozo (the clown)
Krusty (the clown)
Pennywise (the clown)
Turtle
Dove
Partridge (in a pear tree)
Beer (in a tree)
Don Simpson
May 4, 2016 at 10:18 am
Ed Wagner (5/2/2016)
Eric M Russell (5/2/2016)
Revenant (5/2/2016)
Ed Wagner (5/2/2016)
Luis Cazares (5/2/2016)
DonlSimpson (5/2/2016)
whereisSQL? (5/2/2016)
Ed Wagner (5/2/2016)
Grumpy DBA (5/2/2016)
eccentricDBA (5/2/2016)
Ed Wagner (5/2/2016)
Grumpy DBA (5/2/2016)
crookj (4/29/2016)
whereisSQL? (4/29/2016)
FreakQuasimodo
Hunchback
Notre Dame
Fighting Irish
Rudy!
New York
Yankees
Rebels
Empire
Death Star
Tractor [beam]
[Mr.] Data
Android
IOS
Don Simpson
May 2, 2016 at 11:35 am
whereisSQL? (5/2/2016)
Ed Wagner (5/2/2016)
Grumpy DBA (5/2/2016)
eccentricDBA (5/2/2016)
Ed Wagner (5/2/2016)
Grumpy DBA (5/2/2016)
crookj (4/29/2016)
whereisSQL? (4/29/2016)
FreakQuasimodo
Hunchback
Notre Dame
Fighting Irish
Rudy!
New York
Yankees
Rebels
Don Simpson
May 2, 2016 at 9:30 am
You can try this:
declare @t table (TXID varchar(10), AccountID int)
insert @t
(TXID, AccountID)
values
('3fsd3', 12), ('fdgd', 12), ('23da', 12), ('34fa', 13), ('324c', 13), ('vcvdfg', 44)
select t.TXID,
t.AccountID,...
Don Simpson
April 29, 2016 at 3:18 pm
whereisSQL? (4/29/2016)
Luis Cazares (4/29/2016)
Ed Wagner (4/29/2016)
djj (4/29/2016)
ThomasRushton (4/29/2016)
whereisSQL? (4/28/2016)
TomThomson (4/28/2016)
Revenant (4/28/2016)
Ed Wagner (4/28/2016)
RecorderFlute
Whistle
Dog
Food
Bacon
Goodness
Divine
Intervention
Imperialism
Don Simpson
April 29, 2016 at 10:04 am
TomThomson (4/28/2016)
ZZartin (4/28/2016)
crookj (4/28/2016)
FlashLevitt
Fresnel
Lighthouse
Don Simpson
April 28, 2016 at 8:57 am
whereisSQL? (4/27/2016)
crookj (4/27/2016)
Ed Wagner (4/27/2016)
djj (4/27/2016)
ThomasRushton (4/27/2016)
Ed Wagner (4/27/2016)
djj (4/27/2016)
Stuart Davies (4/27/2016)
crookj (4/26/2016)
Manic Star (4/26/2016)
Luis Cazares (4/26/2016)
Ed Wagner (4/26/2016)
whereisSQL? (4/26/2016)
Ed Wagner (4/26/2016)
Luis Cazares (4/26/2016)
Ray K (4/26/2016)
Ed Wagner (4/26/2016)
SongMusic
Sound
Waves
Ride
Horse
No Name
Rain (felt...
Don Simpson
April 27, 2016 at 9:05 am
Revenant (4/26/2016)
Ed Wagner (4/26/2016)
Ed Wagner (4/26/2016)
djj (4/26/2016)
ThomasRushton (4/26/2016)
DonlSimpson (4/25/2016)
Ed Wagner (4/25/2016)
eccentricDBA (4/25/2016)
Ed Wagner (4/25/2016)
djj (4/25/2016)
Revenant (4/25/2016)
TomThomson (4/25/2016)
Ed Wagner (4/25/2016)
DrivePutt
Green
Red (for our Canadian friends)
Harold (I'm American, but I know the show)
Duct...
Don Simpson
April 26, 2016 at 9:21 am
Ed Wagner (4/25/2016)
eccentricDBA (4/25/2016)
Ed Wagner (4/25/2016)
djj (4/25/2016)
Revenant (4/25/2016)
TomThomson (4/25/2016)
Ed Wagner (4/25/2016)
DrivePutt
Green
Red (for our Canadian friends)
Harold (I'm American, but I know the show)
Duct Tape "the handyman's secret weapon"
Possum Van
Dodge
Don Simpson
April 25, 2016 at 5:19 pm
Posting the schema of the table will be helpful. How do you determine the order of the rows?
Don Simpson
April 22, 2016 at 12:29 pm
Grumpy DBA (4/22/2016)
ThomasRushton (4/22/2016)
Ed Wagner (4/22/2016)
SecurityObscurity
Inconspicuous
Spook
Don Simpson
April 22, 2016 at 8:58 am
Viewing 15 posts - 16 through 30 (of 417 total)