Viewing 12 posts - 61 through 72 (of 72 total)
I have the following table:
GEBIDLOAD_DTS LOAD_END_DTS
10017-7-2008 0:00:00 NULL
10028-7-2008 0:00:00 14-7-2008 0:00:00
100215-7-2008 0:00:00 NULL
100220-8-2008 0:00:00 NULL
10031-8-2008 0:00:00 NULL
100320-8-2008 0:00:00...
August 26, 2008 at 3:34 am
I have only had 1 chance to test the first suggestion by Hans, but it did not have the proper result. Looks like it gave the proper result for the...
August 23, 2008 at 4:18 am
Well, I was trying to prevent creating UDF's, cause this is just 1 example from many. Since this is allowed in VB, I hoped it would work in T-SQL.
But thanks...
November 9, 2007 at 5:21 am
The issue at hand is that SQL server 2000 does not provide the EXCEPT/MINUS set operators, so you need to roll your own construction to get at the missing combinations.
One...
May 31, 2007 at 2:39 pm
Post what you got in terms of SQL and perhaps we can think of some suggestions. I still think running the data through a stored procedure would be the best...
May 31, 2007 at 2:30 am
SQL alone is not quite suitable for this kind of query. Actually, it is not a real query in that sense.
What you need is a procedure that loops through the...
March 29, 2007 at 4:50 am
I am curious whether it is possible to capture executed SQL statements through this SQL trace manager?
We have a Cognos frontend and would like to investigate in the exact translation...
January 30, 2007 at 7:26 am
What did surprise me was the mentioning of Oracle 10g having the facility to choose between setting for either OLTP or DWH. I know DB2 tackled that many, many years...
October 19, 2006 at 1:30 pm
I found this:
http://support.microsoft.com/default.aspx/kb/811891/en-us
and:
http://support.microsoft.com/default.aspx/kb/822164/en-us
which only adds to the confusion. Can anyone of shed some light on this?
August 4, 2006 at 2:43 am
ann,
did installing fixpack 3 resolve the problem? I have exactly the same problem,so your experience with this one will be very beneficial!
Ties Blom
August 19, 2005 at 4:24 am
The author creates a novelle about the proverbial tip of the iceberg. In almost any life-case the resultset of a query is handled by application or reporting tool, so the...
May 19, 2005 at 7:18 am
Viewing 12 posts - 61 through 72 (of 72 total)