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.

Jayanth_Kurup (9/20/2015)

---

Phil Parkin (9/18/2015)

---

Jayanth_Kurup (9/18/2015)

---

VS or SSDT uses a version of the database schema to perform the comparison and not the actual database target itself. Its more of an extension...

The last row of what? What...

Jayanth_Kurup (9/18/2015)

---

VS or SSDT uses a version of the database schema to perform the comparison and not the actual database target itself. Its more of an extension of Data Tier...

Chris Wooding (9/18/2015)

---

We're using Visual Studio 2013 SSDT to generate deployment scripts for database changes and have found some strange behaviour.

The project has the following;

[ModifiedBy] CHAR (8)...

Beat me to it.

What I would also suggest is that you always schema-qualify your DB objects:

select dbo.ufnGetAccountingEndDate();

Steve Jones - SSC Editor (9/17/2015)

---

Brandie Tarvin (9/17/2015)

---

A few weeks back, we were talking about password managers. Someone mentioned LastPass and I've been looking into it. But the odd thing...

Ok. Does your @sql begin with a use db statement? If not, please reread our original responses.

AarionSSQL (9/17/2015)

---

Hi All,

I am trying to use variables to generate the command:

USE DATABASE

GO

Code below:

DECLARE @DBName_Schema varchar(500)

SET @DBName = 'Test'

EXEC ('USE ' + @DBName )

GO

It does not seem...

BWFC (9/17/2015)

---

Phil Parkin (9/17/2015)

---

I'm with you, Jeff. Using the threat of leaving, directly or indirectly, as a means to increase your salary feels ethically wrong and akin to bribery. If...