Try this...

CREATE TABLE #tempa

(

idcol INT IDENTITY(1,1),

NAME VARCHAR(100))

INSERT INTO #tempa (NAME)

SELECT 'ServerName1\Dev'

INSERT INTO #tempa (NAME)

SELECT 'SN1\Development'

INSERT INTO #tempa (NAME)

SELECT 'ABCD\1234'

SELECT SUBSTRING(NAME,1,CHARINDEX('\',NAME,1)-1) FROM #tempa

No problems. I have done several things like this recently so it was code i have used a lot. You will probably find it the same.

If you haven't already...

Good effort Lynn...thats much better :D.

Better to avoid the while loop wherever possible.

Ta

Matt

Not sure exactly what your after.

something like this might do the job for you though.

DECLARE @ID INT

DECLARE @Date1 DATETIME

DECLARE @Date2 DATETIME

DECLARE @MaxID INT

SET @ID = 1

SET @MaxID =...

sorry...value between the commas i meant...

Hi,

Assuming i have understood what you are trying to do correcty. I would suggest passing the Sproc a comma delimetered list of integers which you can seperate out and...

Thanks very much for taking the time to reply.

I have checked the properties in the server properties and the "maximum number of concurrent connections" is already set to 0.

Any...

Hi,

We are going to need more information than that really. Can you post the SQL that you are using please

Thanks

Hi,

I have written a procedure that will probably do the job. I have been unable to test it properly as i haven't got any jobs running during the day...

sorry..wrote another question, but then answered it myself! ignore this!

ok, firstly...thank you very much for the response and code. I read through the article on tally tables. Very interesting. Thank you. I can see why they are much better...

I can understand bits of the logic of what is going on, the actual code format etc that you are using to get the results, and how it is working!...

Thank you for taking the time to reply...The column currently holds NULL's

I literally have no idea what that peice of code that you have given me is doing...:blush:

Thank you though,...

Surely i would have to set up a trace that ran in the background all day looking for the specific details. Then dump these into a table manually at the...

I think that i have got this working. The server date is a couple of weeks off..this was throwing me off from thinking that it was returning old data!

Unfortunately i...