N West

N West has asked 3 questions and find answers to 24 problems.

Stats

About

I'm a Principal Consultant in the Data Solutions practice for a great company, Cardinal Solutions, located in Charlotte, NC.

N West questions

LISTAGG equivalent with windowing clause

N West answers

SQL Server 2008 R2 Encryption Issue, when Decrypts Show Special Characters
Star schema [fact 1:n dimension]...how?
Oracle SQL - Select date between month-current year(-1) to month-current year
most efficient sql for retrieval
How to Write Optimal SQL Queries
Check status sql query or percentage
PL/SQL passing functions as parameters
How to model process and status history in a data warehouse?
SQL ORDER BY within OVER clause incompatible with CLR aggregation?
How to restrict the length of INTEGER when creating a table in ORACLE?