I'm not sure pivot/unpivot will solve this problem, but I've been wrong MANY times before.

How many unique member IDs will be in the actual table on production? ...

And in other parts of the country, we have a high of 60 expected in northern Mississippi and I'm wearing short sleeves. Back to you Matt..... ...

It's just getting over-crowded. Nothing a horseman or four can't cure, but be careful what you wish for.

We call them "beer barns" down here.

Convenience stores in Louisiana have drive through windows where you can buy daiquiris, which they keep ready-made in big icee/slurpee machines. 😎

Well... you could always contact the admin like the message says.....

Or, you could create a temporary table or table variable and store the output from the stored procedure there. ...

I can't remember if this works prior to 2005, but give this a try.

select distinct s1.name as MainView, s2.Name as ViewUsed

from sysdepends d

join sysobjects s1 on s1.id = d.id

join...

Like Bud in "Meet the Robinsons" ??

Shouldn't your avatar look like this? 😀

Good explanation and most informative. At first I didn't see that the lines of a polygon on a globe could be seen as either defining the smaller area...

Got an answer from another site. The problem is ring orientation. Reversing coordinates in positions 2 and 4 will make @g3 a valid polygon string. ...

Duplicate post.

http://www.sqlservercentral.com/Forums/Topic629569-8-1.aspx

Essentially you are keeping a running total of the itemvalues and comparing it to the tranvalue. (Reading from last to first, as you said.)

Would it ever...

The best thing I can say for storing XML in the database is that it let us store the original XML received when a policy decision was made to not...

Nothing to excuse 🙂

I was just trying to direct you to another forum where you might get a faster answer. But Mr. Young nailed it. ...