SQLCrazyCertified (4/16/2012)

---

Lynn Pettis (4/16/2012)

---

SQLCrazyCertified (4/16/2012)

---

Mike John (4/14/2012)

---

If a column is defined as a primary key, then by definition it cannot be null, so you cannot do anything to allow nulls...

SQLCrazyCertified (4/16/2012)

---

Mike John (4/14/2012)

---

If a column is defined as a primary key, then by definition it cannot be null, so you cannot do anything to allow nulls in there.

It...

Absolutely no idea. I see no decernable pattern in the values...

A + B - C. There, a formula as useful as anything you...

And then there are those that you think should be able to understand what you are telling them only to have that believe shot out from under you.

Looking at this line:

SET@OpenQueryPrefix = @OpenQueryPrefix + ', ''SELECT COUNT(*) AS400TableCount FROM ' -- << and here

AS400TableCount is a column alias, I am naming the column that contains the value...

Welsh Corgi (4/16/2012)

---

Lynn Pettis (4/16/2012)

---

The select count(*) in the openquery still has no alias and you are still doing a select * from the openquery and not assigning anything to...

The select count(*) in the openquery still has no alias and you are still doing a select * from the openquery and not assigning anything to the variable that ultimately...

Okay. Have fun. Let me know how it goes.

Yes, but I would HIGHLY recommend NOT doing it.

This:

SET @SQLQuery = 'SELECT @cnt = COUNT(*) FROM ' + @SchemaName...

In the actual OPENQUERY, you do a select count(*). Add a column alias there.

In the select that uses the openquery, you simply do a select * from openquery(...)). ...

Larry Page(Ehsan.Akbar) (4/16/2012)

---

Lynn Pettis (4/16/2012)

---

Phil Parkin (4/16/2012)

---

Study the play of Barcelona.

Not really anything to do with SQL...

Can you add a column alias to the count(*) in the select from the as400 table? If so, then do that, then select that column name in the outer...

Not sure why, but...