Eugene Elutin (3/2/2012)

---

I think you still can do it with ##table, but you need to make everything in to your dynimc sql string:

DECLARE @sql VARCHAR(8000)

DECLARE @IdNbr VARCHAR(50)

SET @IdNbr...

thanks everyone for the responses and help!

I ended up going the route of a permanent table (instead of the global temp table), and adding columns for the date,...

bitbucket-25253 (3/2/2012)

---

Now I have not had the opportunity to check this suggestion, but it might be worth testing for your use

--Creating the command string

DECLARE @IdNbr VARCHAR(50)

SET @IdNbr = '312012145014'

set...

Still have some fine tuning to the process to do -...

Interesting... thanks for the suggestion! will test with this,...

So far, I've not been able to get that to work. Heres the...

bitbucket-25253 (3/1/2012)

---

If memory serves me correctly, I remember this from a long time ago.

Openrowset() (or any ad-hoc function) does not accept variable parameter.

They only take literal string.

Afterall, these are pass-through...

Thanks...