i suspect you need to use ISNULL for each of your columns, right?

concatenating NULL to anything is null, so i think that's the problem:

DECLARE @tableHTML NVARCHAR(MAX);

SET @tableHTML =

N'<H1>Hot Item(S)...

you don't really print results; you'll want to toggle between grid mode and text mode to get the results you want.

in SSMS click control + t to switch to text...

also, isn't your UPDATE statemnt in a non-SQL server format?

i'd think it should be something like this:

UPDATE p.dbo.B

SET hotflagemail = 1

WHERE isnull(available_qty,0) = 0

AND isnull(available_qty_temp,0) = 0

AND...

exec sp_tables_ex MyLinkedServer will show you all the tables in the linked server that you can directly access; from there it's things like select * from MyLinkedServer...Tablename, and you might...

Paul thank you so much for providing the code you were trying to use; it gave me everything i needed to try and look at the issue. Since this was...

no it's not possible; the html textbox item itself does not support internally changed fonts;

you could use a <span> tag instead of a textbox, that would allow you to put...

some errors are driver specific; your error said this specifically: spaces, tabs, or carriage returns as delimiters.

my code obviously had lots of CrLf's for readability; can you jsut add a...

no it's not. variables do not have row indexs or columns.

your multiple quotes demonstrate it over and over again:

v_accounts_info_table(index).account_sequence for example

v_accounts_info_table(v_account_id).account_sequence...

i think in Oracle, a semicolon is manditory to determine the end of a statement;

i reformatted your queries and pasted them into SLq Developer, and got the same error.

when i...

the utility i described should work for you;

i found out the hard way on a new Windows7 laptop; the security is tighter, and it does not automatically add the person...

so you are not going to provide the CREATE TABLE definition of v_accounts_info_table?

you keep posting variations of the same oracle function over and over instead of providing the information...

I've looked at this at least half a dozen times, and still cannot see what it is doing, because i never see the table definition it is fiddling with.

this oracle...

Henrico Bekker (5/5/2010)

---

Because the sql user account needs to be created on sql server level as well, not only db level.

drop the account from the DB, recreate it on sql...

i think you can use the Surface Area Configuration tool to add yourself as an administrator, and then change the passwords of the lost admins, including "sa", right?

Well, my SSMS is actually what gets installed with SQL 2008 standard; it runs the reportagainst any database I point it at;

your SSMS might not have that feature;

anyway, i profiled...