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 0:26am
Edited 1-Oct-12 0: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
Your Filters
Interested
Ignored
     
0 Shai Vashdi 480
1 Tadit Dash 305
2 Sergey Alexandrovich Kryukov 250
3 Peter Leow 190
4 OriginalGriff 163
0 Sergey Alexandrovich Kryukov 9,435
1 OriginalGriff 5,498
2 Peter Leow 4,230
3 Maciej Los 3,540
4 Abhinav S 3,353


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