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...

Oi :angry:

I'm a Developer :crying:

---

Laugh... I nearly became a DBA 😛

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....

Ta-ra-ra Boom-de-ay ! :w00t:

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...

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)...

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...

Lynn Pettis (7/8/2009)

---

Is it just me or are others having issues when posting replies? I get application failures, but the replies still post. Quite troubling if you ask...

WOW!! IDMS now that takes me back a...

Make sure the destination folder exists and that the SQL Server service account has write access.

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...

RBarryYoung (7/1/2009)

---

WTF!?! I've been gone for 2 1/2 days and I'm 240 post behind of the thread? :w00t: ... well I sure there's something in here that's worth it!...

: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.' +...

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...

Welcome to my world :blink:

Roy Ernest (6/30/2009)

---

I can hold m ground...