BowlOfCereal (11/7/2016)

---

Hi all,

Looking for some quick help with a bit of SQL. The best way I can describe it is that I'm trying to add 1 to the least...

MyDoggieJessie (11/7/2016)

---

Because in that route, while working with 100+ million rows and doing an insert into a temp table on several hundred columns wouldn't play well with tempdb and I...

Maybe the infamous DelimitedSplit8k[/url] is what you need.

MyDoggieJessie (11/7/2016)

---

Thanks for the comments guys (not sure why I'm not being notified about them)...

The table design is horrendous...in fact this is a rather small table 🙂 It's a...

John Mitchell-245523 (11/7/2016)

---

Steve

Yes, you were right to do so. I just...

Eirikur Eiriksson (11/7/2016)

---

When wrapped in a try/catch, the...

Take a look at this link[/url]. You'll see that checking the Keep Nulls option, in conjunction with table-level default constraints, should get you what you need.

Alternatively, if you cannot set...

berryber (11/5/2016)

---

Normally, googling and messing around, solves 99.999% of my IT (or relationship) problems. This one however, is giving me massive headaches.

Situation:

I have a package which runs over a selection...

From memory, there was quite a big change in file formats between 2008...

I...

Which is 2008, I think. The code was built for 2012, as has been mentioned in earlier comments.

Use a combination of ORDER BY and CASE.

7036golf (11/4/2016)

---

Having the same issues as

- no data in tables and the errors below

---------------Get all connections-----------------------------------

---------------Get all connections-----------------------------------

------------------------Get all variable details-------------------------------------

------------------------Get all variable details-------------------------------------

------------------------Get all...

Try this. Notice how the count is zero for the column containing all NULLs

IF OBJECT_ID('tempdb..#tmp', 'U') IS NOT NULL

DROP TABLE #tmp;

CREATE TABLE #tmp

(

...

SQL Code Guard[/url] may be of interest.