You've been here long enough to know not to cross-post. Replies here please.

Good question, and one which also went through my mind as I was...

Kristen-173977 (9/23/2015)

---

or @YesNo IS null)

I wish that SQL Server have a mode/flag/option that would moan about things like this ... on the occasions that they take hours to find the...

Chris Wooding (9/23/2015)

---

Yes, we've noticed that it frequently puts superfluous brackets around the default expression in the script so that the resulting constraint in the database doesn't match the project...

demin99 (9/22/2015)

---

I have a TSV File which has around 500+ columns.I want to import data from 20 columns (among 500) using SSIS. How should I handle this in SSIS..?

Appreciate...

Glad to help. But please...

If you take all those LEFT JOINs away, do you get a different result?

I mean, what happens if you try this?

select count(*)

from unit u

join ...

Sorry i should have been more clear , with not affected I mean the schema is not affected at the time of comparison , not deployment. Essentially

User 1 @ 0...

John Mitchell-245523 (9/21/2015)

---

Phil

I think it would be simpler. With Execute Process, you can use sqlcmd to execute the script from wherever it is. With another Execute SQL, you'd...

John, did you...

venkatesh.jonnagadla (9/21/2015)

---

If we use the ANSII in the odbcad32 setup while loading the data from Teradata to SQL server we won't get the super scripts in SQL server.

To Avoid this...

You could try using RAISERROR WITH NOWAIT, see link[/url].

Here it is again in clickable form

https://social.msdn.microsoft.com/forums/sqlserver/en-US/138fc2df-ff40-42a5-adc1-1b3f728737c2/sql-query-permutations-without-repetition

ChunkyLover1974 (9/20/2015)

---

Thanks Phil, I'll give that a try when I get back in the office tomorrow. But out interest, am I right in thinking that a derived column can...

Rather than a derived column, you should consider using a data conversion transformation.