read data from fields between 2 dates?

• mick burden

  SSCarpal Tunnel

  Points: 4432

  More actions

  August 22, 2006 at 9:25 am

  #191955

  Hi, I'm trying to duplicate the following code from a SP but using Dynamic SQL

  select [JOHN BROWN] from [resource] where  [date] BETWEEN @sDate1 AND @sDate2

  What I've got so far is :

  SET @CMD = 'SELECT @Rtn = [' + @ColName + '] from [Resource]' + ' where [date] between ''' + @sDate1 + ''' + and + ''' @sDate2 + ''''

  exec sp_executesql @CMD,N'@Rtn varchar (200) out',@Status out

  but I can't seem to get the correct syntax, can anyone help please. I also need it to return a record set

• Rohit @ SQL

  SSC Eights!

  Points: 938

  More actions

  August 22, 2006 at 10:23 am

  #656157

  try this one

  SET @CMD = 'SELECT [' + @ColName + '] from [Resource]' + ' where [date] between ''' + @sDate1 + ''' + and + ''' @sDate2 + ''''

  exec sp_executesql @CMD

  
  Rohit

• mick burden

  SSCarpal Tunnel

  Points: 4432

  More actions

  August 23, 2006 at 5:11 am

  #656316

  many thanks Rohit, that works great