Think of it as a proc within your proc. The main two reasons are for execution plan re-use and security.

Take a look at this link and see if the condition described fits your circumstance.

Generally I would advise doing the formatting in the presentation layer, but if you have to do it in the query:

select CONVERT(CHAR(8),DATEADD(SECOND,PackageDuration, 0), 108) + ' ' + CONVERT(CHAR(24), DATEOFRUN,...

This is something I've seen in the past for warehousing, but I've also heard it's a bad practice because you don't gain anything and it takes away date manipulations (such...

Very good point ... it most definitely does have a huge impact on outer joins.

Revenant (1/4/2012)

---

I do, however, have doubts about a law that, as I wrote in one of my earlier posts, allows the government to shut down ANYBODY'S Web site on someone's...

For small amounts of data it's not a big deal, but any kind of string manipulation gets horrible really fast in T-SQL if you have any kind of volume of...

I think this is fairly standard and generally good...

Read how a merge is supposed to be used here.

Your update statement is wrong for starters. The updates and inserts are inherently performed against the target .... whereas you're...

To be clear I want to make sure this point is understood ...

With the code you have given, the catch on the outer proc is never going to be executed....

To me, it seems like it would be cleaner to handle the transaction completely in the inner proc. Otherwise, if you can't, if it fails 3 times in the...

Anyone against SOPA is either making money by stealing others intellectual property or they are not familiar with what the proposed legislation actually say or both.

I would like to see...

erikpoker (1/4/2012)

---

Hello,

Im selecting values from a table a:

SELECT a.col1, a.col2, a.col3, a.foreignkey-value

FROM mytable a

WHERE something=something

If the foreign-key-value is null i would like to insert it into the parent table on...

I'm guessing there are some normalization issues based on what you've provided. If you would like additional help, it would be helpful to us if you provide more specific...

Actually, I need to read better. This would give you the string to the next space, or it would give you the string to the end of the value...