JeeTee,

These are some awesome examples! I will take a look and change to the logic provided.

Thanks!!

JeeTee, thanks for the input. Can you provide a sample of how I could construct the sql using a sub-query using my query as a template?

Sean Lange, I'm aware...

Gazareth, I will try the update sample you sent.

Jeff, I definitely want to update all values (I don't think there are null values) as I need to sanitized all the...

All comments are good pointers and the sample code provided really helps a lot. I appreciate your help.

You guys are all right, this is madness I've created here. I'm trying to avoid blocking since there are rows that will be inserting in table frequently. Can...

I ended up using ths logic below and it did the trick.

convert(xml,pm.XmlProfile_TXT).value('/XMLProfile[1]/DID[1]', 'varchar(30)')

Thanks everybody for your input and good suggestions! This post is now completed.

-Dave

Ott,

Thanks for the update it's appreciated.

-Dave

Hi,

Did you ever get an answer/solution on this topic? I have the same issue and don't know the answer.

Please let me know.

Thanks!

-Dave

Cadavre,

I'm getting the following error when executing the following SQL:

SELECT ParamValues.XMLProfile_TXT.value('.','VARCHAR(MAX)') AS DID

FROM Payment_Method_T (nolock)

OUTER APPLY XMLProfile_TXT.nodes('/div/ul/li/did') ParamValues(XMLProfile_TXT);

Msg 9506, Level 16, State 1, Line 1

The XMLDT method 'nodes' can...

Lowell,

It's only one occurence (e.g.<DID>) in the XML and your right I only want the data between the tags. Would the samples you posted do the trick? I...

Eugene, you are the best! I will try this code and see if this works for us. I also verified that the data stored for "FlightDate" is indeed...

You're probably right that the data isn't converted from UTC to CST when the data is saved to the db. So how would I just report the "FlightDate" on...

The Crystal Report server and the Database server are both in (Central Standard Time), but I keep hearing the developers and manager talk about the data we receive in the...

They were using TOP 1 clause in sub-select and it caused the issue. Hope this helps.

Ignacio,

Yes, I have run that query previously but I wasn't sure what to look for. We actually fixed the issue. It had to with how the Select statement...