You need to identify pairs of discharges and rx (claims) for the same patient within your reporting period. Then rank them based on time difference and retain the closest. Where...

If any column has a value in the second row that is unique and identifiable you can add a conditional split to the dataflow where the unmatched output is directed...

I tried to reply, but it failed to post,  with an error "are you sure you want to do that". I think the issue is schema scope of stored procedures....

Where are you importing the package to? Another instance of msdb ? If the package is deployed  and you don't import it into Visual Studio to make changes, why would...

You can export the data as text files as long as you re-import the files to check it goes smoothly. People often find commas in csv fields or unescaped double...

Not sure about the Azure piece, we tried it about 10 years ago and I think the SSAS as a service wasn't released yet, so we installed SSAS on a...

First question, did you process full on the dimension containing the error? I don't remember if you can process updaate a partition, but I did read something about process updates...

It works fine as written on our SQL 2017 14.0.3238.1. database. If I remove the <30 filter I get the arithmetic error so it's clearly applying the filter first. Is...

If you're restoring the same database every night...

I usually restore filelistonly and copy paste the LogicalName and PhysicalName to a query window and then edit with search and replace, but I just looked for an easier way...

Your best bet is to recreate the tables(s) using the preferred data types.

The primary reason you can't alter the column is that there is not a way for SQL Server...

ALTER TABLE dbo.clanPEOPLE...

I think that ANY,  SOME and ALL have the advantage that you can use comparisons like less than or greater than. Imagine the Beer table has cost and a country...

If you have any empty strings you need to ensure they are not chosen as the shortest description.

SELECT  TeamCode, Description,
      ...

Sorry, I should have mentioned that sp_whoisactive is not a system stored procedure. It's something you can download and install, created by Adam Mechanic. It has not been updated for...