Thanks for the insight guys; I'm still hoping for some more suggestions.

My non profit wouldn't even spend the five dollars per mailing, but would love for me to invest hundreds...

the command you posted is from MYSQL;

SQL doesn't do file writing operations directly, you typically would use BCP OUT, or a CLR, or an application to write to disk when...

it's like...

...ORDER BY ?

BIDS is a trimmed down version of VS2010 with the project templates related to Business Intelligence installed.

i have VS 2010 professional, and I have SQL 2008 standard installed on my...

based on your example code, Lynn's post, barely modified for the column name, works perfectly:

declare @SQLCmd nvarchar(max);

select

@SQLCmd = stuff((select N'union select MFG from ' + TableName...

my take on it, was to make a view from the data;

you'd need to update the view whenever new rows get added.

SELECT 'SELECT MFG FROM ' + ApplianceTypeTableName + '...

Any and all databases which used to exist in any version of SQL, and was restored/upgraded to a higher...

after an upgrade from a lower version to a higher version, it's pretty much mandatory to rebuild statistics with fullscan;

the update engine uses different statistics/uses them differently, and performance is...

are you sure it's not an index rebuilding session that is making the tempdb grow? the frequency, of noticing once or twice a month sounds about right.

everyplace you have the column represented by @c must be replaced with a convert(nvarchar,@c); so if it's occurring 4 times in your expression, change all four...i think i missed the...

convert the column to nvarchar(max) instead.

SELECT SUBSTRING(

CONVERT(NVARCHAR(max),YourColumn),

CHARINDEX('>', @c) + 1,

LEN(@c) - CHARINDEX('>', CONVERT(NVARCHAR(max),YourColumn)) - CHARINDEX('<',...

change this to a larger number:

SUM(CONVERT(DECIMAL(11, 0), a.value)) AS total

something liek this:

SUM(CONVERT(DECIMAL(19, 4), a.value)) AS total

or

SUM(CONVERT(float, a.value)) AS total

does it work then?

you keep bumping into the limits of your...

OK i now see that SQLFiddle is for MySQL, not SQL Server;

i guess it is some kind of front end tester, where you can build a temporary schema in the...

no username or password.

here's some detailed instructions:

http://beyondrelational.com/modules/2/blogs/115/posts/11143/how-to-access-a-newly-installed-sql-server-2008-r2-instance-if-you-do-not-know-the-login-and-passwor.aspx

from the machine itself,

sqlservr -m"SQLCMD"

then when connected, add yourself or a new admin:

CREATE LOGIN [testAdmin] WITH PASSWORD=N'test@1234', DEFAULT_DATABASE=[master];

EXEC sys.sp_addsrvrolemember @loginame = N'testAdmin', @rolename =...