Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Windows
select g.Enquiryfor,a.CustomerName, b.SiteName, c.TowerName,  e.Floor,d.FlatsName, f.Area_Sqft, e.CreatedDate as BookedDate,e.SiteID,e.TowerID, e.FlatID, a.CustomerId,f.BookingID, e.EnquiryId  from AdvitPM_Customer a,AdvitPM_SiteMaster b, AdvitPM_TowerMaster c, AdvitPM_FlatsMaster d,  AdvitPM_Booking e, AdvitPM_BokkingDetails f, AdvitPM_Enquiry g where e.CustomerID = a.CustomerID and e.SiteID = b.SiteID and e.TowerID = c.TowerID and e.FlatID =d.FlatID and e.Status ='True' and e.BookingStatus = 'Enquired' and e.Booking_Id = f.BookingID and g.EnqId = e.EnquiryId and e.CreatedDate >= #" + objBo.FromDate + "# and e.CreatedDate <= #" + objBo.ToDate + "#
 
this is my query and i am not getting the data?y..plse
Posted 1-Oct-12 1:26am
Edited 1-Oct-12 1:31am
v2
Comments
Joan Murt at 1-Oct-12 6:58am
   
Hello Raju, you should definitely read the posting guidelines.
 
Throwing a code dump here will end always in tears.
What does it means that you are not getting the data?
Is it giving you any kind of error?
Is it giving you a partial data set?
Which database are you using and which software are you using?
...

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Copy and paste this query in SQL Server management studio and check if you can get any results.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 545
1 Kornfeld Eliyahu Peter 407
2 Maciej Los 369
3 DamithSL 221
4 OriginalGriff 218
0 OriginalGriff 6,383
1 DamithSL 4,879
2 Maciej Los 4,476
3 Kornfeld Eliyahu Peter 4,056
4 Sergey Alexandrovich Kryukov 3,927


Advertise | Privacy | Mobile
Web02 | 2.8.141223.1 | Last Updated 1 Oct 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100