This works better, I believe.

Yours was suffering from a nasty cross join that was mixing up the data (see ID 2 for example)

;WITH MyCTE([ID],[val])

AS

(

SELECT 1,'03,0000001,USD,010,81257946,,' UNION ALL

SELECT 2,'03,0000001,USD,010,81257946,,,015,121809761,,' UNION ALL

SELECT...

LinksUp (2/23/2015)

---

robert.wiglesworth (2/23/2015)

---

From this table, I would like a query that would give me this result:

01/15/2015 07/31/2015 2555 ...

Another option to consider is IN

WHERE '123' in (Pend1,Pend2,Pend3...)

Yes, I get the same - it's not very helpful is it?

I hope this prompts someone to point out how to spot the difference...

I don't have any idea why this is happening, but I would personally fire up Process Monitor

from https://live.sysinternals.com/tools

Filter it down to SSMS and see what is happening.

The other troubleshooting you...

Another possibility, non-sargable:

and replace(B.MasterAccount,'0','')=''

Yes, they are quite "normal" - https://msdn.microsoft.com/en-GB/library/ms189799.aspx

If you can't script them out, I would assume they are encrypted - a quick search for SQL Decryptor[/url] will let you overcome that.

Your expected output appears to just be a straight selection from the input, but it's hard to tell with the post unformatted as it is.

Could you maybe provide your input...

Have you set "RetainSameConnection" to False?

Jeff Moden (2/5/2015)

---

Absolutely awesome! I could be wrong but it doesn't look like it would handle the "SHIFT",...

Hi Jeff,

I have one also that handles A, B and C

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

Thanks for sharing this.

Is the VPN directly into the server?

If so, connect the VPN, then on the client, open a dos prompt and type

ipconfig /all | find "DHCP Server"

Hopefully, this will reveal the...

dmbreth (2/2/2015)

---

I recently was asked to concert some Oracle data to a SQL Server database and was directed to change all "quantities" into floats. These quantities could be currency...

That sounds an awful lot like you have this server sat "on the internet", so please make sure you don't open the firewall!

Also, it sounds like you are trying to...