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.

mrichardson 57577 (8/7/2013)

---

Can anyone help with this please?

I am trying to count all users in a table who are superusers (only if there is more than 1 super user).

TABLE: 'SuperUs'

FIELDS:...

Jeff's original suggestion (optional parameter to the stored procedure) really is the way to go here. I can't understand why you would choose the convoluted alternative over it.