I believe that it's easier to use INFORMATION_SCHEMA views.

SELECT TABLE_SCHEMA,

TABLE_NAME,

COLUMN_NAME,

DATA_TYPE,

CASE WHEN DATA_TYPE IN( 'char', 'varchar', 'nchar', 'nvarchar') THEN '(' + CAST( CHARACTER_MAXIMUM_LENGTH AS varchar(10)) + ')'

WHEN DATA_TYPE IN('decimal', 'numeric') THEN...

If that works for you, then great. I tried this: (DT_DBTIMESTAMP)([Transaction Date] +" " + [Transaction Time])

And worked fine, but it depends on your local settings for dates. Your way...

Thank you Tom.

I knew you would come to correct me or explain further what I was trying to say. I totally agree with your post and it shows that...

Would something like this help?

WITH SampleData(String) AS(

SELECT 'plan type A change from plan type B from Plan type C' UNION ALL

SELECT 'Insurance plan M changed from Insurance plan b From...

Have you tested them? That's the best indicator.

Someone has made some tests for you. You could thank Gail, but...

Greg Edwards-268690 (3/18/2014)

---

Luis Cazares (3/18/2014)

---

Steve Jones - SSC Editor (3/18/2014)

---

jcrawf02 (3/18/2014)

---

Steve, I think you've just done this too much. Once you understand what you're trying to do, Conceptual and Logical...

I added some sample data to test the solution, but you should provide it for us on future occasions to get faster and better help.

WITH svkincd (slord, slline) AS(

SELECT 249486,...

Have you tried the EXCEPT clause? Do you have indexes in your tables?

Use DATEADD

declare @d1, @d2, @d3 datetime

...where @d1 between DATEADD(DD,-15,@d2) and DATEADD(DD,15,@d3)

Steve Jones - SSC Editor (3/18/2014)

---

jcrawf02 (3/18/2014)

---

Steve, I think you've just done this too much. Once you understand what you're trying to do, Conceptual and Logical blend quite a bit,...

I can't test this because my BIDS is not working, but you should end up with something like this:

(DT_DBTIMESTAMP)[Transaction Date] +" " + [Transaction Time]

You could check for other possible...

Try setting them as a String, because you can't add a dbtime to a date (don't ask me why, it's just the way they designed them). If you concatenate both...

What type are your [Transaction Date] & [Transaction Time] defined as? If they're not some kind of string, you might need to cast them before concatenating them.

andrew gothard (3/16/2014)

---

PHB...

If I understand correctly, you might be looking for something like this:

SELECT Division

,c2.Cat

,SUM( CAST( c.Value AS int)) Total

FROM #Document

CROSS APPLY( VALUES(1, SUBSTRING(Cat, 1, 1)),

(2, SUBSTRING(Cat, 2, 1)),

(3, SUBSTRING(Cat, 3,...