Can ALTER TABLE affect the IDENTITY property? I'm looking at help online for ALTER TABLE and can't see it. If you search "identity columns/modifying properties", it just...

I can't run this to look at your query plan, or even the results of all your subqueries,

but here's something to try in your update. It looks...

Kiran:

"Full-text search delivers enterprise search functionality" is just marketing hype ("hype" NOT "hyper") that means all users can use it (if you have first built full text indexes and queries...

At least this one didn't have URGENT URGENT URGENT in the topic header. 😛

Applause... thunderous applause.

I may have to apologize at this point. For the last 20-30 minutes, I've been browsing through your extremely procedural code. I can only say that...

Thanks, Kenneth. Maybe it's holiday silliness, but I kind of like the idea of a post topic being simply "Can we?"

Yes, we can.

Bob (the Builder)

P.S. ...

.... and if I could pick numbers, I would be retired and skiing in Park City or Alta right now, so you would have never seen me on this forum....

Matt: It's a gift. I am but a tool of a Higher Power 😉

If you see my post above, we just had a touch of asynchronous communications....

Dave, sorry I was editing my post when you looked a minute ago. The cut and paste of the code looked really squirrelly because of tabs settings. ...

Sure. The technique below works fast for concatenating values in any column. The cte isn't required, it just makes the final query a little easier to...

SQL 2005 supports TRY and CATCH logic.

BEGIN TRY

SELECT TOP 500 Results.VPath AS URL

FROM OPENROWSET('MSIDXS', 'PSAJournals';''; '',

'SELECT Rank, VPath FROM...

Are you trying to select the detail for whichever row has the max date? If so, you first need a CTE or subquery that does a summary query...

Since you are doing this in dynamic SQL, you should also be capable of writing the dynamic SQL to create a variable for each column your are selecting from, and...

You're welcome, Rich.

Dynamic SQL is the only option I know of to handle variable table names, including identical table names in separate DBs. Good luck.