na1774 (5/24/2012)

---

Oh yes It can be. I am sorry.

But I would like to know why a 'CREATE DATABASE' Statement cannot be a part of Transaction. At the same time what...

From the details your provided? Nope.

If you actually want some help you need to help us to help you. Take a look at...

So what really is the question here? At first is seems you need help with an insert statement, then you say something about a job.

The sql statement is pretty simple.

insert...

Then you will either need to tweak the query or explain what "not working as per rules" means.

TheSQLGuru (5/24/2012)

---

Sean Lange (5/24/2012)

---

TheSQLGuru (5/24/2012)

---

Actually Grant I don't see even the slightest hint of a question from the OP - it is just a bunch of code. No request...

Does that work for you?

As the OP pointed out, this is a duplicate thread. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1305928-1633-1.aspx

There is probably a cleaner way to do this but this produces the correct results according to your sample data. I am kind of buried at work or I would...

Not much info in your post here. Pretty hard to offer suggestions about unknowns.

Take a look at the indexes stairway. It is a great series on understanding indexes. I suspect...

Oh, and as for banning - I say "no". You don't have to answer them, you can ignore anyone you wish. If people start getting banned for asking "basic questions",...

TheSQLGuru (5/24/2012)

---

Actually Grant I don't see even the slightest hint of a question from the OP - it is just a bunch of code. No request about what if...

SQLKnowItAll (5/24/2012)

---

Sean Lange (5/24/2012)

---

SQLKnowItAll (5/23/2012)

---

Sean is assuming that these constraints are defined as such. If they are not, it just takes a lot of testing... One of my favorite things...

SQLKnowItAll (5/23/2012)

---

Sean is assuming that these constraints are defined as such. If they are not, it just takes a lot of testing... One of my favorite things to do with...

something like this help?

SELECT f.name AS ForeignKey, OBJECT_NAME(f.parent_object_id) AS TableName,

COL_NAME(fc.parent_object_id, fc.parent_column_id) AS ColumnName,

OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,

COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS...

SQL Kiwi (5/23/2012)

---

How do you...