Because these problems arise more than you would think.  Once something like this gets in place, it can creep in and become part of final design.  Then you have to...

Thanks!  I did agree, this should be re-designed.  But my code may help do that by inserting into a Physical table rather than a #TempTable.  The rest is as you...

I did find a problem.  The insert line should read: 

INSERT INTO #List( Word) VALUES( RTRIM( LTRIM( @Word)))

You do need to trim leading and trailing values as you correctly...

Here is one attempt:  [Note, I have inserted the values you provided - you will want to insert your own values from your table....] 

[Remi is correct.  You may want...

Excellent! 

FYI:  you do not have to specify the length when you convert a date choosing one of the format numbers. 

For instance: SELECT CONVERT( varchar, GETDATE(), 120) 

                   SELECT CONVERT( varchar,...

This is very down and dirty, but it gets the point across.  I realized special_id could be used instead of id_intl, but there are other Business Rules, (you will note...

It is a presentation issue.  But here a thread that might help. 

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=182077 

Crap!  I knew I should have done that...  That will take me a bit of time, (and that is where I have to make sure I do not release any real...

Very funny.  I will not forgot this, but I have a bit much on plate right now to get to some type of psuedo-code to give you an idea.  (Heck...

  We'll see.  (It's not like I haven't been wrong before...) 

I'll try and set something up and make a new thread asking...

Might this be text?  You may need to do an explicit convert; CONVERT( datetime, 'dd/mm/yyyy hh:mm:ss am'). 

Either way, this is a guess, and as Remi asked, it would be...

Mine is a bit different in that I have make the calls to find the various percents based upon the sub-areas, (or even sub-areas within different countries).  So while the functions will...

I can't, unfortunately.  This stuff is not for public consumption until it is release and it would be a REAL booger for me to try and make up a bunch...

I was talking about our conversation in general on the use of Cursors, Loops and While statements.... 

Suffice to say, it is not the norm to have to use a cursor or loop.  But, our system does involve multiple scientific codes and multiple dollar prorations assigned to...