Viewing 15 posts - 286 through 300 (of 417 total)
Ed Wagner (6/8/2015)
djj (6/8/2015)
Ed Wagner (6/8/2015)
DonlSimpson (6/5/2015)
Eirikur Eiriksson (6/5/2015)
MonarchyEmpire
Republic
Plato
Socrates
Philosopher
June 8, 2015 at 11:01 am
That's really interesting. I did not realize there is a difference between having no clustered index, and having a disabled clustered index.
June 8, 2015 at 10:55 am
Eirikur Eiriksson (6/5/2015)
Ed Wagner (6/5/2015)
jasona.work (6/5/2015)
ZZartin (6/5/2015)
Ed Wagner (6/5/2015)
jasona.work (6/5/2015)
Ed Wagner (6/5/2015)
Revenant (6/5/2015)
SQLRNNR (6/5/2015)
Ed Wagner (6/5/2015)
BL0B_EATER (6/5/2015)
SQLRNNR (6/5/2015)
Eirikur Eiriksson (6/3/2015)
Ed Wagner (6/3/2015)
Eirikur Eiriksson (6/3/2015)
SQLRNNR (6/3/2015)
whileLoop
Eliminate
Kawasaki
Yamaha
piano
Organ
tube
subway
Traffic
Cone
Ice Cream
Float
Pennywise
:w00t:
Stephen King (It)
Monarchy
Empire
June 5, 2015 at 5:27 pm
yusufm 48726 (6/3/2015)
Sure I have attached it. This one looks ok but sometimes it gives me wrong value in between.241,174
17,433
118,157
14,077
12,295
2,866
Based on the attachment, it looks like you're grouping on DateEntered...
June 4, 2015 at 4:14 pm
Ed Wagner (6/4/2015)
Revenant (6/4/2015)
Ed Wagner (6/4/2015)
djj (6/4/2015)
WoollyWorm
Hole
Security
Clearance
June 4, 2015 at 4:07 pm
Lynn Pettis (6/4/2015)
HLogic (6/4/2015)
nycdotnet (6/18/2013)
June 4, 2015 at 1:31 pm
Ed Wagner (6/3/2015)
Eirikur Eiriksson (6/3/2015)
Ed Wagner (6/3/2015)
Eirikur Eiriksson (6/3/2015)
SQLRNNR (6/3/2015)
whileLoop
Eliminate
Kawasaki
Motorcycle
Freedom
June 3, 2015 at 2:49 pm
Hugo Kornelis (6/2/2015)
So the warning is absolutely valid - "do not use cursors" should not be interpreted as "find another way to iterate".
That may be the wisest comment in this...
June 2, 2015 at 10:23 am
cunningham (6/2/2015)
Ed Wagner (6/2/2015)
cunningham (6/2/2015)
Ed Wagner (6/2/2015)
crookj (6/2/2015)
Eirikur Eiriksson (6/1/2015)
Revenant (6/1/2015)
TomThomson (6/1/2015)
DonlSimpson (6/1/2015)
SprintBorland
Delphi[/quoteZeus
Mercury
Saturn
Megadrive
Sega (had to look that one up)
yeah that was it's name in Europe anyway!
Nintendo
Wii
June 2, 2015 at 10:10 am
Revenant (6/1/2015)
Ed Wagner (6/1/2015)
cunningham (6/1/2015)
whereisSQL? (6/1/2015)
Ed Wagner (6/1/2015)
Eirikur Eiriksson (6/1/2015)
djj (6/1/2015)
Eirikur Eiriksson (6/1/2015)
Ed Wagner (6/1/2015)
cunningham (6/1/2015)
Ed Wagner (6/1/2015)
cunningham (6/1/2015)
Ed Wagner (6/1/2015)
crookj (6/1/2015)
Ed Wagner (6/1/2015)
Revenant (6/1/2015)
cunningham (6/1/2015)
TomThomson (6/1/2015)
Ed Wagner (6/1/2015)
AwayA-weigh
Anchors
News
Facts
Statistics
Lies
politicians
Corrupt
FIFA
Sport
Version
License
Cost
Increase
Budget
blown
Timing
Stopwatch
Sprint
June 1, 2015 at 5:07 pm
patelxx (6/1/2015)
Hi Phil,What does the number 1 represent in brackets for the time data type - time(1)?
i.e. declare @Diff time(1)
That just defines the precision for fractions of...
June 1, 2015 at 4:55 pm
Ed Wagner (5/29/2015)
TomThomson (5/29/2015)
Revenant (5/29/2015)
Ed Wagner (5/29/2015)
cunningham (5/29/2015)
Ed Wagner (5/29/2015)
hughmanning (5/29/2015)
CentipedeMillipede
arthropod
Management (Couldn't resist :-D)
disaster
recovery
Restore
Habitat
May 29, 2015 at 11:28 am
Meatloaf (5/27/2015)
In hopes to simplify, here is my Pseudo code:
IF (vchDept='IT') THEN iDeptID=1
ELSE
IF (vchEmail like '%@abc.com' AND vchDept<>1) THEN iDeptID=2
ELSE
IF (vchEmail like '%@123.com' AND vchDept<>1) THEN...
May 28, 2015 at 10:12 am
It's nice to have a question I can do in my head once in a while.
May 27, 2015 at 10:04 am
Viewing 15 posts - 286 through 300 (of 417 total)