Reputation
432
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 7 18
Impact
~91k people reached

  • 0 posts edited
  • 0 helpful flags
  • 10 votes cast
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
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
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
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!
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!
Apr
3
comment Oracle equiv of T-SQL UNION ALL query
Absolutely right, it worked all along. The actual statement was much longer, and in my final Group BY I had a space where a period should have been. But you breaking it down helped.
Apr
3
comment Oracle equiv of T-SQL UNION ALL query
I get this super-helpful error: ORA-00933: SQL command not properly ended
Sep
16
comment Linked server issue
OK, thanks. I was hoping there would be a solution that would not require acting on the remote database.
Aug
16
comment T-SQL command to log in as a different user?
Just what I was looking for - thank you!
Jun
12
comment DB2 equivalent to T-SQL's REPLICATE?
perfect - thank you!
Sep
22
comment Is there a way to have SQL Server format a number into ordinal form?
presentation layer is InfoMaker. very crummy program, so as much as we can push into the database, we do.
Sep
2
comment Sql Server Management Studio for 2008 Express?
I do have a license for the fill Sql Server, just not wanting to put more than I need on the laptop.
Aug
16
comment How do you reset the sa password?
The account was the local Administrator account itself. This account is part of the local Adminsitrators group, as is my domain account. But only the local Administrator account was able to use Windows authentication to log into Sql Server. I hope that helps.
Aug
16
comment How do you reset the sa password?
Found the answer. I could not log in as a a domain admin, but using local admin worked fine.