Viewing 15 posts - 1,711 through 1,725 (of 3,221 total)
ggjjbb1983
From Books On Line - with some DBCC commands you can:
CREATE TABLE #tracestatus (
TraceFlag int,
Status int,
Global int,
Session...
October 1, 2010 at 8:26 pm
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.
October 1, 2010 at 2:41 pm
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,...
September 25, 2010 at 5:50 pm
harag
Read these 2 articles byJeff Moden:
http://www.sqlservercentral.com/articles/T-SQL/63681/
http://www.sqlservercentral.com/articles/Crosstab/65048/
another article
September 25, 2010 at 4:07 pm
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,...
September 23, 2010 at 8:39 pm
Nice series of questions -- it will teach a great number of people a lot of what they should/need to know
September 22, 2010 at 9:01 pm
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...
September 22, 2010 at 7:43 pm
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...
September 22, 2010 at 7:24 pm
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...
September 22, 2010 at 5:49 pm
Max-498379
I will post the code if anyone wants, I just don't have time now to read the "how to post a query" guide.
Look you are in the window posting to...
September 22, 2010 at 2:39 pm
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...
September 22, 2010 at 1:59 pm
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:...
September 22, 2010 at 8:00 am
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.
September 21, 2010 at 7:31 pm
machine name SELECT host_name()
2.- The current time for that moment
use GETDATE()
Again learn how to use Books On Line the SQL Server help file
It is readily available when...
September 21, 2010 at 6:17 pm
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...
September 21, 2010 at 3:16 pm
Viewing 15 posts - 1,711 through 1,725 (of 3,221 total)