Viewing 15 posts - 18,001 through 18,015 (of 26,489 total)
The following meets your requirements:
CREATE TABLE #INBOUND_PLM_CHCM (PER_NR INT, [STATUS] INT, SOC_MAPPING VARCHAR(10))
INSERT INTO #INBOUND_PLM_CHCM (PER_NR, [STATUS], SOC_MAPPING)
SELECT 12345, 0, 'PLM-5000' UNION ALL
SELECT 12346, 3, 'PLM-5001' UNION ALL
SELECT 12347,...
December 10, 2009 at 4:21 pm
clive-421796 (12/10/2009)
WHERE
tbl.YourDateColumn >= @StartDate
AND tbl.YourDateColumn < @EndDate
I prefer to use:
WHERE
tbl.YourDateColumn between @StartDate AND @EndDate.
-------------------------
Have...
December 10, 2009 at 3:50 pm
Jeff Moden (12/10/2009)
Lynn Pettis (12/10/2009)
Jeff Moden (12/10/2009)
clive-421796 (12/10/2009)
December 10, 2009 at 3:32 pm
Jeff Moden (12/10/2009)
clive-421796 (12/10/2009)
December 10, 2009 at 3:22 pm
clive-421796 (12/10/2009)
December 10, 2009 at 3:06 pm
Alvin Ramard (12/10/2009)
Lynn Pettis (12/10/2009)
GSquared (12/10/2009)
Lynn Pettis (12/10/2009)
Roy Ernest (12/10/2009)
I dont fall under that category..I know nothing.... I know nothing... :w00t:
Dating myself here, but I actually hear Sgt Shultz from...
December 10, 2009 at 3:01 pm
Just an fyi, when doing date range comparisions, especially when the datetime column you are using also stores time values other than 00:00:00.000, the best method is like this:
...
WHERE
...
December 10, 2009 at 2:55 pm
GSquared (12/10/2009)
Lynn Pettis (12/10/2009)
Roy Ernest (12/10/2009)
I dont fall under that category..I know nothing.... I know nothing... :w00t:
Dating myself here, but I actually hear Sgt Shultz from Hogan's Heros! :w00t:
When you...
December 10, 2009 at 1:28 pm
Grasshopper (aka sk.panda ),
Would like a correct answer or just shots in the dark?
If you want a correct answer, please read and follow the instructions in this article[/url] and post...
December 10, 2009 at 1:22 pm
jcrawf02 (12/10/2009)
I'm 31 and I know Schultz, so you're not dating yourself that badly.Now if you actually knew him during the war, that would be dating yourself...:-P
Okay, I saw...
December 10, 2009 at 12:59 pm
Roy Ernest (12/10/2009)
I dont fall under that category..I know nothing.... I know nothing... :w00t:
Dating myself here, but I actually hear Sgt Shultz from Hogan's Heros! :w00t:
December 10, 2009 at 12:42 pm
Bru Medishetty (12/10/2009)
GSquared (12/10/2009)
Or fire up Windows Task Manager and take a look at what's running. But that might be too easy and too direct.
Gus, how to fire Windows...
December 10, 2009 at 12:39 pm
Alvin Ramard (12/10/2009)
GSquared (12/10/2009)
Roy Ernest (12/10/2009)
To be honest, There are lots of Indians here who give other Indians a bad name... 🙁
And plenty of Americans who give us a bad...
December 10, 2009 at 12:35 pm
It is my understanding, and I may be wrong, that SQL Server does not do short-curcuiting when evaluating the WHERE clause. If I am wrong, I'd welcome being corrected...
December 10, 2009 at 12:12 pm
CirquedeSQLeil (12/10/2009)
GilaMonster (12/10/2009)
Krasavita (12/10/2009)
I already have AWE check and I have Standard Edition.
If you have Standard edition of SQL 2000 then this entire conversation has...
December 10, 2009 at 11:54 am
Viewing 15 posts - 18,001 through 18,015 (of 26,489 total)