The only way to pass something back from Dynamic SQL is through a Table: temporary or permanent (table vars will not work).

You can pass limited info back through an Error...

Yes. In the SSMS Explorer pane, right-click on the database and pick "Tasks > Generate Scripts". From these script drops for all of your tables, and include "Dependent...

Disable automatic updates on the Windows Server?

kevriley (6/24/2008)

---

So off I went an issued an update to change the link using T-SQL. Checked the row, all changed - checked Sharepoint no change at all???

Anyone...

Dynamic SQL.

Actually, it's a different error now. This should do it:

SELECT

DATEADD(minute,(convert(bigint,lastlogon)*100.0/POWER(10, 9) - (CONVERT(bigint, DATEDIFF(minute, '1/1/1801', '1/1/1953')) * 60))/60, '1/1/1753') AS date

from dbo.smx_empdirectory

You wrote your stored procedure to require 5 parameters and you are not passing any to it.

How can we help you with that?

Actually, I think that this will fix Jack's original code:

SELECT

DATEADD(minute,(convert(bigint,lastlogon)*(100/POWER(10, 9)) - (CONVERT(bigint, DATEDIFF(minute, '1/1/1801', '1/1/1953')) * 60))/60, '1/1/1753') AS date

from dbo.smx_empdirectory

Folks:

For What It's Worth: I sincerely doubt that I would have gotten this question right myself. I am pretty sure of that because I have actually tripped...

Melville (8/7/2008)

---

Good question, the bitwise XOR ^ made this a school day for me (always good). Once I took out the -17 it became clear that sqrt (n^n) (n...

Thanks, Andy. And yeah, I thought that hardly anyone would even be...

Almost:

DECLARE @a BIGINT

, @b-2 BIGINT

SET @a =...

GilaMonster (8/7/2008)

---

I started downloading it last night, stopped when I noticed the size. 3 GB download will use my entire...

Yikes! You are right, "@b" shouldn't be...

You can however, use Schemas to have a similar naming and organizational format. But it is still a lot different.