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

I found this recently:

if powershell is installed on the server, you can use that to add yourself (your domain login) as a sysadmin;

this example does the same thing by...

a trigger featuring a linked server was what i was suggesting to avoid; network problems or permissions issues related to which remote user is used to insert into the remote...

i spent a bit of time on this same thing before, and it really depends on the results you are looking for, and how deep you want to make them...

Tobar (3/26/2013)

---

I see that part, but the error I was getting, which I should have mentioned in the beginning, was

"Error converting data type nvarchar to numeric". And I don't think...

take a look at the syntax for an oracle trigger here:

there's an example there, and you can see how fields are referenced with the :columnname indicator

see if that helps you...