Great! Good for you! 🙂

I assume there was question you wanted to ask, or you were just letting us know? 😀

My guess is that SSIS is converting the column.

If you run this code:CREATE TABLE #temp (create_date DATE)

INSERT INTO #temp

SELECT 20120501

You get an error... right? Why do you think that it...

ilike doing these types of things in steps to verify what I have done:

USE test

CREATE TABLE #test (gobbledegook VARCHAR(30))

INSERT INTO #test

SELECT '*12345'

UNION ALL

SELECT '*6789-hir'

UNION ALL

SELECT 'hello-john'

SELECT gobbledegook, CHARINDEX('*', gobbledegook, 1)

FROM...

Replace

SET @OneMonthBackDate = CAST(DATEADD(mm, -1, GETDATE()) - DAY(GETDATE()) AS DATE)

with this:

SET @OneMonthBackDate = CAST(DATEDIFF(D,0,DATEADD(mm, -1, GETDATE()) - DAY(GETDATE())) AS DATETIME)

SS999 (3/27/2012)

---

Hi Elutin,

I m trying to execute ur code to test and i get this error.

Msg 243, Level 16, State 1, Procedure Select_QuotestoBind_TestSample, Line 9

Type DATE is not a defined...

I think we are...

Again, the point being that as soon as you logged off of SQL Server, something created a connection. You should have found out what that was...

djustice 20821 (3/27/2012)

---

This is the code that I used:

ALTER DATABASE DB

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE

GO

DROP DATABASE db

GO

and the error that I got:

Msg 5064, Level 16, State 1, Line 1

Changes to...

SELECT mt1.col1,

mt1.col2,

mt1.b,

cnt.countInd

FROM #mytable1 mt1

...

Just guessing... but did you put the database into single user using the query window, then try to delete the database by right-clicking on it and selecting delete? (2 connections;...

That's not true...

How long does it take to just execute your cte portion?

SELECT --COUNT(*)

j.NameIDRef

, 0 AS SEQNUM

, ADR.GASTR# AS PREMISE

, A.PnxCodeValue AS PREFIX

, ADR.GASNAM AS STREETNAME

, B.PnxCodeValue as STREETTYPE

, ADR.GASQLF AS APTNO

,...

Find out what is using that process before doing anything and find out why it is still accessing the database.

Why are you trying to open that? The maintenance plan can be edited in SSMS.

Are you trying to do this on a client computer or the server? Your statements are...

Ok, now you just set all rows = 0 for seqnumber, and then you filter on that. Why? Take out that column in the cte and take out the...