I guess it will probably depend on what output format you want. Are you simply printing a text file, or does it need to have some sort of formatting...

Is what you're doing just a partitioned running total? That's what it looks like.

Why not update all at once, and then do an insert of the rows that aren't in the target table. Two transactions. Should be pretty efficient, much more...

I wrote a couple of articles on audit logging a while back. You might want to take a look at them, and (more importantly) at the discussions attached to...

You need to change a setting in Management Studio. In Tools, Options, Query Results, SQL Server, Results to Text, the default setting is 256 characters per column. Increase...

You go into every proc that has temp tables in it, and you rewrite it to use table variables. Change "create table #name" to "declare @name table", and search-and-replace...

I tried this, after setting the query output to Text ("Results to Text" instead of "Results to Grid"):

ALTER FUNCTION [dbo].[F_Table_Fields_Aliased](@Table varchar(200), @Prefix varchar(20))

RETURNS VARCHAR(MAX) AS

BEGIN

DECLARE @Output VARCHAR(max)

SET @OutPut = ''

SELECT...

If you view his member profile, it has a home page URL listed. However, it doesn't appear to be active.

You might try the "send an e-mail" option from his...

One thing you can do in a situation like this is, if the variable is null, assign it an impossible value.

For example, if it's supposed to be an integer value...

What does fn_trace_getinfo tell you about the trace?

Instead of a trigger, I'd put a flag column in the table, "IsPrinted" or some such name, and default it to 0. Then set up a job that runs...

I camped out in a line that went around the block multiple times and saw the first showing on opening day.

Saw it something like 30 times in the theatre the...

UPDATE

dbo.TblCust

SET

LAST_NAME = CASE WHEN LAST_NAME LIKE '%,%'

...

That does sound like a better idea than separate filegroups in the database.

Bruce W Cassidy (4/29/2009)

[font="Verdana"]Well done, Roy! International Star Wars...