Sounds like a data problem - you'll have to find the problems in your data first, and then decide how to deal with them.

Suggestions

1) Run your script without the...

....something like....

cast(date_start + left(hour_start,2)+':'+substring (hour_start,3,2)+':'+right(hour_start,2) as datetime)

You're probably going to have to cut up the time and insert colons, using the substring (and if you like, left and right) functions, so that you end up with...

My advice, for what it's worth, stick with SSIS - get the knowledge. I agree, it can be a pain (is frequently a pain), but it's matured a lot...

Not an issue for me...this has always been the behaviour of UNION.

I've often used

select c,b FROM #a

UNION

select c,b FROM #a

to eliminate / identify duplicates.

As for multiple UNIONs / UNION ALLs...

Interesting idea...but the article has a somewhat incomplete feel to it.

I notice that you never get beyond the 'Introduction' heading.

A little more explanation - perhaps a working example...and more importantly...

badOedipus (4/26/2013)

---

I'm posting on this old post mainly for completeness and to help anyone else out that has this same issue.

I'm not sure how far back this goes, but I...

Not on my sql box right now but...

I think there's something circular going on....e.g. A reports to B, B reports to A

Can you check your data? Also have you...

Then you can do as Lowell suggests...or something similar with sys.columns if you need to drill down further.

DML Triggers are for tables.

DDL Triggers are for the rest.

Are the databases on the same server?

have a google at DDL Triggers.

SQL_Surfer (4/5/2013)

---

David, I downloaded ultraedit. Is unicode file always shows in hexadecimal? I did what you suggested and when I click on 1 character, two bytes are highlighted. But when...

Does your notepad++ have a hex editor?

In Ultraedit I can see the hex value of the bytes, and I can clearly see in a unicode file that there are 2...

haiao2000 (4/5/2013)

---

David McKinney (4/5/2013)

---

I would tend to agree.

Do you have the option of creating a copy of the stored procedure with the variable declared as an int, and...