I agree with "schleep".  I tried your query with some test data of my own devising, and I got the same result without using the ProductAsset table:

SELECT p.product_id, a.asset_id

FROM Asset...

I believe NoelD is on the right track with a good way to assign sequential numbers that doesn't use a cursor.

Here's a way to assign sequential numbers to any distinct...

If you're writing a Web App, Paul's ASP.NET solution looks good; I reformatted it for readability:

Function OutputDocumentImage

  '' Clear out the existing HTTP header information Response.Expires = 0

  Response.Buffer...

This variation of Luigi's solution should work:

SELECT DISTINCT

  FD.[ID], FD.FundName + (CASE WHEN PF.FundID IS NULL THEN '(empty)' ELSE '' END)

  FROM Fund FD

  LEFT JOIN ProgramFundsList PF ON FD.ID...

You're welcome, Peter. Glad to help.

Re: Will having 2 records for the one shift with 2 seperate ID's affect my Analyisis Services CUBES? 

Answer: Probably yes.

Re: What is the best way to Create a shift...

Here's an approach that will handle the shifts more generically -- for instance, if the shift hours change you'll change the shift table, not the SQL code.

Logical Design:

1. Think of...

I think it's not supported by design.  I tried a similar update, and got the error message: "An aggregate may not appear in the set list of an UPDATE statement." ...

I agree, both of the last two posts are better generic solutions.

Would this do it?

SELECT * FROM (

-- Your whole select statement goes here

)

WHERE Error1 !=''

Hello,

Re: "input at the time of execution"

It depends on where you are getting the input.  For instance, in an ASP or .NET web page, the input comes from a form...

Hello,

All three suggestions are correct.  If you always have the minutes portion as a two-digit number, like these examples:

zTime

118:45

120:55

122:15

Then this query SQL should work in QA:

SELECT substring(zTime,1,len(zTime)-3) as hrs,

  substring(zTime,len(zTime)-1,2)...

Hello,

Did you try the Pivot Table scripts on this site?

http://www.sqlservercentral.com/scripts/contributions/204.asp

http://www.sqlservercentral.com/scripts/contributions/422.asp

http://www.sqlservercentral.com/scripts/contributions/506.asp

http://www.sqlservercentral.com/scripts/contributions/594.asp

I agree, there's not a way to save the DB Diagram directly into Word format.   I use the print-screen technique - the product I use is Print-Key Pro; it also...

David's answer was right on the money for two workshops.  Here's a query that works for any number of workshops:

  SELECT  base.location, base.product

    base.TotalQTYAvailable - ship.ship_qty AS TotalQTYAvailable,

    base.workshop

  FROM...