Here is what I've done in the past for supplying complex multi-values parameters to a reporting stored procedure.

The user specifies various options for ad-hoc reporting into a form. The...

CELKO (8/12/2010)

---

jhood (8/10/2010)

---

I see what you are saying Jeff, but would you want to do validation if the application did not allow the end user to send invalid data? perhaps...

haiao2000 (10/29/2012)

---

Eric M Russell (10/29/2012)

---

Instead of calling the job explicitly, you could have a job that runs every five minutes or so, polls a table to see if any works...

The danger in using acronymns like "OMG" and "TTYL" in your business correspondence is that your clients and coworkers will stop taking you seriously and laugh at you behind your...

Instead of calling the job explicitly, you could have a job that runs every five minutes or so, polls a table to see if any works needs to be done,...

In addition to expressions, you can reference user defined functions or non-deterministic functions for a column default.

However, a default can't reference other columns in the table, you would need...

Some these commonly used acronyms (like FUBAR) are vulgar. There is a potential for a text-to-speech or language translation software to sound out the root words literally, which is something...

rf44 (10/25/2012)

---

Eric M Russell (10/25/2012)

---

rf44 (10/25/2012)

---

Any idea why, when I try to use it, I receive a message:

Line 18 is:

CROSS...

rf44 (10/25/2012)

---

Any idea why, when I try to use it, I receive a message:

Line 18 is:

CROSS APPLY sys.dm_exec_sql_text(a.sql_handle) as b...

nevhancock (10/25/2012)

---

When I run this, the Name of the sp doesn't even exist in the db its matching to. The query text doesn't match the name either. All I was...

The DMV dm_exec_query_stats returns cached query plans, and in...

opc.three (10/23/2012)

---

Eric M Russell (10/23/2012)

---

Instead of separate denormalized columns, I'd rather contain user defined attributes in an XML column, preferably in a seperate extended type table. In the example below,...

Instead of separate denormalized columns, I'd rather contain user defined attributes in an XML column, preferably in a seperate extended type table. In the example below, each extended type (regular,...

Fraggle-805517 (10/19/2012)

---

...

Now, I don't know if this is really called parsing or replacing or something completely, different, but I have a hard time believing that someone hasn't done this before....

CptCrusty1 (10/19/2012)

---

Master Moden,

Absolutely she did... she rolled her eyes as dramatically as possible at the answers to her questions in that area.

Alas... She took a different offer. ...