Dont let the fact that your current job is boring overrule any other criteria you would otherwise use when evaluating a new opprtunity:

Is the new job closer to your home?

Any...

The error message usually include a line number to point you in the right direction.

It can be any of the three updates using a subquery.

The TOP 1 ORDER BY will...

What are you trying to do?

It seems like you're looking for a join. Maybe something like this?

--UPDATE dbo.MasterStage

--SET Client =

...

aaron.reese (7/6/2011)

---

unfortunately, the people who wrote the NHS datasets are morons....

The data gets extracted like this from the source systems in flat file format and loaded to the DW like...

kritikamehtani (7/6/2011)

---

logic :---

SELECT @message = queue_message FROM tablename

WHERE PK= @pk

IF (@PK is not null and...

duplicate post. no replies please.

Discussion already started here

jasonwi1202 (7/5/2011)

---

If you do find yourself stuck in a situation where you need to cycle through every record in a table, here is a good example of how to code...

Please have a look at the CrossTab article referenced in my signature for a different way to do it.

If you need additional help, please post table def and sample data...

I second Johns alternatives and would prefer option 2.

To be a little more specific regarding the splitter function: search for DelimitedSplit8K.

The basic concept: shred the comma delimited list into a...

pwalter83 (7/4/2011)

---

...

Thanks, Lutz, I tried but could not work out how to use a calendar date and then storing the same. Do you know if there's another way to do...

Just check the definitions (straight from BOL):

and for DATEPART(week):

...When datepart is week (wk, ww) or weekday...

Here's a slightly different approach:

select

col1,

col2,

stuff(

(select ',' + col3

from @data d2

where d2.col1=d1.col1 and d2.col2=d1.col2 and d2.col4=d1.col4

order by col3

for xml path('')

),1,1,'') col3,

col4

from...

May I kindly ask to stop the discussion at that point?

I don't see any new (question related) information added since several posts.

Let's just agree to disagree and move on.

Are you aware the year 2009 did not have a February 29th?

It seems like you're trying to compare a varchar and a datetime data type.

Since the datetime data type has a higher precedence than varchar, the varchar value needs to be...