|
|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
The Dynamic Data Masking Email Function | |
If I add the email function to a column like this:
ALTER COLUMN Email ADD MASKED WITH (FUNCTION = 'email()')If I have an email of "adam.smith@capitalism.org", what is returned by the masking function for users that do not have the UNMASK permission? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
System Variables in ADF How do I access a system variable, say the Pipeline variable, in Azure Data Factory (ADF)? Answer: @pipeline().Pipeline Explanation: The @pipeline() prefix is used with variables, separated by a period. Ref: System Variables - https://docs.microsoft.com/en-us/azure/data-factory/control-flow-system-variables |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Development |
Calculate HR - Please assist me? I would like to calculate:my code: SELECT * from [dbo]. where LeaveTypeName Not In ('paid time off') BETWEEN date(DateApprovedSupervisor) AND date(2001-08-01) Number of team members who have not used a PTO in the last 30, 60, 90 days (include % per 30-day period) - Number of team members who used more than […] |
Extract/export embedded files from binary in SQL 2017 Standard - Hi Everyone ! If I run SELECT * FROM [QPulse5Training].[dbo].[RevisionAttachmentItem] I get a generated list of 218 records with a small number of NULL in mixed formats, including PDF, Word, Excel and image files. If I run the following (taken from this web page https://www.c-sharpcorner.com/blogs/export-blobbinary-or-varbinary-from-sql-table-and-save-it-as-a-file - credit where it is due), I get 102 documents […] |
Distinct Count - I am using the following code for distinct count, seem to give me the same number for count and distinct count. Please assist? Attached is the file i imported into sql server. |
SQL Server 2016 - Development and T-SQL |
Error handling/notification with a sql agent job - I have a stored procedure that is returning a set of data from a table and then is populating a summary table with that data. if sussful I am deleting all the data from the first table. if there is an error I do not want to delete the data and notify me if it […] |
SQL 2012 - General |
How to use group by instead of distinct when execute dynamic SQL query @SQL ? - I work on SQL server 2012 i need to use group by instead of distinct so how to do that please query working without any problem and give me result i need but I need to use group by instead of distinct on last statement executed in exec @SQL and if there are advice about […] |
what i do to enhance this statement select into ? - I Work on sql server i have slow transfer data when make select into small number of rows it take too much time my execution plan https://www.brentozar.com/pastetheplan/?id=r1o3p8NOt my query as below : SELECT d.PartID , d.Code , d.CodeTypeID , tr.RevisionID , tr.ZPLID, tr.partlevel, d.FeatureName, d.FeatureValue INTO ExtractReports.dbo.TEqualCodes from ExtractReports.dbo.TAllData d with(nolock) inner join parts.tradecodes tr […] |
SQL Server 2012 - T-SQL |
problem with UNION ALL query - I have a query that uses 'union all' and returns all the records (including the field 'BillingRateA') from the top query but not the 'BillingRateB' bottom (that field is just blank). If I run the bottom part alone 'BillingRateB' appears. Any clues?: SELECT c.clientname as 'Client', c.BillingRateA as 'Rate', b.billingtypeA as 'Unit', m.SegmentName as 'Business […] |
SQL Server 2019 - Administration |
Copying database backups to two different locations in Standard Edition - I have a need to write to two different Azure Blob Storage Folders for backups. I know that Mirror To Option is not possible since I'm in standard edition. I don't know if there is a workaround, short of writing to disk and then copying the backups to Azure Blob Storage Folders. Not sure I […] |
SQL Server 2019 - Development |
Replace text in a string but only if it falls between double-quotes - Hi Guys, It's Friday afternoon and my brain hurts.... TLDR: Given the string: strStmt = "SELECT * FROM " & strView & " WHERE MainLKUPID = #REM " & strAccounts(lngCount) & "#REM " #REM This is a comment How would you replace the #REM with single quotes so that you end up with a string […] |
multiple queries - Hello. Is there anyway i can simplify the writing of this queries where the only thing that changes is the date on the three tables and the "datepart" on second table and third table? --table 1-- Create table Report_Es1 (ola1 int) declare @h int set @h = (select Sum(case when [DATA] = CAST(GETDATE() AS DATE) […] |
SQL Server 2008 Administration |
one job most of time runs successfully, but somtimes failed - My OS is Windows server 2008 R2 enterprise, and SQL Server is 2008 R2 standard edition, I created more than half year, It ran without any error before this week, but it failed to run sometime since this week. even if I start SQL Server Agent service using NT SERVICE\MSSQLSERVER or NT SERVICE\SQLSERVERAGENT account, the […] |
General Cloud Computing Questions |
What's your opinion about Google Cloud SQL? - I wonder what your opinion about Google Cloud SQL is! We are a small company running our MySQL server on one of our vServer and everything runs fine. But we have a few concerns about our project in the future: Backups - we did not implement them yet and I don't want to keep them […] |
Reporting Services |
Report Viewer Paging Problem - Hiya, I'm using PowerBI on Premise Report Server and Visual Studio 2019. In development I can create reports that preview fine on separate pages. When they are promoted to live, the Report Viewer gets stuck on 0 pages and I cannot navigate them. After a while (several minutes) the Report Viewer sometimes comes to life […] |
Is it possible to assign a random color to a font? - Hello, I am working on a report for which one of its requirements is that at the beginning of each year, the font color in one of its sections changes automatically. I am not sure if this is possible, I have search, found and read a few examples and they all have the colors to […] |
General |
Recommendations for making a custom image and video filter. - For my CSCI class we made some custom filters in C++ using the stb_image library. I made a filter that doubled the individual RGB values of each pixel, which resulted in a cool/glitched out output image. I wanted to apply this filter to a video, but I don't believe the stb library supports that. Any […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |