temp_int_field DOES NOT EXIST in #sub_table, it's a column in #temp.

because you are not aliasing your columns, it isn't obvious that that is the issue at first glance.

--this works, becuase...

George i have the Redgate SQL Search plugin added, and it searches meta data only: object names from sys.objects, and definition text from sql_modules.

Sean Lange And I have a couple...

winston, i think one of the built in extended events session templates, along with where you would add a filter on database Id, is probably what i'd look at first.

In...

i think there is a built in function for that, [&UserID], right?

Getting Windows USERID in SSRS report

dba schema, or was that a misspelled dbo?

here's my code modified to use your table...if you spelled your tables and columns right, i think this will work as advertised, assuming...

basically, you use a FOR XML to build the list, and then replace the LAST comma with an "AND":

here's a working example, with the steps drawn out to help...

the EXCEPT operator can do that, but the number /types of columns must be the same in both queries.

otherwise, show us your real queries instead of pseudocode, and we can...

mstanl (11/15/2013)

---

I have a team of Dev. that created a database with tables that each table has only one PK called ID as integer, in the child tables they join...

if you switch your database context to tempdb, sp_spaceused works for me:

select top 100 * into #temp from edlogdetail

use tempdb

exec sp_spaceused #temp

/*

namerowsreserveddataindex_sizeunused

#temp_<snip>_000000000187100 56...

GilaMonster (11/14/2013)

---

Ed Wagner (11/14/2013)

---

If your nonclustered has other columns included, it could prove useful in some queries, but since all nonclustered indexes inherit the value from the clustered index anyway,...

no easy way.

you can use the sys.columns view to generate the suite of commands, and the commands might fail if there are any check constraints, default constraints , foreign keys...

the accepting of parameters interactively would be part of an application, which just happens to call the SQL script when it's ready.

SQLPlus for oracle has that feature built in, but...

dwain.c (11/13/2013)

---

Lowell (11/13/2013)

---

take a look at this thread, where there's a couple of different ways the same problem was tackled:

Large String Value needs to be broken down into Human readible...

instead of bulk insert directly into your destination table, use a staging table.

what i've always done in this case is to bulk insert into a staging table, and then massage...

take a look at this thread, where there's a couple of different ways the same problem was tackled:

Large String Value needs to be broken down into Human readible fixed lengths.