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.

what you want to do here is use some customa ggregation:

a SUM(CASE statement can help you generate the counts in a single statement

something like this:

SELECT

COUNT(productid) AS Totalproduct,

SUM(CASE WHEN productname...

yeah the whole "exotic' naming convention for non traditional joins started back in 2007 with...

Jeff Moden (11/12/2013)

---

Very cool. I've not actually used the ACE drivers, yet...

here's my linked server example for a 64 bit folder full of text files that may help:

a couple of prerequisites:

install the AccessDatabaseEngine_x64.exe from microsoft:

http://www.microsoft.com/en-us/download/details.aspx?id=13255

make sure you open an...

the trick here is what some people call an "exotic" join, where it's not joining on discrete values, but rather on the criteria (between dates) you are looking for.

Something like...