David's idea is the initial way I would go.

If you have a slightly different scenario, you can go a different route. This assumes that A) you are reasonably enough...

DECLARE @t int

SET @t = 0

SELECT @t = @t + 1 'Unique ID',

{rest of query here}

That will add row numbers to each row. It obviously doesn't persist the...

You could create an ADO connection.

Access would also work as a pretty decent front end. If you've been doing Access development, then it has the advantage of familiarity. You can either use Access...

That's a pretty huge topic. Entire books are written on getting information from a query to a web page, based on different scenarios.

Most methods involve some use of ASP...

Are you talking about this forum? It looks like a pretty vanilla phpBB2 forum. Google that term, and you should find the site pretty quickly. And, yes,...

Er, sushila, I think you're wrong there. I think you read the original too quickly. The SET statement you're quoting there is part of an UPDATE query. ...

Just FYI, you're unlikely to get a lot of help without a little more direction. What kind of error? Does the error give you a line number? ...

Are you sure that the first four characters are 'Sale' and 'Cost' respectively? If they aren't, then your CASE statement will always return 0.

If that's not the problem, I'm...

In what way is this not working?

If the problem is that it's storing values that exist in both columns, try this:

SELECT DISTINCT t.[Name]

INTO New_Table

FROM (SELECT Column1 AS [Name]

...

Oh, one thing I thought of. Because you can't have more than one relationship between any two tasks (e.g., both concurrent and forward), you could probably actually make tdPrimaryTask...

This is, as I'm sure you've figured out, a non-trivial problem.

First, are you going to allow tasks to be added to work orders that are NOT in your list of...

Er, I think it might be easier to do

DATEDIFF(ms,DateOfInterest,'19700101 03:00:00')

It doesn't actually give you the same results, though. The original formula gives you the number of milliseconds in the...

Just out of curiosity, WHY do you not want to store the time? I mean, storing a 0 time doesn't save you any space. It's easy enough to...

Check out "user-defined data types" in BOL. That should get you started.