Topics
Started by
Posts
Last post
Here is a simplified sample of my data... (there are additional columns, but not relevant right now…
30 replies
I have a history table that tracks changes to client records, im having trouble writing a query tha…
7 replies
We recently moved our production databases to a new server. Since then, an SSIS package has changed…
1 replies
Hi Guys, I have an SQL Agent job. It is called an SSIS Package and is stored in SSIS DB. I can see …
7 replies
How can I make my queries below dynamic? I want to get the Max() of sfilename of all tables in my…
12 replies
Hello, i have 2 tables , the first one is a referential of the quality services and the second is a…
3 replies
We have recently changed many of our SSIS packages from using the depreciated SQL Native 11 driver …
3 replies
I've been exploring various methods to monitor and alert for long-running queries in SQL Server. …
1 replies
By: Casper101
DECLARE @var VARCHAR(2000) SET @var = 'dir ' + '\\company.sharepoint.com@SSL\DavWWWRoot\sites\Order…
3 replies
I'm failing to write a suitable rank function to label the following select resultset as seen here.…
1 replies
Hello SSC! Happy New Year and I hope everyone had a safe and healthy holiday! I have this ETL proce…
9 replies
Hello, I have a table Customers that contains the current value and another table Customers_History…
10 replies
Should I see this warning when I have ISNULL check at SUM function and changing NULLs to 0? …
4 replies
Good morning and Merry Christmas everyone! I'm not sure if anyone has posted something like this be…
2 replies
Hi, I have a table ShipperStatusHistory that tracks orders, Shipping status and relay points (for c…
7 replies
Viewing 15 topics - 1 through 15 (of 1,518 total)
You must be logged in to create new topics.