I always insert the parent row first, get @@IDENTITY into a variable or output parameter, and then use that ID to insert child rows. Getting ETL processing in that order...

Lynn Pettis (4/7/2016)

---

Rod at work (4/7/2016)

---

Peter Schott (4/6/2016)

---

Rod, I did that very early on when I was just starting out. I ended up moving without any idea if I'd find...

Why are folks still listing SSDE licenses for sale on eBay, when it can be downloaded for free ? 😛

This appears to be functionally equilavent to how identity based identifiers work, only what you're doing is a lot more complicated and requires coding in every stored procedure that inserts....

Oracle, eat your heart out!

All you resellers on eBay can eat your little hearts out too. Ha!

http://www.bing.com/search?q=site%3Aebay.com+%22sql+server+2014%22+%22developer+edition

I'm not understanding the following. Is [GDML.eResults.UserStore] a database with an odd 3 part name containing periods, or is this a reference to a remotely linked database/table?

[GDML.eResults.UserStore].[dbo].[vw_aspnet_UserProfiles]

There are many naming conventions that prescribe things like case, underscores, plural vs. singular, or hungarian notation, but here are some more general guidelines that should apply regardless.

A column should...

Michael L John (4/7/2016)

---

DavidL (4/7/2016)

---

Eric M Russell (4/7/2016)

---

.. The tables in a JD Edwards system were coded with a short alpha sequence and then a 4 or 5 digit number....

Ha!...

By default, a new login has access no databases, and once granted access, they cannot select from anything.

To maximize security, I'd suggest first creating a view that joins the required...

We have open positions for SQL Server DBAs and Database Developers (v2008 - v2016), if anyone is interested in the North Atlanta area, specially Kennesaw/Marietta. Good job market, affordable housing,...

By default, a SQL Server processes will not timeout, unless it is in deadlocked state (an unresolvable locking contention) with another process. In a worst case scenario, a poorly constucted...

🙂

Iwas Bornready (4/5/2016)

---

You just do the job to keep food on the table and a roof over your head. If you are abused get another job. If you can't then...

Rod at work (4/5/2016)

---

Eric M Russell (4/5/2016)

---

Rod at work (4/5/2016)

---

I got caught up reading people's replies to this thread, when I realized that this thread indirectly points out something...