This is actually simple, and I'm pretty sure you could find an example in Books Online. Why don't you check it out.

Sergiy's question

Actually, quite reasonable, and I'd like to see your...

There be trolls about!

What?? I didn't do nothin'. -- (inside joke, anyone interested in personal happens, PM me I'll fill you in)

First, my first example was using a CTE called UneBookings to reduce what was Table B (original post, not modified) to one record per booking.

This wasn't needed when what was...

Rod at work (11/21/2008)

---

I'm trying a SQL Job step in which I want to call a stored procedure and pass in some parameters. One of them will be the...

Just a suggestion, as I believe I read somewhere that 3 part naming of columns (schema.tablename.columnname) is being depreciated, you may want to look at dropping the dbo. from your...

Just my opinion, but any function offered here, really should be able to return the same value regardless of setting on indiviual servers. For example, the first solution offered...

How is the stored procedure inserting the data? Is it row by row or from another table?

Also, from Books Online regarding sys.sysobjects:

Important:

If you use any of the following SQL Server 2005 DDL statements, you must use the sys.objects catalog view instead of sys.sysobjects.

CREATE |...

Maybe not, but sysobjects is for backward compatibility with earlier versions of SQL Server and could easily go away in future versions of SQL Server. I think I read...

Your problem is here:

SET @dRetVal =...

Without testing, this should work.

UPDATE TableA SET

MeetingID = B.MeetingID

FROM

TableA AS A

INNER JOIN UniqueBookings AS B

...

Could you report with corrected example? I'm having a Missouri moment and you need to Show Me.

I think it should be easier if it is reversed.

psangeetha (11/21/2008)

---

Hi all,

Below is the query I'm using to find the status of the objects,

I know the refdate in this table is the date the...