I have this SQL query that runs perfect. I now would like to automate it as a stored procedure that emails the results in an Excel spreadsheet. Any pointer? Thanks for any help you can provide.
Here is the query:
select SiteID,
case
when SiteID = '001' then 'Omaha Terminal'
else 'Geneva Terminal'
end as 'Site Name'
,rtrim([TransNum])+replicate(' ',5-len(TransNum)) [Transaction Num]
,rtrim([Date])+replicate(' ',20-len(Date)) [Transaction Date]
,rtrim([Time])+replicate(' ',20-len(Time)) [Time]
,rtrim([Card1])+replicate(' ',20-len(Card1)) [Card]
,rtrim(c.[Name])+replicate(' ',20-len(c.Name)) [Name]
,rtrim(t.[UserEntry2])+replicate(' ',10-len(t.UserEntry2)) [Tractor]
,rtrim(t.[UserEntry3])+replicate(' ',10-len(t.UserEntry3)) [Odometer]
,rtrim([Qty])+replicate(' ',5-len(Qty)) [Quantity]
from Transactions t
left join Card c
on t.Card1 = c.CardNumber
where t.Date between '07-19-2021' and '07-20-2021'
order by [Transaction Date] desc
