The query was written by someone who no longer works for the company. I did not get a chance to meet them.

I'm looking to SUM pd.premium_amounts. Originally I wanted to...

Kristen,

Thank you for replying to my post. I tried using both approaches COALESCE and ISNULL with no changes in the number of rows that were returned. I did need to...

What sort of...

What if you have multiple columns with the same name in the xml file. how can those be concatenated into one field and what if element lives in one app...

Flo,

I am referencing a .xml file that lives outside of sql in MyDocuments. Can you provide some xml code which you import that generates a table with unique columns and...

When you say newely introduced XML methods are you talking about using the import/export wizzard or something else ? I tried using the wizzard but was having trouble with it...

Im sorry for my halfass post earlier. Here is the correction version. substitute values of course

SELECT

CASE

WHEN CONVERT(varchar(10), B.Date, 121) IS NULL THEN '1900-01-01'

ELSE CONVERT(varchar(10), B.Date, 121)

END AS Date

FROM...

Wilfred,

In addition to what everyone else has mentioned, you can also set up a case statement to populate the null or blank fields after they have been inserted.

SELECT

CASE

WHEN dateum IS...

There was a post very similar to what you are trying to accomplish. Here is the link http://www.sqlservercentral.com/Forums/Topic581296-359-1.aspx

-Chris

WOW im such a doof all i had to do was put the ORDER BY outside of the select like this. thanks for the advice though

DECLARE @tableHTML NVARCHAR(MAX)

SET...

Chris M.

This seem to work. I was looking at using RTRIM in an IF statement but that did not get me anywhere. I guessed I looked too deep into this...

Lowell,

I see how this case statement works however it is more complicated than the LIKE statement below. Being fairly new to SQL, I like to keep my code as simple...

Jack,

Yes that is the main requirement for this stored proc. The code that you provided looks like it will fulfill that requirement. This looks much cleaner than the code that...

Trader Sam,

Yes this list needs to be comma-delimited. I applied the changes however this does not solve my problem. thanks for pointing that out though. I still in my early...

Jack,

My apologies for not explaining the situation thoroughly. The stored proc is returning agents from states other than TX, FL, and LA. It is just that those states are primarily...