Glad to help. I ALWAYS wrap my procedures in BEGIN and END for clarity as well as to avoid issues like this.

Try this:

ALTER PROC [ShowInfo].[usp_GetShowsFromDate]

(@InputDate AS date = '19000101')

AS

BEGIN

IF @InputDate = '19000101'

BEGIN

SET @InputDate = CAST(GETDATE() AS date)

END

BEGIN

SELECT * FROM dbo.fn_GetShowsFromDate(@InputDate)

ORDER BY StartingDate;

END

END

As Lynn stated, we need the DDL for the export table and the import table. Looking at the error, it is telling you that the date columns are not compatible...

;WITH cte (BchCode, ClusterOffdBchCode, ClusterTrip,

ClusterAns, ClusterLess60Secs, ClusterGreat5Min) AS

(

SELECT ClusterOffdBchCode AS BchCode,

COUNT(ClusterOffdBchCode) AS ClusterOffdBchCode,

SUM(ClusterTrip) AS ClusterTrip,

SUM(ClusterAns)...

Hold on... Need to fix some syntax...

Try this, it is the best I can do without sample data and expected results:

Code fixed below

mark.doyle (4/19/2012)

---

Sorry i posted the question before i completed it

1st Select Statement

Select BchCode,

SUM(localOffd) As 'Local Offd Calls',

...

Lynn Pettis (4/19/2012)

---

I do have to say I liked Oracle's CREATE OR REPLACE. If the database object (view, stored procedure, function) already existed, it replaced it and if it...

S_Kumar_S (4/19/2012)

---

Ofcourse there is some extra code in script,but it makes sure that when i run it in different environments, it never fails.sometimes the proc may just not be there...

jonathanalvestad (4/19/2012)

---

I copied the database from that folder, and pasted it to a C:\DB\ folder.

The file itself is just named reservasjon.mdf, but whenever I attach it to SQL Server...

Geoff A (4/19/2012)

---

the downside to 2 IMHO, is that the drop will succeed and the the create will fail....

in option 1, if the alter fails, no harm no foul.

also, an...

Ya, just verified it. Change your row delimiter to , instead of {CR}{LF} and your done.

Welsh Corgi (4/18/2012)

---

I have this file and I need to load it into a single column TableName in a new Table.

It is AS400 Data. The system is hosted by someone...

No. Read committed will read the committed transactions, read uncommitted will read uncommitted and...

Don't use CDC. CDC is best for auditing, not for actually storing historical data. You could do a trigger that simply writes all information to a history table....