Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!

1 Answers  

---

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

---

What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,

---

How do I setup a sql server database?

0 Answers  

---

Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  

---

can primery key be a non clustered index?

10 Answers  

---

What do you know about system database? : SQL Server Architecture

0 Answers  

---

What is the difference between implicit and explicit transaction?

0 Answers  

---

what are the limitations of parameters in a storedprocedure

1 Answers  

---

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 Answers  

---

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

0 Answers  

---