You need to add the -b option to get sqlcmd to return a DOS ERRORLEVEL. From BOL for SQLCMD:

-b on error batch abort

Specifies that sqlcmd exits and returns a...

I'm not excel expert, but the query you attached is not complete. The code ends with a "," which tells me there is at least one more CTE that...

Can you post the real SP?

Here's an example I put together that works:

IF OBJECT_ID('tempdb.dbo.DateTest', 'U') IS NOT NULL

BEGIN

...

If the table is small you may not be able to remove any more fragmentation because of how the data is stored internally.

Do you have a "state" table where you can convert the state_id to the state code? If you do your code would look something like this assuming a dbo.state...

YOu need to make your parameter DATETIME, DATE, or DATETIME2 because you are getting the error trying to put 12/1/2079 into the parameter. If you aren't using the...

Sean Lange (11/12/2015)

---

Brandie Tarvin (11/12/2015)

---

Sean Lange (11/12/2015)

---

djj (11/12/2015)

---

Grant Fritchey (11/12/2015)

---

Still, could be fun. Build out a nested CTE inside a function, use the same table aliases over and over, don't...

As soon as I posted the question I started getting notifications. I just had several hours where I got none.

-Jack

Is anyone receiving forum notification emails? I'm not.

I'm still looking at the query to find a better way, but the "simple" answer is that you can't do:

CASE [column] when [value] and [other condition]

You have to do it...

ben.brugman (11/10/2015)

---

Thank you Jack and Gail,

Jack Corbett (11/9/2015)

---

I'm not sure why you need to rename the existing table in order to create the history table. I'd just...

Right-click on the source and select Show Advanced Editors. Then click on the Input and Output Properties tab, expand OLE DB Source Output, expand Output Columns, and select the...

1. Database corruption is almost always caused by storage hardware issues. You should be talking with your storage admins in addition to your VM admin to find out...

Anton Bardin (11/8/2015)

---

Hi everyone,

I am trying to import attendance data from MS Access DB to MS SQL 2012 with SSIS. Access staff table has text field with IDs matching MS...

1. Execute SQL Task that truncates Server2.Staging1

2. Dataflow task that reads all the data from Server1.Source1 and loads into Server2.Staging1

3. Execute SQL task that loads Server2.Destination1 using a query...