Set SQL variable with a cell value

[Arsouille]

Hi !

I need help to create a tool for my colleagues.
But I don't know if it's possible.
Can I use a Excel cell to set a MS SQL variable ?
I use a request from SQL Server database with the "Get Data" functionnality. In my request I have two variable date : start_date and end_date
For exemple here it's my SQL code :

declare @start_date datetime
declare @end_date datetime
-- Date de début --
set @start_date =
'01/04/21'
-- Date de fin --
set @end_date =
'31/03/22'

I want to set @start_date with the B1 cell and @end_date with the B2 cell.
Someone knows a solution ?

Thanks !
Thibault

 

[rpaulson]

="'set @start_date ='"& TEXT(B1,"mm/dd/yy") &"'"