Love to Help
Give a man a fish and you've fed him for a day; Teach a man to fish and you've fed him for the rest of his life. Be the teacher
Have survived close to 4 decades (give or take a couple of years) in the computer industry.
I am interested in helping pure and simple, and appreciate the acknowledgements of a heartfelt "Thank you" (though do get a smile when points come this way). I can assure you that I will try my upmost to assist, but it does require your input, and sometimes ask seemingly obscure questions to get to the bottom of things.
Please be interactive with your postings, give feedback, provide direction, give examples where possible. Wherever possible, I will recreate and test the answer before posting, hence the slight (?) delays. So, please help me to help you, if I do provide an answer, or if I do raise a question, give it some consideration before moving on to another post.
For EE specific contact please message me using the EE system.
Humbled and privileged by being awarded Microsoft SQL Server MVP.
Articles I have written (would love you to read, and vote "yes", and leave comments) :
Pivot :
https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/A_653-Dynamic-Pivot-Procedure-for-SQL-Server.html
https://www.experts-exchange.com/Programming/Languages/SQL_Syntax/A_4256-Dynamic-Pivot-Procedure-without-the-Pivot-function.html
Structure (and not just for the accidental DBA) :
https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/A_657-Managing-the-Transaction-Log-for-the-Accidental-DBA.html
https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_691-Managing-Fragmentation-for-the-Accidental-DBA.html
Other SQL :
https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/A_651-Making-Sense-of-Index-DMV's-in-SQL-Server.html
https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_1221-Fun-with-MS-SQL-spt-values-for-delimited-strings-and-virtual-calendars.html
https://www.experts-exchange.com/Database/Miscellaneous/A_12816-What-is-Big-Data.html
https://www.experts-exchange.com/articles/20059/T-SQL-formatting-Dates-and-Times-using-FORMAT.html
Consulting :
https://www.experts-exchange.com/ITPro/Consulting/A_3217-The-importance-of-Value-in-Business.html
https://www.experts-exchange.com/ITPro/Consulting/A_3220-Negotiating-Loss-for-a-Win-Win.html