Viewing 10 posts - 76 through 85 (of 85 total)
Incidentally, the view being queried casts the date as a DATE. It was originally a DATETIME. The query getting run by the .NET code then proceeds to use...
May 21, 2012 at 1:23 pm
Gullimeel,
The query definitely finished executing; it simply returned zero results.
May 21, 2012 at 1:21 pm
Thanks for the responses. I figured the function was probably causing this, but unfortunately, this is a query that is getting executed in our .NET code, and we'd rather...
May 21, 2012 at 1:20 pm
Nevermind, I did find a solution for this.
April 20, 2012 at 12:04 pm
Brandie,
Can you explain what you mean by this?
Also, why can't you just insert a placeholder row for every day and just update the times when employees actually clock in?
I...
February 22, 2012 at 11:02 am
Burninator,
This was exactly what I was looking for. Thank you!
January 13, 2012 at 2:10 pm
Thank you. This was definitely helpful.
December 21, 2011 at 1:05 pm
Kraig, your solution appears to work! Thank you!
It does return a duplicate for order detail record #5, but that is because both parent items are present in the order.
I...
December 12, 2011 at 7:36 am
sturner,
Thanks for the response. The problem with this result set is that it brings in both values for DetailID #4. There should be one value "No Group". ...
December 9, 2011 at 2:32 pm
Having read the "Forum Etiquette" page, here are the test tables:
--===== If the test table already exists, drop it
IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL ...
December 9, 2011 at 2:26 pm
Viewing 10 posts - 76 through 85 (of 85 total)