You wont...

Is it too late to recommened that you change the structure of your table to be a normalized relational-database?

Because what you have there is an EAV table and this...

Agree with all the points above, the case senstivity quite often trips people up

t-sql join is a lot nicer and has the possibliity of being optimized

at 800mb it should not cause a problem.

the problem is if you have to recover to a point in time, without t-log backups you can't. For example if...

yes you should steer clear from merge join as it does not perform very well.

you can do a join in t-sql if the servers are linked or on the same...

Are you also doing t-log backups?

Jan Van der Eecken (9/27/2010)

---

steveb. (9/27/2010)

---

I thought the issue is that the column does not exist in the table in the sub-query. Not that the sub-query returns mulitple...

Chris Morris-439714 (9/27/2010)

---

steveb. (9/27/2010)

---

I thought the issue is that the column does not exist in the table in the sub-query. Not that the sub-query returns mulitple rows.

It definetly...

I thought the issue is that the column does not exist in the table in the sub-query. Not that the sub-query returns mulitple rows.

It definetly throws an error in...

it is a good idea to be aware of the other systems, but i dont think it would be possible to become an 'expert' in every product. In my...

or use books online there are loads of tutorials on there

Can't see anything wrong with that code, what is the problem you are having?

As mentioned the model will depened on the nature of your business, but for a guide on how to build your own one get a copy of Kimball's datawarehouse...

They need to make intelleSence more intellegent, at the moment i find it slows things down where it could be really useful

Phil Parkin (9/21/2010)

---

steveb. (9/21/2010)

---

With 2005 SSIS i am not sure, you can with 2008, you would just include them like you normally would. Use a Script...