I haven't had a go myself, but it looks like what you need can be achieved using a table valued function, to which you pass a start and end date...

Hi there,

It sounds like you've had it work on SP3 since you upgraded. What's the server OS, 2000?

What user were you logged in on the machine as...

If your calendar table will always have rows in for a given date, just change your join to a left outer and use coalesce for when your equipment column is...

Oh wow, so simple... :w00t:

(Obviously k.i.s.s. has stopped ringing in my ears for some reason)

I was...

Nice Flo, much neater! Think I need to go read up on pattern matching... 😉

Both our examples fall foul of this set though (mine on the later slash in...

For a one off you can use a combination of PATINDEX and LEFT for a quick and dirty way of trimming out the names you need. As below, the...

Like everyone has said, you need to give at least demo table structures and what gets...

Ah, in that case, although a cursor or table variable would probably be the obvious answer, try the following and see if it hits the spot. It adds the...

piet_dj (4/24/2008)

---

Hi All,

I have created an SSIS package to import data from an Excel file, then lookup additional info from an SQL datatable (based on multiple criteria), then export to...

Jim Wall (4/22/2008)

---

I would suggest adding a new database for this tables using the simple recovery model to hold the tables. That way the tables will survive a reboot which...

I liked this question, because shamefully I didn't know that. 😀

The tables definitely contain data that doesn't need to be persistent, but the server is shared by quite a few different systems...

What's the difference, security wise, between physically creating tables,...

I'm guessing that wasn't the right side of bed that...

Your initial code was almost an UPDATE statement, not sure how you got the error you say you got from running the code you posted as it was neither a...

I think GSquared's Row_Number() solution would be the way forward as you have control. An identity column may cause you issues down the line.

However, as you already have data...