Viewing 15 posts - 856 through 870 (of 1,195 total)
try DATEDIFF ( datepart , startdate , enddate )
SELECT DATEDIFF (d,GETDATE(), '31 dec 2013') for example gives the result of 342
(Not to OP)
The first parameter (for completeness for usage of...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 23, 2013 at 8:38 am
Thanks for the question (and the point)
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 22, 2013 at 7:26 am
SQLRNNR (1/17/2013)
crookj (1/17/2013)
SQLRNNR (1/17/2013)
JAZZ Master (1/17/2013)
EL Jerry (1/17/2013)
SQLRNNR (1/17/2013)
crookj (1/17/2013)
SQLRNNR (1/17/2013)
Stuart Davies (1/17/2013)
crookj (1/17/2013)
Ray K (1/17/2013)
handyman (1/16/2013)
abackafront (affront?)
A-Top....
A-Team
Frankie Santana
carlos santana
Santana Moss
Kate Moss
The Matrix
SPOONS
Left Handed Wooden Spoon
Right handed 2 prong metal...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 17, 2013 at 3:48 pm
The interview I had for my current job was 3 part, technical phone then face to face technical / personal along with on line testing and lastly panel.
At each...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 17, 2013 at 8:58 am
crookj (1/17/2013)
Ray K (1/17/2013)
handyman (1/16/2013)
abackafront (affront?)
A-Top....
A-Team
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 17, 2013 at 7:56 am
Brandie Tarvin (1/17/2013)
paul.knibbs (1/17/2013)
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 17, 2013 at 6:36 am
jasona.work (1/14/2013)
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 17, 2013 at 1:22 am
Good question - thanks
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 17, 2013 at 12:48 am
Nice and straightforwards - thanks
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 16, 2013 at 12:46 am
Good question Wayne - thanks
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 15, 2013 at 12:49 am
anthony.green (1/11/2013)
SQLRNNR (1/10/2013)
amnestyinternational
Rescue
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 11, 2013 at 4:36 am
Thanks for the question - easy way to end the week
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 11, 2013 at 1:28 am
Thanks for the question Ron. Easy point today and without the need for coffee 🙂
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 10, 2013 at 1:30 am
Thanks for the question - and the easy point.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 9, 2013 at 1:50 am
DugyC (12/24/2012)
....
Having determined 1,4 & 5 were correct in SQL2008, thought maybe this...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 2, 2013 at 1:56 am
Viewing 15 posts - 856 through 870 (of 1,195 total)