vipin_jha123 (1/5/2016)

---

Hi All,

I have source flat file , I want to exclude the records containing below state.

I have created one variable which data type is string and value is as...

hartmann 74688 (1/5/2016)

---

Personally, I will continue to use datetime unless I need the additional accuracy afforded by datetime2. Why? Because datetime columns perform better and require less disk space than...

I spotted a few minor typos:

"legacy tables that uses datetime" - use

"some developer simply" - developers

"8 byte of storage" - bytes

"ambigous" - ambiguous

"Let;s " - Let's

hartmann 74688 (1/5/2016)

---

pjdijkstra (1/5/2016)

---

We went back from Datetime2 to Datetime because when we saved the data to excel (from SSRS) Excel wouldn't interpret the Datetime2 fields as dates. We didn't...

Have you considered using Change Tracking?

The columns in a single result set cannot vary between rows.

But maybe you can create a simple result set containing something like (RecId Rownum Data) where the Data column is...

RonKyle (1/4/2016)

---

Yes, I'm sure. ...

RonKyle (1/4/2016)

---

Post is a little old, but I ran into this issue and the solutions offered didn't help me. So in the event someone else runs across this and...

Wow. That suggests you have written/tested 10,000 (or more) TVFs :w00t:

TheSQLGuru (1/4/2016)

---

lucien.jacquet (1/4/2016)

---

My point is not to contradict your assertion that scalar functions "can be" expensive, but to suggest that your example is a worst-case scenario. Is it possible that...

mw112009 (1/4/2016)

---

Please see the attached pic first.

I like to add an event handler and in that I could setup a SQL task to write to a table when a "SQL...

Thanks!

If it's a single-database process, SSIS is rarely a recommended way forward. I'd still put the code in a stored proc though, and use SQL Agent to execute that...

karen.blake (1/4/2016)

---

I have put this here as I am still learning about SSIS and have assumed I can do this using this.

So, there is a table where we need to...

Eirikur's response rendered what I was going to write mostly redundant. But I do have some minor points:

1) If you 'obfuscate' something, you make it unclear or difficult to interpret....

Eric M Russell (12/30/2015)

---

Orlando Colamatteo (12/30/2015)

---

Assuming the identity seeds were both 1, loading with IDENTITY_INSERT ON using the original identity *-1 (what Phil said) is where I would start the...