prompting for values when opening a view

• brinkhof hans-308359

  SSC Journeyman

  Points: 79

  More actions

  March 8, 2006 at 4:07 am

  #168611

  I 'm working on a view, which has to sort the data from certain periods..

  => only data that is found for the period starting on DateA and ending on DateB                                        is there a function in SQL Server that makes this possible? 

  for instance, the original DBase we've been working with, is in MS Acces and solves it like this:           Between [DateA] And [DateB]

  at the opening of the query, you get two prompts that ask for these dates, so the sql code can use it later on.

• Vasc

  SSCarpal Tunnel

  Points: 4643

  More actions

  March 8, 2006 at 3:07 pm

  #625539

  Stored Procedures might help you : )

  SQL Server <> Access

   

   

  ---

  Kindest Regards,

  Vasc

• alexia-294642

  SSChasing Mays

  Points: 600

  More actions

  March 10, 2006 at 12:52 am

  #625857

  You should use stored procedure

  for example:

  create procedure getData

  (@dateBegin datetime,@dateEnd datetime)

  as

  begin

  select name,address,birthdaydate from tblX

   where birthdaydate between @dateBegin  and @dateEnd

   

  end

   

  execute getData '1980-01-01','1981-01-01')