The way your query is written is possible and works. However, it's not the most versatile. I would suggest to you, you join tables using INNER/OUTER/FULL JOIN. I rewrote your...

Did you get the position?

Alberto.Omini (3/13/2009)

---

Hi people.......

HELP ME PLEASE !!!!!!!

I have a table with 5 fields with this value

FIELD A ...

Now a much more useful question form, both in interviews and for SSC (IMHO), is "When I run this in SSMS, I get this. WHY?" You just have...

Added to my last post:

I don't know the english postal code very well, and also not your data of course. So I only suggest all your postal codes have...

sam.marsden (3/11/2009)

---

oh ok i see the logic there - the only issue i can see is that i dont have a definative list of all of the post codes -...

This is what I would do: create a (temporary) table with postal codes and correct county and area names, and update from there. It will come out like this:

CREATE TABLE...

I feel like being in Back to the Future... "The time-traveling is just too dangerous. Better that I devote myself to study the other great mystery of the universe: women!"...

How's the growth of the tempdb and log file? I know we've had several problems with that on jobs.

Bob Hovious (3/5/2009)

---

JEFF !!!! You don't have a tally table available?

select dateadd(yy,datediff(yy,0,getdate())-5,0)+ N-1

from dbo.tally

where N < datediff(dd,dateadd(yy,datediff(yy,0,getdate())-5,0),getdate())+2

Runs almost a full millisecond faster at 5-10 years. 😉

Pretty...

If you use both SQL 2000 and 2005 databases, why not use SSMS for all databases? I'm using it too for SQL 2000 (right now working on an upgrade...

All of the changes are already default or pure textual, except for the fillfactor. And that is only used on creation of the constraint, the fillfactor won't be evaluated dynamically....

I guess you should put the MyCol2 in a variable and use that in the CONTAINS.

If you want better tested results, you should give some table descriptions, sample data...

I understand that, since you asked that in your first post. For some reason I like to know why you want this, because you might think there are limitations where...

If there isn't a relation between TableC and TableA, why would you want to store Aid in TableC?