maybe this?

http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/04f9eab4-907d-400c-b15c-710fd2f972e0

SQL server tools / client components , integration services and browser are MACHINE aware - ie) 1 per machine.

SQL database engine , analysis services and reporting services are instance...

more details are needed to really help, i guess;

maybe there's a custom entry in the hosts file:

from a commandline, notepad.exe %SystemRoot%\system32\drivers\etc\hosts

in that extension-less hosts file, maybe someone has put the...

sudhirnune (4/9/2013)

---

Tanks Lowwel, it is perfectly working.

But my problem is that I may not be able to use the Global Temp table.

Can we Have the local temp / Genral table...

i edited the post, so re-copy it and try again.

the line for the global temp table should have been here:

set @query = 'SELECT name, ' + @cols2 + ' ...

i guess something like this, where you insert into ##GlobalTable would give you the results as a table so you can update from it later.

DECLARE @cols AS NVARCHAR(MAX),

@query AS NVARCHAR(MAX),

@cols2...

you didn't provide any real details or example code;

without seeing the query featuring PIVOT, all i can offer is to use the SELECT...INTO TABLENAME FROM MyTable format.

and another way, via a scalar function:

/*--Results

cellindex containerid containerlength istwincarry ...

for me, it depends on the size of the table;

for huge tables, it takes a lot less than 20% of the rows to make the statistics stale enough that they...

doug.davidson (4/8/2013)

---

I have never explored a CTE before. Good new research and learning for me.

I will use the sub select as the new work around until I finish my learning...

without re-writing the scalar function to be an inline table valued function, i though getting intermediate results for the scalar function in a CTE or sub select would be easier:

i'm...

172.17.15.100 looks like a public IP address, and not something on a private LAN;

typically, external servers are locked down to ignore everything except port 80(http).

if these servers are not on...

fantastic job providing the DDL and sample data!

I think in this case, you need to match partial strings, right?

you will want to join the tables together, but use a LIKE...

mister.magoo (4/8/2013)

---

Lowell, that...

I've done this a few times;

here's a link to a slightly modified version of Microsofts Microsoft.ApplicationBlocks.Data SQLHelper.cs class, which i ran thru a converter, and then enhanced.

SqlHelper.vb.txt

the usage is something...

OPENROWSET...