Viewing 9 posts - 1 through 9 (of 9 total)
Chris,
Problem solved.
Your queries gave me the answer. The problem is the blank job number that was inserted on the day of the new server installation (the field should be NOT...
January 8, 2009 at 4:17 am
Chris,
I suddenly see the answer from the result of the second query. The job number is always unique except if there is a null job number field (which there...
January 8, 2009 at 4:07 am
Chris,
Here are the results:
Job_Date Count
1899-12-30 00:00:00.0004
Manifest_Date ...
January 8, 2009 at 3:58 am
Christopher Stobbs (1/7/2009)
Also could you post the queries that you expect are giving diff results.With samples of how the results are different. 🙂
Christopher, I have constructed a query that demonstrates...
January 8, 2009 at 12:26 am
Chris Morris (1/7/2009)
Exactly what do you mean by an 'empty date field', Richard? Surely this is NULL?
Chris, You are right, I probably should have said NULL. I was also trying...
January 7, 2009 at 3:59 pm
Nicholas Cain (1/7/2009)
Why not just set a default on the column for the date that you want?
Nicholas, This is an option, but it doesn't resolve the underlying problem. We need...
January 7, 2009 at 3:22 pm
As I delve further into this I find that query results are varying between stored procedures - some giving the correct default value and others not.
I will investigate further....
January 6, 2009 at 10:32 pm
Jeff Moden (10/7/2008)
proudfoot.richard (10/7/2008)
I got...
October 9, 2008 at 10:05 pm
Works in 2000, but I'm not sure that this works in 2005 which no longer permits table variables to be returned to a calling stored procedure?
I got round it by...
October 7, 2008 at 4:43 am
Viewing 9 posts - 1 through 9 (of 9 total)