If you can explain what you are trying to do we can probably help. Depending on your usage you might be able to use user defined types.

In reality nested transactions are a myth. http://sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%282630%29-nested-transactions-are-real.aspx

You will have to modify your existing procs a little to handle this. Below is how you could modify my previous example to make this work. This will still execute...

Not sure I totally understand your question. Are you talking passwords stored in the database that are used for an application or the passwords used for sql logins?

SQL logins...

Wow this is confusing. It would help your case a LOT if you read the first article in my signature. I can't tell if you need the tally table, a...

Once you hit your rollback this will fail. Your catch inside one of the nested procs will cause the transaction to be rolled back. Your outer try catch will fail...

mark.sayer (6/18/2012)

---

Thank you everyone for your help, especially Sean.

The underlying problem was casting a varchar(max) into a decimal. If I change this to cast to a float the problem goes...

I highly doubt that any single response was the "answer". There were several different things posted and it was most likely...

Connections are not made to tables, they are made to the database.

Anatoly Ukhvanov (6/15/2012)

---

Folks, did you see that?! I'm not a grasshopper any more! I'm now SSC Rookie! :w00t:

Could anyone explain to me, a ukrainian, what does it mean? Which meaning...

That is what that import tool does. It would be nearly impossible to convert the actual sql automatically. If you want to convert it to a view you will have...

I asked that...

mark.sayer (6/15/2012)

---

The CROSS APPLY seems to return the results in triplicate. I can't use DISTINCT as i've other columns in my select.

The NOLOCK hint is for speed, the query is...

ChrisM@Work (6/15/2012)

---

Sean Lange (6/15/2012)

---

The answer...

http://msdn.microsoft.com/en-us/library/ms188783%28v=sql.105%29.aspx

You might want to do this during off hours especially if the table is large because it might take a bit of time to create the index.