I have changed the joins now to inner joins as i realize the where clause negates on of the left joins and the other can also be inner join, not...

HI,

thanks for your reply but i took that extra parameter @joboid>0 out of the SP as its was a usless parameter not sure what the reason behind the person who...

HI Gail,

here you go thank you for you help, am tearing my hair out to try understand this 🙂

your welcome, i use windows scheduled task, you have to pass 3 parameter

1 drive or URL to Drive

2 hostname (not used in processing, only used to write to log...

@jeff here you go, save it then rename it to .vbs 🙂

this gives you the charindex of comma 1 and comma 2

select charindex (',',col) as comma1,charindex(',',SUBSTRING(col,charindex(',',col)+1,99))+charindex (',',col) as comma2

from #t1

99 reflects the potential length of a string between the 1st comma and the second comma

Substring syntax

Substring (expression,startpoint,lenght)

99 represents thee Length of the expression

build the query up have a...

that URL does not resolve for me, like i say i use a VBS script that works perfect for me i can even pass a URL and it works prety...

this would show what ever was between the 1st comma and the second

declare @string varchar(20)

set @string='A,B,C'

Select substring( SUBSTRING(@string,charindex(',',@string)+1,99),0,charindex(',',SUBSTRING(@string,charindex(',',@string)+1,99)))

EDIT

also take a look at this post

http://www.sqlservercentral.com/Forums/Topic1368056-391-1.aspx#bm1368081

you could create something from master..xp_fixeddrives however, i created a VBS script that you pass a couple of parameter, disk to check and threshold, if the disk space is less...

are you sure there isnt anymore to your requirements? looks a bit too simple to me

select ano from #x1

where ano!=4

order by ano

thanks i think you should tell my boss that

Look up coalesce

select coalesce(col1,col2,col3) from t1

Do you have a list of file names? you could use master.dbo.xp_fileexist to determine if they exist or not

in answer to your other question

set @param='%'+XXXX+'%'