I was just about to respond with that - glad you figured it out.

Jay, you still are stuck with the idea that you need a datetime column for your query. Why? Is there a reason you believe you have to query...

Okay - this is rather a simple google search. I searched for 'SSRS dynamic data source' and the first item in this list is an article from this site.

The...

TheSQLGuru (1/29/2010)

---

I know a production DBA who just moved to a new job because he had gotten his former company so stable and everything running so routinely that he became...

Based on your original statement - I would recommend not even using an explicit transaction. Since this is an import process and you are wiping the data (truncating) and...

jrichards54 (9/2/2012)

---

Thank you Steve Jones. I have given up on SQL Server 2005 Developer Edition because after 4 installs it does not work and I was unable to get help...

You can download SSMS Express with Advanced Services - I believe that might come with the BI tools but not sure. If you are using this for development purposes,...

jerome.morris (9/2/2012)

---

To Make life easier is it possible to replace the date in StartDate_Time with the results returned from

Select StartDate, StartTime, convert(datetime, StartDate) + convert(datetime, StartTime) AS StartDate_Time

...

Okay - I have stripped...

So, you are getting the data as a distinct date and time. Putting that data into a date column and a time column would be appropriate - and you...

Not sure I understand - it probably would help if you showed us the data you...

jerome.morris (9/1/2012)

---

It gets better look at the create for the table

USE [SLADB]

GO

/****** Object: Table [dbo].[ProdDataTB] Script Date: 09/01/2012 12:27:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ProdDataTB](

[MachineName]...

View the history of the maintenance plan - and post the error from there.

CELKO (8/29/2012)

---

>> When running the script below I noticed that the two result fields [sic: columns are not fields] are of data type INTEGER. I would like to convert the...

Michael Valentine Jones (8/27/2012)

---

At a former job I managed backups for over 300 SQL Servers, and all of them were backed up to UNC locations on file servers dedicated to...