Click here to Skip to main content
13,146,710 members (65,746 online)
Rate this:
Please Sign up or sign in to vote.
See more:
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 0:26am
Updated 1-Oct-12 0:31am
Joan Murt 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
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.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.170915.1 | Last Updated 1 Oct 2012
Copyright © CodeProject, 1999-2017
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