Hi

Sorry but I don't understand your request. The "match" column contains only zeros. Why does 1 match with 2 but not with 6 and why does 7 match with 8...

Vandana.verma (4/22/2009)

---

When the user clicks on the button, the following should happen:

The system should check if any of the rows of a table that satisfy some condition ONLY...

Hi

I can can reproduce this. It seems that the CATCH block ends with the SELECT. Just try to add two PRINT lines above and below the "SELECT 0". The first...

I'm glad I could help 🙂

Paul White (4/21/2009)

---

Jeff Moden (4/21/2009)

---

It's not the presence of TOP nor ORDER BY. It's the presence of UNION ALL. In the testing I did with Flo, I actually...

Hi Code

Sorry, didn't notice the variable declarations...

If the value of the variables is same for all databases, as in your sample, you can use sp_executesql and transfer the values from...

Bob Hovious (4/21/2009)

---

Flo and Jeff, I just had to try.

This beast features double-barelled carburetors.... errrr tally tables.... one with two columns, and nested CROSS APPLYs.

Can you...

Heh... Thanks Chris 🙂 but not first time. I should stop tryin' to write...

As usual Paul is up - shift changeover - time for bed (12:42 AM)...

This stays a great pity!

On first look, the performance improvement is down to the...

Just mask your apostrophes with double apostrophes and replace the "PRINT ''Hello from: '' + DB_NAME()" of my example. I don't know a better way for this:

DECLARE @sql NVARCHAR(MAX)

SELECT...

Hi

You can use a dynamic SQL statement:

DECLARE @sql NVARCHAR(MAX)

SELECT @sql = ISNULL(@sql, '') + 'USE ' + name + ' PRINT ''Hello from: '' + DB_NAME()' + CHAR(10)

...

Hi

I confirm Jeffrey. As your sample data are shown the usual answer MUST be a scalar function. Could you please explain what you want to do?

Greets

Flo

Jeff Moden (4/19/2009)

---

Just curious.... lot's of folks call what's stored in VarBinary, well... Binary and it's actually displayed as hex. So, pardon my ignorance of which you speak, but...

Sure, I would be happy about!...

Bob Hovious (4/21/2009)

---

Flo:

After following the Tally thread, there is no way I can claim to be your mentor. However you are welcome to any little tips or...