Reputation
437
Top tag
Next privilege 500 Rep.
Access review queues
Badges
3 7 18
Impact
~100k people reached

  • 0 posts edited
  • 0 helpful flags
  • 10 votes cast
Mar
23
awarded  Famous Question
Feb
10
awarded  Famous Question
Nov
12
comment How to keep history of SQL Server stored procedure revisions
I love this answer because once you do it then you get automatic versioning at no additional cost. I agree it's not the same as Source Control, but it's a valuable safety net that should not be ignored.
Oct
5
answered How to turn VARBINARY within PeopleSoft into a string?
Oct
5
comment How to turn VARBINARY within PeopleSoft into a string?
I have tried permutations of CONVERT and CAST, as in:SELECT TOP 10 CONVERT(varchar(max), MIMEDATALONG ,1) , master.dbo.fn_varbintohexstr (MIMEDATALONG ) , CAST( MIMEDATALONG as VARCHAR(MAX)) , CONVERT(VARCHAR(MAX), MIMEDATALONG) , M.* FROM PSAPMSGPUBDATA M
Oct
5
awarded  Editor
Oct
5
comment How to turn VARBINARY within PeopleSoft into a string?
ah, I keep forgetting this is actually PeopleSoft running on SQL Server, so the type is in fact VarBinary.
Oct
5
revised How to turn VARBINARY within PeopleSoft into a string?
deleted 47 characters in body; edited title
Oct
5
revised How to turn VARBINARY within PeopleSoft into a string?
added 45 characters in body
Oct
5
comment How to turn VARBINARY within PeopleSoft into a string?
Thank you. I found that the actual type is varbinary (xType=165) - this gets me closer!
Oct
5
asked How to turn VARBINARY within PeopleSoft into a string?
Jul
11
comment Oracle 11g XE 64bits installation problem on Windows 7
OMG thank you! I wasted about 4 hours on this. You saved me at least two!
May
11
awarded  Popular Question
May
4
awarded  Yearling
Jan
30
awarded  Popular Question
Nov
13
awarded  Notable Question
Oct
22
awarded  Notable Question
Jul
2
awarded  Curious
Apr
17
awarded  Nice Question
Feb
26
awarded  Notable Question