Have you tried doing it with a dataset based on SELECT @@SERVERNAME?

I don't have named instances, so no testing done on my end, but I can't see why it wouldn't...

Now I'm curious what the performance difference would be between Amit's and John's solutions on a large table. It appears at first glance that Amit's needs two indexes on one...

As JLK mentioned, I'm not getting what you are trying to accomplish. The only thing that pops into my head is that maybe you are misunderstanding how SELECT DISTINCT works,...

You'll want to set DATEFIRST to Monday for this, and then you can use datepart(wk, <date> ) to get the week of the year. Grouping on that (and on year,...

As is the usual answer in the SQL Server world, it depends. You can use one of several log recovery tools (I know of ones from Red-Gate, Lumigent, and Apex),...

Can you post 10-20 rows of data that my InvalidDate query returns? There shouldn't be any proprietary info issues, as it should just return dates, but if for some reason...

Well, the Report is going to need the parameters if it has a stored proc that it passes them to.

Without knowing how you want to call the report, it's tough...

Mark, John's code should do that for you, and you don't need to know rank ahead of time. He's creating a table to work with, which takes all of your...

This throws the same error? I don't see how that could be the case.

SELECT

 InvalidDate = SubString(DirInfo, 1, 10)

FROM

 Reports

WHERE

 IsDate(SubString(DirInfo, 1, 10)) = 0

My query should have done the same thing, as the IsDate should have been applied before the date comparison is performed. I do know that implicit conversions are nondeterministic in 2005, which is...

What does the following show in each environment?

SELECT

 InvalidDate = SubString(DirInfo, 1, 10)

FROM

 Reports

WHERE

 IsDate(SubString(DirInfo, 1, 10)) = 0

In case I didn't describe that well enough to understand, I meant something like this:

SELECT

 Filename

FROM

  (

 SELECT LTRIM(RTRIM(SUBSTRING(DIRINFO,39,LEN(DIRINFO)-38))) FileName, DirInfo FROM Reports

 WHERE ISDATE(SUBSTRING(DirInfo, 1, 10)) <> 0 AND SUBSTRING(DIRINFO,25,5)<>'<DIR>'

 ...

You didn't tell us if the data in 2000 and 2005 are the same, so for now I'll assume they aren't. If they are, then it's likely a difference in...

Which method you should use depends on your needs, table sizes, reusability, etc. In our environment, SELECT INTOs don't present any problems, and are extremely fast, which considering the sizes...

Yes, it only works when they are incremental and with no gaps. If we need to avoid looping for this type of thing, and if the existing identity column has...