Heh. You...

Really??? Jeff, I must be dense, because the initial "Owner" field...

tshad:

Dynamic SQL can use Views, but AFAIK, there is no way(*) for a View to use Dynamic SQL. Not even indirectly through a Table-Valued Function, as they don't allow...

Is this from the same server that the hidden SQL Instance is on, or another one?

And, what protocols does your SQL...

I do not know how to do this in SSRS, but I have occasionally done it in SQL Server with a set of Unioned Views.

How many different objects...

How are you checking for it?

Jack Corbett (5/14/2012)

---

RBarryYoung (5/10/2012)

---

Koen Verbeeck (5/10/2012)

---

Stefan Krzywicki (5/10/2012)

---

Yeah, I created the import package manually. I ended up getting the table structures by using an openquery in a cursor...

I do have some familiarity with VBA and ADO (though it has been awhile).

What I cannot help noticing is that the Parameter names used in your VBA code...

Ack! Lynn beat me by 55 seconds!

Geoff A (5/14/2012)

---

Hi Lynn,

Q1: Why were table variables introduced when temporary tables were already available?

A1: Table variables have the following advantages over temporary tables: •As mentioned in the SQL Server...

Hey, you too, Jeff. 🙂

No. Like this:

DECLARE @retval XML

DECLARE @sSQL nvarchar(500);

DECLARE @ParmDefinition nvarchar(500);

DECLARE @tablename nvarchar(50)

DECLARE @ApplNbr VARCHAR(20)...

You need to assign to @retvalOUT inside the sp_ExecuteSQL string,

I would probably try something like this:

SELECT CompanyNumber,

CompanyName,

CompanyType,

...

Now, now, don't be greedy Jeff, just pick one or the other. 😀