Hi Brian,

Sounds like you might consider normalizing the database a bit more.  But you might try something like this:

Here you are assuming that the only values in the column that...

Actually, I think With CUBE has been deprecated.  It's a SQL Server 6.5 feature that allowed for viewing data three dimensionally.  Now the prefered method is to use Analysis Services,...

As to the magic list -- If you open SQL Query Analyzer, (From Enterprise Manager Select a Database, Click the Tools Menu...Choose SQL Query Analyzer) And choose Transact SQL Help...

Hi,

Try this, I think it may be what you're looking for:

SELECT

          database_name,

          backup_finish_date,

          TYPE

    FROM DBBackup

GROUP BY     database_name,backup_finish_date,TYPE

WITH CUBE

I noticed that too.  According to MS documentation you can use a table variable just like a table exept, however, they may not be used in the following statements:

INSERT...

My Bad.  You are absolutely right! 

I see.  fn_get_sql() is a new admin function included with SQL2K sp3.  It returns the objectid of currently executing sql.  It takes sql_handle, a binary from sysprocesses as its only...

Try using the T-SQL RAISERROR statement.  Using RAISERROR you can return to the client a string in the raiserror statement or a system defined message from dbo.master.sysmessages.  You can add...

Try using CONVERT instead of CAST.  Like SELECT CONVERT ( datetime, '20040503',101)

101 is the format code for the date format you are searching for. 

There are several ways.  You can Run sp_who, or sp_who2 from Query Analyzer.  The results however may be a bit cryptic.  In Enterprise Manager, you can also expand the Management...Current Activity...

Just a note:  The SQL Server Function  RTRIM can be used for this exact purpose.  The syntax is RTRIM(@concatstring).

I've run into this same problem in the past.  You might consider truncating the log on Checkpoint.  Try:

sp_dboption 'database_name', 'trunc. log on chkpt.', 'true'

You might try another way to do what you're doing besides cursors, but the following works:

declare @sourcetable table (nr int, tekst varchar(10))

declare @desttable table (nr int, tekst varchar(10))

declare @val1 int

declare...

I think the optimizer in SQL Server resolves a lot of these types of issues too.

Enterprise Manager can create this script for you.  

1.  In Enterprise Manager, Right Click a Table that you wish to Alter and choose Design Table (The Design Table tablename window opens)...
2. Click on the...