Do you want numeric values or integer values (whole numbers)? Based on the images you shared you want only integers.

Do you want to do it in SQL or SSIS?

If...

Apparently the source_code column in the source table contains NULL values which means you'd never match and also be an insert. You just need to exclude nulls from your...

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...