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...

per Brians request, here's a parameterized stored proc using the logic i posted above;

there's some cleanup that should be introduced where im arbitrarily doing a REPLACE of vbLf with...

i would call SSMS a developer tool, and don't think it's really a tool for end users to be working with; it doesn't have any place like Access does to...

brian wow it's been a while since i saw this thread.

Today, I actually do the same with regular expressions and a CLR; if that's an option, let me know and...

Krishna1 (4/8/2013)

---

if my table is customer having column col1,col2 ...

in the select query i want all the developners to access it in the query as

select customercode, customername

from mycstomer

instead of

select col1,...

and a bevy of images here:

SSMS 2008 Images/Screenshots