SQL
Database
2
Posts
2
Posters
0
Views
1
Watching
-
i need solution for this question. the question is given below : Print the information of invoice table in the following format for all records – The Invoice No. of Customer Id. {cust_id} is {inv_no} and Movie No. is {mv_no)
SELECT 'The Invoice No. of Customer Id. ' + Cast(cust_id AS Varchar(100)) + ' is ' + Cast(inv_no AS Varchar(100)) + ' and Movie No. is ' + Cast(mv_no AS Varchar(100)) FROM TableA Assuming all the three columns are are numeric (Cust_id, Inv_no, mv_no
Regards KP