-- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= ALTER Procedure GetNowShowingMovies AS select distinct(m.MovieName+' ('+m.Language+')') as MovieWithLanguage,m.* from Movies m inner join MovieTimings mt on mt.MovieID = m.MovieID and m.Active = 1 and convert(varchar,mt.Date,112) >= convert(varchar,getdate(),112) where mt.Active = 1 and convert(varchar,getdate(),112)>=convert(varchar,m.ReleaseDate,112)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)