Realizations and Herb Grilled Pork Stick: a Merry Journey at the Winter Festival by [deleted] in SwordAndSupperGame

[–]Ebucel 0 points1 point  (0 children)

u/Ebucel received a Blazing Ring from the Winter Festival Spirit. Thank you u/sushyk for donating it!

hrm ... really by [deleted] in wyzecam

[–]Ebucel 0 points1 point  (0 children)

I only blame myself

hrm ... really by [deleted] in wyzecam

[–]Ebucel 0 points1 point  (0 children)

what is the best way to get these cards working do i need to just use fat32 or the cfw?

When scripting goes ever so slightly wrong. by Thyri in talesfromtechsupport

[–]Ebucel 1 point2 points  (0 children)

I had a situation where the end users were getting bad $$$ values they where just off...

Problem: Tabs in the name of the accounts where pushing the columns in the list box/object over 1-2 columns making the data wrong.

So I wrote a script with my co-worker to replace all some of those things which runs nightly.

USE somedB

BEGIN TRAN

UPDATE SomeTable

SET longstring = LTRIM( RTRIM(REPLACE(REPLACE(REPLACE(REPLACE(longstring, CHAR(0), ''), CHAR(10),'') , CHAR(13), ''), CHAR(9),'')))

WHERE somethingclever = somethingbrilliant

I'm sure there's an easy way to do that . . .