Right-click the database --> reports --> standard reports --> disk usage by table

Good thought - but grouping by Commissiontype will now go back to putting the gross and the net on separate lines. How about...

SELECT TransactionID,

...

These reports...

Another solution, very similar to Matt's except this one filter to only get the records that have a gross or net = G or N.

SELECT TransactionID,

...

Something like this should help.

CREATE TABLE #temp (

table_name sysname ,

row_count int,

...

Yeah. I just found out about it a few weeks ago :). It has the equivalent options to Tasks --> generate scripts.

This entire statement is wrong.

I believe you want something...

You need to use the count aggregation with a case statement.

declare @t table(

SID int identity(1,1),

SDate DATETIME,

FID int,

PID int,

PNO int,

TypeCode int

)

insert into @t (SDate,FID,PID,PNO,TypeCode)

select '01/03/08', 1,...

Triggers are supposed to be transparent. If your goal is to determine what DML action occured and base your code logic on what happened, I would suggest that you...

What percentage of the total number of records is 12 months? This will allow me to better determine how to delete the data.

You have plenty of options here. You...

Cool. I was just curious. You...

Got the above from this author. Have to give credit where it is due 🙂

http://www.sqlservercentral.com/scripts/Administration/61766/

You can query sysobjects.

SELECT o.name AS [Table Name], i.rowcnt AS [Row Count]

FROM sysobjects o, sysindexes i

WHERE i.id = o.id

AND indid IN(0,1)

AND xtype = 'u'

AND o.name <> 'sysdiagrams'

AND o.name =...

Happycat59,

Just curious why you chose to do a subquery with a union all when you have the same group by in both queries. You could have done something like...

Well for a lack of better terms you messed your new instance up. You have to put the SQL 2005 install disk in and rebuild the system databases.

This link...