SQL Server Stored Procedure Fix
Budget: ₹100 – ₹400 INR
In SSMS 2019 -
We have a stored procedure that display Yes/No for many fields but for SMS and WhatsApp permissions based on values in Framework.UserMenu (for non-admins) and Framework.MenuItem (for admins).
The DB has 1 for most rows, but the report is showing false or blank — we need to fix the SP’s output and ensure aliases/types match so the report displays the correct Yes/No.
and for else columns the data should show the correct output as present in db
We have a stored procedure that display Yes/No for many fields but for SMS and WhatsApp permissions based on values in Framework.UserMenu (for non-admins) and Framework.MenuItem (for admins).
The DB has 1 for most rows, but the report is showing false or blank — we need to fix the SP’s output and ensure aliases/types match so the report displays the correct Yes/No.
and for else columns the data should show the correct output as present in db