In what way is it unsuccessful? Is it empty? or does it fail?

At what level is your event handler? if it is at the package level, rather than at the...

Is there a user variable for the server name in the variable mapping tab of the for each loop container? If so you should be able to include it in...

I think Item #8 in this article might help.

https://www.codemag.com/article/1308091/The-Baker%E2%80%99s-Dozen-13-Differences-Between-Analysis-Services-OLAP-and-Tabular

As it is in the 2022 forum there's always GENERATE_SERIES to come up with the Month numbers in the query. Assuming CustomerCode is not unique in the source table. I...

The second column is coming from a derived table. You could write a loop or use...

Does this work?

SELECT  a.CustomerCode,
        b.MonthNum
FROM    dbo.Customers AS A
CROSS JOIN  (VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12)) AS b (MonthNum)

second page

Looking at your first stored procedure you might be able to get what you need by selecting the top 1 row where employee_id = @employee_id and payroll_detail_id < @payroll_detail_id. If...

I'm not sure which table you need to validate or whether an id can have multiple Field values. One solution might be to create a map table (this assumes table...

Is this different from nested joins that allow an inner join to the right of a left outer? I recently came across this technique and was shocked that I had...

Are you running a select query that returns millions of rows to your screen so you can look at them? if so, chances are that your pc is storing the...

I cannot find the article referenced: "Writing SQL Server code with AI using GitHub Copilot" that is supposed to discuss how to install CoPilot. After installing per GitHub general...

Put the zeros in quotes.

SELECT RIGHT('00000' + convert(varchar(5), CustID), 5) from my table

I thought CONCAT might work without quotes but it appears to convert 00000 to 0...

What purpose is the identity column serving? Is it just there to be there? If so it is just adding overhead needlessly.

Ideally, move the clustered index to the identity...

Have you looked at the Display Folder property of...