Good job on tracking it down. Any luck on fixing it?

Congrats and welcome to gurudom.

What does "InStr" do?

Why not have the front-end do that kind of thing? SQL isn't all that good at string manipulation.

(Steve: Feels kind of weird to be responding to this editorial... 🙂 )

The point of a VM test like this isn't to be a one-shot-interview-with-100%-success. The point is to...

Grant Fritchey (5/12/2009)

---

GilaMonster (5/12/2009)

---

Grant Fritchey (5/12/2009)

---

Paul White (5/12/2009)

---

Vinoo (5/12/2009)

---

Please understand that this forum has people who are extreme experts on SQL Server who are champions in their field. It pays...

Take the Top and Order By out of the sub-query. They're not doing anything useful in there, and SQL will ignore them anyway.

Here's something that might help:

use DBA;

go

create proc dbo.RestorePointInTime

(@DBName sysname,

@PointInTime datetime,

@TargetDBName sysname = null,

@MDFLocation nvarchar(128) = null,

@LDFLocation nvarchar(128) = null)

as

/*

Does not work with databases with more than one...

This is what I came up with. It will only work reliably on names in the formats you listed.

-- Set up test data

create table #T (

ID int identity primary...

It looks like what this does is take each Skill Group and Skill Group Target, grouped by Peripheral and Date, and update the available time by subtracting the Total Time.

Am...

Glad I could help. Sorry about it taking a while to get. That possibility didn't occur to me, or I'd have explained it a bit.

As already mentioned, don't...

I had to...

Kit G (5/11/2009)

---

David Burrows (5/11/2009)

---

Oh and don't forget Scotty 😀

And did anyone notice that anyone beaming down to a planet wearing red (except Scotty of course) was always killed off...

john.arnott (5/11/2009)

---

Here's one I've about given up on. I haven't convinced the author of a recent SSC article that it's a poor practice to do a datetime...

If you look on Amazon.com, there are...