Hi Atif,

you need to remove the '%' from the left side of your like clause.

Otherwise a val='23456789123' will show up as a result, but it shouldn't.

You can query the text column of syscomments.

Hi,

did you try the PATINDEX function?

The following code will check the start position of each value from your table within the given search string.

It will return the max. number with...

Hi,

I need to ask the same questions as in my previous post again since you didn't answer one of them yet.

You're just rephrasing the original question.

When I asked how the...

Hi,

could you please describe a little more the purpose of your requirement together with some code you've tried so far?

What kind of project are you woring on?

How can be determined,...

Easiest answer: Try and you'll see the difference...

Or, to explain it without trying:

The substring function removes the first two characters, which are a comma and a blank as per the...

Hi,

you're missing an aggregate function over the column DayToreceive.

Hi Karen,

I can't really see any difference.

Attached please find a screen shot of the code I used and the results I got.

Looks like the code is identical to yours.

Are you...

Hi Karen,

I just tested both of your attached files and both show up using the code you provided.

There seems nothing to be wrong.

Please don't cross post.

For replies please refer to post http://www.sqlservercentral.com/Forums/FindPost703604.aspx

Hi JacekO,

the issue regarding the update statement for this specific procedure has been discussed in the following thread:

http://www.sqlservercentral.com/Forums/FindPost681895.aspx

Your code snippet in post http://www.sqlservercentral.com/Forums/FindPost703959.aspx is the scripted form of the...

You should not leave the code just "as original as possible".

Either fix it to be runable code again (returning the same results as original) or drop it. If needed, you...

Glad I could help.

Hi,

you need to declare the namespace you're using (xmlns:p1).

The SELECT statement is the same. I Just added the NAMESPACE declaration.

;WITH XMLNAMESPACES (

DEFAULT 'OtherInfo',

'http://www.w3.org/2001/XMLSchema-instance' AS p1

)

SELECT tab.col.value('../../@MerchantNumber','varchar(50)') AS 'MerchantNumber',

tab.col.value('@TerminalID[1]','varchar(4)') AS 'TerminalID',

tab.col.value('@GrossSalesSubmitted_1[1]','varchar(50)')...

Hi,

please see the following article on how to use cross tabs to get the results you ask for.

http://www.sqlservercentral.com/articles/T-SQL/63681/

If you need to get specific answers for your issue please read the...