polkadot (8/15/2013)

---

Strange, I've got both installed (SSMS 2008 & SSMS 2012) and I'm definitely connecting to the one listed in my START menu as 2012, and even the Help->About dialogue...

jbowers (8/15/2013)

---

You state that the wizard method of project deployment "is of course not suited to deploy projects to the production server". As someone who is just upgrading from SSIS...

mtassin (8/15/2013)

---

Hey Koen,

Nice article. I hope you'll at some point discuss the headaches of managing the execution logs of projects deployed to SSISDB. 🙂

Especially with the headaches that...

Have a look here[/url].

I can't easily reproduce this error, so couldn't test this.

If you put the select in a try/catch block, is control passed to the catch block when the table is not...

BOR15K (8/12/2013)

---

I will rephrase my question then, is there is a way, using T-SQL to add an additional row, which will be a summary for each client? As far as...

BOR15K (8/12/2013)

---

There is no 80 points and there is sample data - WITH statement runs and works perfectly (I understand you haven't tried it).

I do know that SQL is not...

whereisSQL? (8/12/2013)

---

That is correct. There is no requirement to break it up other than to check if max(split_field_column_length)<128.

If max length is exceeded, I want to just read up to max...

It's because Excel thinks it knows what you want: so that even when you ask for...

Try this. Thanks to Jeff Moden (and probably others) for the compounding CTEs.

WITH E1(N) AS (

...

I've had a brief look into my crystal ball, but for some reason it won't show me the query which you have used, nor the data in your source tables.

It...

whereisSQL? (8/11/2013)

---

I have an excel sheet being imported with 8 columns. One column (say name)has comma delimited string.

Difference with most other posts.. is that the 1 column that has the...

Presumably the students are not using SSMS as their input tool.

Whatever front end they are using should perform this validation either by calling appropriate stored procedures or executing the...

You could try outputting to a CSV file and then importing that.

Great.