The Voice of the DBA

Blog Post

Finding Failed Job Steps

Kendra’s query was a good starting point, and I used most of it in the first CTE shown below. This query basically looks at msdb.dbo.sysjobhistory and msdb.dbo.sysjobactivity, joining them...

2021-08-18

389 reads

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

BCA KCU DARMO Telp/Wa:0817.839.777

By R4nt4u

CSO BCA 0817839777 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur...

BCA KCU JEMBER Telp/Wa:0817.839.777

By layanan_Bca88

CSO, BCA. 0817839777 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates,...

BCA KCU INDRAPURA Telp/Wa:0817839777

By m4rt1n4

CSO BCA : 0817839777 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176

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