I'm trying to simulate price changes of some of my ingredients over time. (Not really necessary to change the prices of more than just some of the most commonly used...

Thanks Steve! Like I said, I felt like I was missing something that should have been blatantly obvious! Thanks for clarifying!

So this is my plan (after staring at this for...

Why not just script out all the objects and then run all that in a separate database?

Otherwise, you could make a copy of your database and then use dynamic SQL...

Apparently Imke Feldmann wrote some code that does it... but by the looks of it, you have to configure everything just right:

Export data from Power BI using Python

"Re-search. It...

So essentially you're grouping islands together. (The island consists of consecutive months of data). Fancy that! I found an old Dwain Camps article! (I miss his posts... he could...

Pretend I'm dumb as a rock and explain how your result is correct and how you got there.

Are you talking about something like the "Islands Question" discussed by Itzik Ben-Gan...

• This reply was modified 3 months ago by  pietlinden. Reason: clarification

Where's the data coming from?

I'm basically terrible at SSIS (but Phil's good at it, so listen to him), but you can pivot data in Excel using PowerQuery and then you...

How to remove quote marks using SSIS and a little C# – SQLServerCentral ?

Got some details? Like the parameter values you're trying to pass, the parameter definition, the stored procedure text, the related column types and sizes... you know, something so we can...

Setup:

USE tempdb;
GO

drop table if exists #procvalues;
drop table if exists #deptvalues;

create table #Procvalues
(
PatID varchar(10)
,AcctID varchar(10)
,ProcDate date
);

create table #Deptvalues (
PatID varchar(10)
,DeptDate date
,Department varchar(10)
);
GO

Insert into #Procvalues
values
('1','28304','2021-01-21')
,('2','34893','2021-01-17')
,('2','33845','2021-01-19')
,('3','39483','2021-01-13')
,('4','39056','2021-01-25')
,('5','29112','2021-01-09');

Insert into #Deptvalues
values
('1','2021-01-21', 'Dept1')
,('2','2021-01-15', 'Dept3')
,('2','2021-01-18',...

Normally you use report parameters, kinda like you do in Abscess. Normally, you just include the parameters in your stored procedure...

CREATE PROC ReportSP 
    @StartDate DATE, 
 ...

Failed to find real location of C:\Program Files\Python310\python.exe

What's the path to the Python executable on your computer?

one way is to use a Calendar table (which could be overkill) so you know which weeks go together.

DATEPART(week,[date Column])

will give you the week of the year,...

Johan,

Sorry for taking forever to get back to you, but I get it. It was pretty much what I expected. I need to use a cursor to loop over the...

I think I understand what I did wrong.

Between Purchases and Usage is maybe an "allocation" table, where I allocate one or more "blocks" of ingredient to each "BakeEvent" (just another...