James Phillips is a Sr. Consultant with Pragmatic Works and has been working with SQL Server since version 6.5. James lives in Northwest New Jersey with his wife Amy and has 4 children: Hannah, Lillian, John and James Jr. He has spoken at several SQL Saturday events over the past few years and is the Leader of the PASS New Jersey SQL Server User group. His focus is mainly on SQL Server Performance as well as SSIS and SSAS technologies.

All authors

No written on Red button

Don’t be afraid of No

How many times have you been afraid to hear “No”? We have all been there because we have been trained over the years to perceive “No” as a rejection,...

2020-07-17 (first published: )

495 reads

Blog Post

MS Ignite Day #2 Recap

Day 2 was my opportunity to be focused and dive into a few technologies that were really peaking my interest, namely Azure Synapse Analytics and SQL Server 2019. Since...

2019-11-13 (first published: )

301 reads

All authors

Blogs

5 Starter Projects for Your AI and Data Engineering Portfolio

By

Reading tutorials is fine. Shipping something is better. If you are trying to break...

The Book of Redgate: Taking Breaks

By

We work hard at Redgate, though with a good work-life balance. One interesting observation...

Database AI Agents: The Read-Only Rule

By

Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...

Read the latest Blogs

Forums

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

Calculating the Harmonic Mean in Power BI

By Dinesh Asanka

Comments posted to this topic are about the item Calculating the Harmonic Mean in...

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