spencer7593

spencer7593 has asked 5 questions and find answers to 255 problems.

Stats

About

spencer7593 questions

Any suggestions for improving (optimizing) existing string substitution in Perl code?
SQL query to return NULL for SUM(expression) whenever an included value IS NULL
replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
How to identify invalid (corrupted) values stored in Oracle DATE columns

spencer7593 answers

MySQL cursor not working with Stored Procedure
MySQL LIKE keyword not returning expected result
MySQL query is too slow, how can I improve this?
mysql stored procedure parameters don't seem to work with "@" (At sign)
MySQL Call procedure inside function for count
SQL NOOB - Oracle joins and Row Number
SQL: field value based on condition?
Dynamic calculations in a materialized view
Why Time(UTC) difference occurs in application running in local to azure?
join on indexed fields doesn't utilize indexes