when you say any regular job fails, are you talking just about SQL Agent jobs? If they are calling stored procs and the stored procs fail, then they will...

This can also be done in a CTE

Setup

declare @t table (CRN int, admdate smalldatetime)

insert into @t

select 1234,'05/19/2010' union all

select 1234 ,'08/15/2010' union all

select 1234 ,'08/20/2010' union all

select 3456 ,'07/01/2010' union...

how many rows are there? I use SSMSToolsPack add on to SSMS. I found that it is slow once the rowcounts start exceeding 1000 rows. It's a...

This procedure only requires param1 have a value. If you call the proc and pass @param1 = 5, then the other 2 will use the default of null. ...

I found that the data types have to be the same when you are ordering by in a Case Statement. Can you provide the DDL and sample data so...

This doesn't return the schema of a preocedure. It returns the parameters

how about a CTE?

DECLARE @t TABLE(dnsname VARCHAR(30),alias VARCHAR(30),zone VARCHAR(30));

INSERT INTO @t(dnsname,alias,zone)

SELECT 'w2ksrv','10.130.2.26','zone001' UNION ALL

SELECT 'std-w2ksrv','w2ksrv','zone001' UNION ALL

SELECT 'app_w2ksrv','std-w2ksrv.com','zone000' UNION ALL

SELECT 'w2ksrvtst','10.131.129.2','zone001' UNION ALL

SELECT 'csm_w2ksrvtst','w2ksrvtst.com','zone000'...

DECLARE @t table (ID smallint, UserID smallint, TaskID smallint)

insert into @t

select 100 , 1 , 1 union all

select 101 , 1 , 2 union all

select 102 ,...

double posted. here is the main thread

http://www.sqlservercentral.com/Forums/Topic978776-392-1.aspx

I'm not sure how to parse the XML you provided, so I modified it so I could parse it. You can modify the XML to match your layout

Setup

Create table...

Can you supply DDL, sample data and expected results? Not really sure what you want or how you want it to appear. See the link in my signature...

how about some DDL, sample data, expected output and what you have tried? Not much to go on with what you've provided

Thanks for the link. I didn't know Jeff revised it.

I think I'll join you

We use TFS and find it very useful. Not so much for development, but for source control and creating unit tests (the best feature I think). We create...

Not sure what you question is or if you are just providing a script. The script doesn't work. You need to change 'CRATE' to 'CREATE'. Also, dbo.fnc_get_datatype...