TheSQLPro

Ayman is a passionate SQL Server DBA, Developer, and Business Intelligence Developer. His passion for technology started when he was a young boy playing DOS games on his father's computer. From there, he moved up to computer programming in high school and went on to get B.S. and M.S. degrees in Information Systems from Drexel University in Philadelphia. He has worked with the SQL Server product since 2006 and has experience with SQL 2000 through SQL 2012. He holds a MCITP SQL 2008 DBA certification and is also a Microsoft Certified Trainer (MCT. He has been active with the virtual chapters of PASS, participating in online training and also giving presentations. Ayman has lived in many different countries around the world including the U.S., U.K., Egypt, Saudi Arabia and speaks fluent Arabic. He is huge football(soccer) fan and is always looking forward to learn more about SQL Server, SQL Server BI, and technology in general. www.thesqlpro.com

All authors

All authors

Blogs

AgentDBA vs Critical SQL Server

By

It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...

Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone

By

I’ve had a Dropbox account for years. Like a lot of people, I started...

KDA: Echoes of Deception - Case 4

By

Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...

Read the latest Blogs

Forums

identity increments by 10,000 when it was supposed to be 1

By stan

hi a peer of mine who ive never known to be wrong says a...

Displaying Money

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Displaying Money

The Slow Growing Problems

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Slow Growing Problems

Visit the forum

Question of the Day

Displaying Money

I want to get the currency sign displayed with my amount stored in a money type. Does this work? 

DECLARE @Amount MONEY;
SET @Amount = '?1500';

SELECT CAST( @Amount  AS VARCHAR(30)) AS Euros

See possible answers