Viewing 15 posts - 5,041 through 5,055 (of 6,041 total)
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 2, 2012 at 8:34 am
CELKO (8/12/2010)
jhood (8/10/2010)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 2, 2012 at 7:56 am
haiao2000 (10/29/2012)
Eric M Russell (10/29/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 30, 2012 at 9:09 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 30, 2012 at 7:05 am
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,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 29, 2012 at 9:10 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 29, 2012 at 8:28 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 29, 2012 at 8:06 am
rf44 (10/25/2012)
Eric M Russell (10/25/2012)
rf44 (10/25/2012)
Msg 102, Level 15, State 1, Line 18
Incorrect syntax near '.'.
Line 18 is:
CROSS...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 26, 2012 at 7:31 am
rf44 (10/25/2012)
Msg 102, Level 15, State 1, Line 18
Incorrect syntax near '.'.
Line 18 is:
CROSS APPLY sys.dm_exec_sql_text(a.sql_handle) as b...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 25, 2012 at 2:32 pm
nevhancock (10/25/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 25, 2012 at 1:38 pm
gregory.anderson (10/25/2012)
What does the "query text" have to do with the stored procedure, and why is it so different between different runs?
The DMV dm_exec_query_stats returns cached query plans, and in...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 25, 2012 at 7:56 am
opc.three (10/23/2012)
Eric M Russell (10/23/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 23, 2012 at 3:26 pm
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,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 23, 2012 at 10:52 am
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....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 23, 2012 at 7:11 am
CptCrusty1 (10/19/2012)
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. ...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 19, 2012 at 7:42 am
Viewing 15 posts - 5,041 through 5,055 (of 6,041 total)