I have the following stored procedure:
GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[TW_spRPTAllReceiverInventory] @SiteId varchar(50), @ReceiverId int, @UserName varchar(50) AS BEGIN DECLARE @SQL varchar(8000), @Index int, @Value varchar(500), @Source varchar(100), @tmp DATETIME SELECT @Index = CHARINDEX('Initial Catalog=', ConnectionString) + 16, @Value = ConnectionString FROM CustomerSetting WHERE SiteId = @SiteId SET @Source = '[' + SUBSTRING(@Value , @Index, CHARINDEX(';', @Value, @Index) - @Index) + ']' SET @SQL = 'SELECT R.SiteId, L.* FROM ' + @Source + '.[dbo].[vwReceiver] R JOIN ' + @Source + '.[dbo].[vwInventory] L ON R.ReceiverId = L.ReceiverId WHERE R.ReceiverId = ' + CAST(@ReceiverId as varchar) + ' AND L.ModifiedUserName = ' + Cast(@UserName as varchar) EXEC(@SQL) END
What I need to do is filter the results based on one of the columns (the column is
ModifiedDate, which is a DateTime column) to only show records created today.
- How do I accomplish this?
✓ Extra quality
ExtraProxies brings the best proxy quality for you with our private and reliable proxies
✓ Extra anonymity
Top level of anonymity and 100% safe proxies – this is what you get with every proxy package
✓ Extra speed
1,ooo mb/s proxy servers speed – we are way better than others – just enjoy our proxies!
USA proxy location
We offer premium quality USA private proxies – the most essential proxies you can ever want from USA
99,9% servers uptime
No usage restrictions
Perfect for SEO
We are working 24/7 to bring the best proxy experience for you – we are glad to help and assist you!