SQL QA is more valuable than SQL MMC as MMC can't do everything...but QA can execute any scripts you can design.

I can't comment in detail on the "remove from NT"...

MattieNH....

I "believe" you need to post an image of the 'graphical' execution plan on a internet facing webserver....and link to that from here.  I think this applies to all posting of...

Are the stats on the underlying tables uptodate?  Can you post the 2 sets of execution plans?  You may benefit even more by qualifying your tables with dbo.

As a readability...

"Information schema" and the listed functions are better to use as the underlying "system catalog" tables are liable to change/be made obselete by MS, whereas the "schema" views are less...

"...WHERE Number BETWEEN 1 AND 10"

Why not?

"...WHERE Number BETWEEN 0 AND 9"

Talk about time...This might be a step in the right direction for you...just posted yesterday.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=71335

Will you really have a month indicator > 12...last time I looked at the  calendar...December finished the year...you have 17 + 25.  What would...

Other than a counter table....the only thing I can think of is...

DECLARE @NEXT_VALUE as integer

select @NEXT_VALUE = MAX(a.TM_ID) + 1 FROM (select top 1 TM_ID FROM TEAMS order by TM_ID desc) a...

Every site has an admin...in this case it's SteveJones...search here for the articles published by him.   You should also be able to locate him under some 'about/contact us' page.  There's...

Interesting approach to life....

a)  advertising a competing product on a SQL-Server community site....full marks for ambition.

b) advertising a competing product on a SQL-Server community site wihtout paying the minimal fee...

Personally I find it hard to understand the need for 1000 columns in a table.  I generally run out of absolute distinct pieces of information on an object when I...

This has been posted on other sites....and marked as SPAM.

If it's not.....The guy could at least pay for some advertising to support the site promoters.

Post the DDL of the tables referenced in this exercise....plus some input data (in the form of INSERT statements)....plus expected results.  Don't over-simplify the data...otherwise somebody might suggest a solution...

1...data INPUT is what's needed....(but you're on the right track in style for future problems)

2. my code @ 3 above will give your output....BUT more complex input data MAY invalidate...

a couple of issues.

1.  where's the indices on the source table...polygon?

2.  your 'expected results don't line up with your input data....where's the output for 1697573 and 1697574?

2a)  in general it...