Viewing 15 posts - 1,306 through 1,320 (of 3,544 total)
. (7/30/2009)
Currently I'm more of a mathematical concept than a name.
Whether the point be there
Or whether the point be not.
We'll point the point,
Whatever the point,
We'll point it,
Like it or not!
Far away is close at hand in the images of elsewhere.
Anon.
July 31, 2009 at 1:54 am
I had a similar problem with a third party database and driver. The error is as you stated are the invalid dates (as far as SQL Server is concerned) and...
Far away is close at hand in the images of elsewhere.
Anon.
July 29, 2009 at 2:13 am
Steve Jones - Editor (7/28/2009)
How about advanced pork chop aiming strategies for maximum developer damage?
Oi :angry:
I'm a Developer :crying:
Laugh... I nearly became a DBA 😛
Far away is close at hand in the images of elsewhere.
Anon.
July 29, 2009 at 2:04 am
GSquared (7/21/2009)
Alias Seasons 1 and 2....
My son bought me the entire boxed set of Alias :smooooth:
But my favourite and most watched DVD has to be Metropolis with Giorgio Moroder's music....
Far away is close at hand in the images of elsewhere.
Anon.
July 22, 2009 at 1:55 am
Grant Fritchey (7/14/2009)
No kaboom.
Ta-ra-ra Boom-de-ay ! :w00t:
Far away is close at hand in the images of elsewhere.
Anon.
July 15, 2009 at 6:53 am
Sorry for the problems, my bad. I did not test my last query as I posted in a hurry, I do not have 2008 and was mucking about on 2000/2005.
Your...
Far away is close at hand in the images of elsewhere.
Anon.
July 10, 2009 at 2:10 am
If you want to do several days then this will give you prices for July 2009. It will produce NULL for any date where no price is found.
SELECTb.[Date],p.Price
FROM(
SELECTc.[Date],a.Item,MAX(a.DateValue)...
Far away is close at hand in the images of elsewhere.
Anon.
July 9, 2009 at 9:09 am
I think there is a problem with the query. You select the latest time for the latest date upto and including the parameter date but then use the parameter date...
Far away is close at hand in the images of elsewhere.
Anon.
July 9, 2009 at 7:19 am
Lynn Pettis (7/8/2009)
Far away is close at hand in the images of elsewhere.
Anon.
July 9, 2009 at 2:07 am
Lynn Pettis (7/8/2009)
Think, I do, that our True Relational Fanatic may have new persona here on SSC.Anyone else have thoughts on this? 😉
WOW!! IDMS now that takes me back a...
Far away is close at hand in the images of elsewhere.
Anon.
July 9, 2009 at 2:04 am
Make sure the destination folder exists and that the SQL Server service account has write access.
Far away is close at hand in the images of elsewhere.
Anon.
July 6, 2009 at 7:48 am
1. The first SET @bcpCommand is malformed, it needs to be
SET @bcpCommand = 'bcp "select ''' + @CTX_TRAILER +'''" queryout "'
2. @CTX_TRAILER is char(2000) and @bcpCommand varchar(2000) therefore...
Far away is close at hand in the images of elsewhere.
Anon.
July 6, 2009 at 6:54 am
RBarryYoung (7/1/2009)
Far away is close at hand in the images of elsewhere.
Anon.
July 2, 2009 at 2:24 am
:blink: Mark beat me to it, but still my version
CREATE PROCEDURE [dbo].[sp_GetOverallStatus] @statusid int, @count int OUTPUT
AS
DECLARE @query nvarchar(1000)
BEGIN
SET NOCOUNT ON;
SELECT @query = 'SELECT @count = COUNT(*) FROM dbo.' +...
Far away is close at hand in the images of elsewhere.
Anon.
July 1, 2009 at 8:20 am
Without seeing the query it is difficult to give an answer.
However, assuming the query returns single value you could use a temp table to hold the result and then select...
Far away is close at hand in the images of elsewhere.
Anon.
July 1, 2009 at 6:40 am
Viewing 15 posts - 1,306 through 1,320 (of 3,544 total)