Are you trying to figure out which column would have a more recent date between the date the row was created and the date the row was modified?

Isnull(modified, created)

This would...

Can you explain a little more clearly what the issue is?

And there is...

Without any ddl or data it is hard to say...but just reading it at face value calculating the average phone number is hysterically funny. 😛

The alias t1 does not exist in that query. If you want a value to persist between queries you have to store it somewhere (variable or a table).

I sort of remember that thread too. I think that Jeff was trying to say that the "best" solution did not need to use a pivot. I don't recall if...

adiehl (3/6/2012)

---

Funny thing is, a consultant did create that! I was hired to create reports based off that view. They have created a non-normalized table based off this view...

No problem. 😀 No you can't delete them, unless you send an email to the moderator asking for it to be deleted. Probably not worth it because it will fall...

HOLY!!!!!!!!!

There are over 30 subselects and somewhere around 5-6 scalar functions. Even if you got that to work you might as well go out for lunch while it runs.

That is...

siva 20997 (3/6/2012)

---

Most users on this forum seems to be DBA's who are manipulating large chunks of data and are thinking effiencey. However I think of my self as manaipulating...

Please don't cross post.

direct all replies here. http://www.sqlservercentral.com/Forums/Topic1262308-392-1.aspx

Please don't cross post.

Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1262308-392-1.aspx

This is tricky at best to do with straight sql. Typically it is much easier to do this with an application. Why do you want to take 2400 images that...

You have to first have your new schema created. Then you need to alter that schema and transfer the object(s).

http://msdn.microsoft.com/en-us/library/ms190387.aspx

http://msdn.microsoft.com/en-us/library/ms173423.aspx

I think the OP wants to find all items with either type....