Mine too 😀

For example, say you use sp_executesql and you have 2 parameters name and city. If you execute this statement

set @sql = 'select * from my table where name =...

If you use the exec method, SQL server cannot reuse query plans. This means that everytime the code is run SQL server must generate a new query plan. ...

After briefly looking at the function. I would still use the proposed solution for performance benifts, but will acknowledge that openquery can accomplish the task.

This is what I get for speaking in absolute :hehe:. Well on a...

You can only select the results of a stored procedure by dumping the results into a table. You have to make sure that your table has the same number...

Sorry for the confusion. I put the parenthases to show...

You can do something like

INSERT INTO TABLE1

SELECT MY COLUMNS

FROM TABLE2

--WHERE IF NEEDED.

You should be careful that keys and/or unique fields do not overlap.

edited to remove ()

You still need the format file, so...

BUT... does having an 'exec' embedded in my @strExec string defeat the purpose of using sp_executesql? I am not worried about sql injection in this case so should I...

I found this procedure from the code repository on this site :).

/*

Server Backup History Report

(Full DB Backups only)

1.lists all databases with no backup history

2.lists last backup for other...

somehow I posted above the previous post.... :hehe:

This post is strange because it does not have a question at the beginning.

I need to be able to set a flag from 0 to 1 when the...

You are right, I was refereing to the report designer in BIDs. You are refereing to the ad-hoc report builder. There should be a similar option for ad-hoc reporting.

Does the row in question contain anything else or just the one character?

It sounds like your field/column terminator is set incorrectly.