Advertisement
Guest User

Untitled

a guest
May 6th, 2016
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. CREATE PROCEDURE GetConsumers
  2. @ConsumerCode bigint = 0,
  3. @ReloadDate datetime
  4. AS
  5. BEGIN
  6. SET NOCOUNT ON;
  7. DECLARE @Consumers TABLE (id INT IDENTITY PRIMARY KEY, consumer_code BIGINT, reload_date DATETIME);
  8. INSERT INTO @Consumers (consumer_code, reload_date) VALUES
  9. (4, '2016-04-04'), (5, '2016-04-05'), (6, '2016-04-06');
  10. SELECT * FROM @Consumers WHERE reload_date >= DATEADD(dd, -10, @ReloadDate);
  11. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement