I must be missing something because I tried to execute this SQL and all I received was error 156 incorrect syntax near the keyword 'if'

stevefromOZ (7/20/2016)

---

Yes. Like i said though, the BillTo FK in the fact becomes superfluous though, because you can get to the analysis of BillTo simply by using the top level...

Steve that makes a lot of sense.

So my original fact table where the columns were:

factID

BillToCustomer

ShipToCustomer

OrderNumber

LineItem

.

.

.

Would become:

factID

BillTo/ShipTo Combination

OrderNumber

LineItem

Your suggestion to handle the ship-to analysis means that the fact table could...

I suspect this is buried, but...

Do any of the correct answers reflect a change in SQL Server 2012, or did the SELECT...INTO statement work the same way under 2008/earlier editions?...

happycat59 (1/15/2014)

---

Check whether the windows feature called "Desktop Experience" is enabled. You need this feature to be enabled to be able to write to sharepoint folders user UNC paths....

tsandeep, I had a client several months back where we needed some standard error handling logic.

My advice, spend a few hours Googling/Binging/whatevering for error-handling in stored procedures.

There are...

Well it's nice to see the query is optimized.

Do you get to maintain this, or are you trying to debug something that happened inside of it?

Who did you pi** off...

Hello Thomas -- a couple of comments on your query:

The move record to history section will write the entire contents of your dbo.Alert table, not just the rows upon which...

One additional link that refers to the Microsoft KB article:

http://connect.microsoft.com/SQLServer/feedback/details/606786/concatenation-into-a-scalar-variable-using-linked-server-in-from-clause-fails-when-casting-or-converting-data

R. Brush, I think I understand how the KB article that Erland is citing applies here.

I do agree with you that this specific query doesn't use an ORDER BY clause...

Erland Sommarskog (8/26/2013)

---

R. Brush (8/26/2013)

---

SET @sql = ''

SELECT @sql = @sql + ' Truncate table ' + QUOTENAME(TABLE_NAME) + '; ' + CHAR(13)

FROM INFORMATION_SCHEMA.TABLES

WHERE...

When I ran your SQL on my machine, it produced the results you expected.

However, the database on which I ran the statement had the collation Latin1_General_CI_AS

When I ran your statement...

I had a situation similar to yours with batch processes, tables, and triggers attached to the tables.

1) Batch process updated tables

2) Tables had triggers attached

3) Triggers were...

I applaud the effort, except I have to ask why this function would be preferable to the following code:

Jeff Moden's CSV splitter[/url]

I have searched many resources, and it seems like...