BTW is always Three dots for MSACCESS. If the DB uses workgroup protection you may need further help(let me know) but if it is not you should be OK with...

exec msdb..sp_help_job @Job_name ='JOB NAME'

The syscolumns Idea is nice! Just keep in mind that there is no documented way to control the colorder value and if someone modifies the table design through a drop/recreate (EM) you...

Oops its 16

select convert(varchar(16),rcv_dt,20) AS MINUTE,count (*) AS ERPM

from audit_LOG1

group by  convert(varchar(16),rcv_dt,20)

ORDER BY 1

for very large tables I can confirm that for the one-column case ISNULL is a bit faster but I would still prefer coalesce instead of that little bit of speed. 

Are you trying to do this dynamically ?

If you can pivot on the client this is less typing

select  month(DataDate) as [Month]

 ,sum( case when category = 'CallCount' then CallCount else 0...

If those changes are performed from a data modeling tool you should have no problem!

ex:

If you use VISIO  for example to model the db schema you can at later time...

I have tried that in Yukon, Apparently you just  saved me time

SET NOCOUNT ON

DECLARE @Analysis TABLE

(

RowID                    INT IDENTITY,

CallCount              INT,

OpenCalls            INT,

CompletedCalls  INT,

CancelledCalls    INT,

DataDate               DATETIME

)

INSERT INTO @Analysis (CallCount, OpenCalls, CompletedCalls, CancelledCalls, DataDate)

                VALUES (125, 0, 100, 25, '06/30/2004')

INSERT INTO @Analysis (CallCount, OpenCalls, CompletedCalls,...

select convert(varchar(14),rcv_dt,20) AS MINUTE,count (*) AS ERPM

from audit_LOG1

group by  convert(varchar(14),rcv_dt,20)

ORDER BY 1

In datawarehousing is the ONLY way to simulate slowly changing dimentions because of the REAL independence that a primary key needs from the Data. What a Natural Primary key may...

exec xp_fileexist @Filename, @yes output

See my post here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=194423

by the way when you have index ID = 0 you are actually refering to a HEAP. Can you make sure those tables have a clustered...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=184349#bm184550

I think he uses Copy & Paste A LOT