BIDS Report Not Showing Latest Data

• gboehm

  Say Hey Kid

  Points: 695

  More actions

  January 11, 2008 at 10:13 am

  #185518

  When I run a query on BIDS, I see data, but it is old data, ID 1 to 52. When I run the same query on SQL Server Management Studio Express on the same table, I get the latest data, ID 1 to 138.

  The query is:

  SELECT * FROM FILENAME

  What am I doing wrong?

  Thanks,

  Gary

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  January 11, 2008 at 11:04 am

  #767250

  Is BIDS paging the data?

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• gboehm

  Say Hey Kid

  Points: 695

  More actions

  January 11, 2008 at 11:34 am

  #767263

  Ok, so I have agg on my face.

  Isn't the first time.

  Everything is fine,

  Thanks!

  Gary