Oops, meant this:

select substring(@string, 1, patindex(@string, '% %') - 1), substring(@string, patindex(@string, '% %') + 1, len(@string) - patindex(@string, '% %'))

Try this:

select substring(@string, 1, patindex(@string, '% %') - 1), substring(@string, patindex(@string, '% %') - 1, len(@string) - patindex(@string, '% %'))

I would say because you were trying to make it more complicated than it really was.  You probably could have gotten your way to work, but you should should have...

I just reread the licensing for SQL Server 2005.  You would need to purchase a per processor license for each processor in the server.  If you are looking at a...

Try the following:

declare @d1 datetime,

        @d2 datetime

set @d1 = cast('2007-01-12 15:01:50.863' as datetime)

set @d2 = cast('18:00:00.000 as datetime)

select datediff(ss, @d2, cast(convert(varchar(12), @d1, 114) as datetime)/3600.0

hth

I can't directly answer your question, but I do have a question for you, how many users access the system?  You indicate it is low use, so why are you...

IIS needs to be installed on the same system that you install Reporting Services.

Two questions come to mind.  First, when you say there is a 30 second delay, are you saying it takes 30 seconds for query window to return from executing xp_cmdshell? ...

It may not be blocked, but if there are a lot of locks issued, the Current Activity screen can hang and eventually timeout.

Load the new file into a temp table, then use a query to select the data that needs to be loaded based on the primary key of the data.

The only time I would not use aliases for column names is in queries selecting from a single table.  Once you start joining tables, it makes sense to alias the...

Best suggestion I can give, and that I have seen from others on this site, is test, test, and test some more.  You will find that some times the EXISTS...

You can use it, it just won't return a sorted result set if the order by is included in the view declaration.  A view is a table and SQL (not...

The TS stands for Technology Specialist and PRO for Professional.

hth.

I have used EXISTS in queries, but I have found that in many cases an inner join actually worked better than the EXISTS.  It really depends on the queries you...