Forum Replies Created
Viewing 15 posts - 56,476 through 56,490 (of 59,067 total)
-
RE: Dynamic export
I guess I'll never understand why folks try to push data into Excel when the "Get External Data" feature in Excel works so very well...
-
RE: declare table
Sam,
Recommend you read the following URL... especially Q3/A3 and Q4/A4...
http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k
... personnally, I only use a table variable if I can't use a temp table... that would be only in...
-
RE: isnull(@myvar, DEFAULT)?
Just curious... can Oracle supply the default as you've stated?
-
RE: Processing Comma Separated Lists
Thanks, Evan... appreciate the feedback. Just remember that with these types of things (cross tab), the whole result set must materialize before criteria will work on it (which is why...
-
RE: Processing Comma Separated Lists
I know, Serqiy... and I agree... I was just trying to avoid the UDF just for fun.
-
RE: isnull(@myvar, DEFAULT)?
You can code a default for each parameter passed to an SP... from BOL... does that help?
CREATE PROC [ EDURE ] procedure_name [ ; number ]
[ { @
-
RE: Processing Comma Separated Lists
Ok Evan, let's go way back to your original request... you have data that looks like this...
code_list_id
-
RE: Monitoring SQL Server Systems
I just noticed Matt's signature line... "A lack of planning on your part does not constitute an emergency on mine."
DBA's should hang a shingle that says "A lack of planning...
-
RE: Monitoring SQL Server Systems
Heh... funny how things come back to ya... "RBAR" is pronounced "ree-bar" and is a "Modenism" I posted quite a while back that means "Row By Agonizing Row"
-
RE: Monitoring SQL Server Systems
Yes... {MyAccount}{MyProfile} Change {FullName} under the contact information.
-
RE: isnull(@myvar, DEFAULT)?
Wait a minute! If you have a default on the column and you don't insert anything into it, then the column will have the default after an insert... why would...
-
RE: adding sequences to a values in a column
Like I said, that takes care of existing data... whatcha gonna do for new data that enters into the table?
-
RE: Processing Comma Separated Lists
Evan,
You mentioned "PL/SQL"... as you know, the SQL extensions between Oracle and SQL Server are quite different. Are you looking for an Oracle (PL/SQL) solution or an SQL Server (T-SQL)...
-
RE: isnull(@myvar, DEFAULT)?
What is the default value? That's what you have to put in the function. It can be a column name, another variable of the same or implicitly convertable type, or...
-
RE: adding sequences to a values in a column
Peter's method is absolutely a great way to take care of existing data. The problem is, wadaya gonna do with new data?
If you really need to do such a thing,...
Viewing 15 posts - 56,476 through 56,490 (of 59,067 total)