ggjjbb1983

From Books On Line - with some DBCC commands you can:

CREATE TABLE #tracestatus (

TraceFlag int,

Status int,

Global int,

Session...

May I direct your attention to the Merge T-SQL statement, which appears to be the method you would choose to do what you want to do.

http://technet.microsoft.com/en-us/library/bb510625.aspx

PIVOT requires aggregation - read Jeff Moden article

Will I write it for you - I respectfully decline for doing someone else work I am normally paid my consulting fee.

Now,...

harag

Read these 2 articles byJeff Moden:

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/Crosstab/65048/

another article

http://www.sqlservercentral.com/scripts/T-SQL/70819/

Here is another way of doing what I think you want to do

CREATE TABLE #T(UserName VARCHAR(10), ColumnA INT, ColumnB INT, DT DATETIME)

INSERT INTO #T

SELECT 'Tom',1000, 10,'2010-09-20' UNION ALL

SELECT 'Tom', 1050,...

Nice series of questions -- it will teach a great number of people a lot of what they should/need to know

sugsam

To get a tested answer please post table definition, sample data, and what you have already done, following the methods listed in the article whose link is the first...

bbsr

Might I make a suggestion.

1. Purchase the developer edition of SQL SERVER 2005 - Cost less than $50 USD.

2. Restore a back up of your 2000 DBs to...

With either or both of these procedure you could calculate the average size of each row (per table), estimate the number of rows that may be added to each table...

Look you are in the window posting to...

jfrancisco

Finally I am trying to create this trigger but I am getting an error... I am working in SQL Server 2005 but really the trigger is going to be...

Jeff remember this article?

The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

By Jeff Moden, 2008/05/07

Total article views: 41560 Views in the last 30 days:...

Please click on the first link in my signaure block and learn how to present data in a forum so that others may supply a tested answer.

machine name SELECT host_name()

use GETDATE()

Again learn how to use Books On Line the SQL Server help file

It is readily available when...

As a DBA you should have access to BOL (Books on Line) the help guide for SQL sever. Under Triggers you will find:

Logon triggers fire stored procedures in...