Print 'Doing pre run Checks to ensure script not already run';
Select * from Script_History where Script_Name='LaybyhqSetAllStores12052025';
if @@ROWCOUNT!=0
	BEGIN
		RAISERROR('THIS SCRIPT HAS ALREADY BEEN RUN ON THIS SERVER, CANNOT CONTINUE, PLEASE CONTACT DEV',11,1);
		RETURN;
	END
GO
IF (SELECT COUNT(0) FROM LaybyHQSet WHERE LoadedBy like '%Preven%') = 0
    BEGIN
	update LaybyHQSet set IsActiveSet = 0; 

	insert into LaybyHQSet (LoadedDate,IsActiveSet,LoadedBy)
	values (GETDATE(),1,'Preven');

	

	declare @LabySetId int;

	set @LabySetId = (select ID from LaybyHQSet where LoadedBy like '%Preven%' and IsActiveSet=1);

	if(@LabySetId != 0)
	begin
	insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (37759,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (23521,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (23645,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (23839,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (23413,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (37361,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (36303,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (36305,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (39777,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (36415,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (22963,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (36111,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (1621,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (1622,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (36109,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (36107,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (24071,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (38989,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (2290,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (2289,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (15521,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (22741,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (1913,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (15711,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (1938,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (7556,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (9337,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (23903,@LabySetId);
insert into laybyhqsetdetail(hqmasterid,Laybyhqsetid) values (4293,@LabySetId);

	end

    END
Print 'Insert into script history if everything else is cool';
	Insert into Script_History (RunDate,Script_Name) Values (CURRENT_TIMESTAMP,'LaybyhqSetAllStores12052025');
	IF @@ERROR != 0
		BEGIN
			RAISERROR ('UNABLE TO CONTINUE WITH SCRIPT', 11, 1);
			RETURN;
		END
GO