The internet is full of examples of how to find gaps in date ranges but I need to create gaps in a …
6 days, 18 hours ago
By: Jeff Moden
In this, very simplified scenario, we have a table with two fields and few records:
SQL Guy 1
1 week ago
I have two SQL jobs. These jobs execute SSIS packages and then send files to e-mail.
1 week, 1 day ago
I have a simple query that returns two fields. I need to modify that query so that it only retu…
1 week, 3 days ago
By: The Dixie Flatline
I am automating a restore procedure and i'm trying to trap errors as they happen.
But I cannot trap…
2 weeks, 1 day ago
is there a function to remove html tags from a varchar string? I need to query a single table tha…
sorry, i am trying to get the actual file name accurately from the path, what i curre…
2 weeks, 3 days ago
I have a requirement where I need to identify compliance/non-compliance. The business rule is the…
I have table in SQL Server 2014. Please find the structure below:
CREATE TABLE [dbo].[ProductIMEISe…
3 weeks, 1 day ago
I have a stored procedure with the following:
SELECT physical_name FROM sys.master_files Where phys…
3 weeks, 3 days ago
We have a large log table which consists of last 10 year data. When we are running a delete…
I have data like as shown in the table.
I'm trying to get it into this format:
It seems like a pi…
3 weeks, 6 days ago
Below is query with data,which is not giving me expected output.
DECLARE @StartDate date = '03-06-…
4 weeks, 1 day ago
Has anyone tried to do this...I'm trying to select only "new customers" revenue, by defining a…
I have a SqlAgentJob calling a stored proc. that loops through a list of locations and passes the l…
1 month ago
Viewing 15 topics - 1 through 15 (of 2,848 total)
You must be logged in to create new topics.