If you don't mind doing it yourself, right-click on the preview of the actual report - you will get an option to export it (Excel and Adobe PDF were my...

GilaMonster (12/16/2007)

---

Personally, I'd rather they didn't, and asked people who do to write them the DB objects they need. In my experience, it's the people who know a little about...

There are also several versions of Express. For one - the initial SQLExpress version didn't come with SSMSEE, but the newer does (and there is a separate download for...

Well - I tried to manage the Developer edition from SSMSEE and was told I couldn't. So - at very least there's some logic there that's a little different....

As long as you're running with within the same OS session (a.k.a not talking about VM's), no - one set of licenses covers your instances.

If you're talking VM's there's another...

Well - like I said - let me know if you have any luck finding it. I just haven't seen anything on it, and might need to scramble on...

Thoughts - see if any of these "stick":

- instead of continuously creating #temp tables, what about using a "permanent" temp table? Meaning - dump all feeds into one...

Rog - where are your values coming from (The ones you wish to insert)? A table?

I hadn't noticed the window title. That should help a lot. Good enough for now....

Thanks Steve!

(rolling sleeves up)

Thanks for the update...I need the DDL of the tracking table it's updating. If there is a loop in the end result, it will be...

All right - now THAT's ugly.... Tell me - what does get_next_CRM_ID do?

Using that proprietary thing right there is the reason you're jammed up. Looks to me that...

Jason Selburg (12/17/2007)

---

Depending on what the procedure eware_get_identity_id does, I think this is what you're looking for.

INSERT Phone

SELECT

...

No yelling here....but let's see if we can do away with that cursor....It's got nasty overhead, and performance is usually why we get rid of them....

Could you post what...

Deprecated means it might not be supported in FUTURE versions of SQL server. they're giving you time to switch your code around. Some features are marked as deprecated...

While it might be nice to do that, you've now destroyed any abilty to enforce relational integrity, so by "saving" yourself one table, you've now DEnormalized (since your FK no...