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