Hi all, I need some help regarding SQL query. I have the following requirement: I have 3 tables(in bold) with columns as following: Unit UnitId ListUnit UnitId,ListId List ListId And I have the records as following in the above mentioned tables: Unit 1 2 3 ListUnit 1,1 1,3 2,1 2,2 3,2 3,1 List 1 2 3 Now I want to retrieve only top 1st (UnitId,ListId) from the group I.e. 1,2 from (1,2 1,1 1,3) group. Then 2,1 from (2,1 2,2) group. And 3,2 from (3,2 3,1) group. So how could I write SQL Query for this? Thanks, Rachit Damani.

I have created an Windows.NET app in C#. with crystal reports. These all run fine on my development computer. I modified my setup project to include all the merge modules that CR.NET needs, added the licence key info. and rebuilt the solution. still everything works fine when I run the installation. both on Development computer as well as on Client computer. later i added an installer class to add the Database path to a config file during installation I successfully installed the app. on my development computer. but when I try to run it on Client system, I receive the following error: Unable to get installer types in the \app.exe assembly --> one or more of the types in the assembly unable to load. it seems to be something related to crystal reports. I am using .NET Studio 2005 and app is on c# with few crystal Reports. Now if i copy and paste the bin/debug directory from the development system to my client system, it gives the following error when trying to run crystal report module: File or assembly name CrystalDecision.Windows.Forms, or one of its dependencies, was not found help appreciated. thanks in advance. Rachit Damani.

Hi All, I need to deallocate normal variable that has been declared in Stored Procedure in SQL Server. So how i could achieve this? Thanks in advance, Rachit Damani.

ya thanks, now i have understood what i need to do thanks a lot Rachit Damani.

Thanks for your reply but how i could use select query in dataview? i don't need to select top N rows when i am fetching the data from the database but at some point of time i need to select top N rows from dataview which contains all the data. so is it possible to use select query in dataview? Thanks, Rachit Damani.

HI All, I have a requirement where I need to select first N rows from DataView. So how could i achieve this? Thanks, Rachit Damani.

Thnx buddy, it is working fine.

Thanks buddy, it is working fine.

Hi All, I need to display time in the following format in c#: 7:40a (not AM/PM whole word just A/P in lowercase) So how could I achieve this?

Hi All, I need to display time in the following format: 7:40a (not AM/PM whole word just A/P in lowercase) So how could I achieve this?

That first link doesn't seem to help because i tried those things so many times but that second link which is in french seem to be very useful so please help me transalting it. Thanks, Rachit Damani.

Hi all, I am developing one web page called Whiteboard where i need to assign jobs to the employees by dragging and dropping employees to the particular job using AJAX. Everything(Jobs and Employees) will be fetched from the database. So i need to fetch each and every employee from the database and make it draggable and droppable so that i could drag and drop particular employee to the particular job. So please reply to this post and let me know how could i achieve this in ASP.NET with the use of AJAX? Thanks in advance.

hi all, I want to query Microsoft Active Directory (Windows Server 2003) from SQL Server. Active Directory data have been stored on remote computer and i want to retrieve those data in SQL Server on local computer. So how could i achieve this?

I need help regarding ASP Calendar control. I am developing one web page in which I am displaying a calendar (month view) using ASP Calendar control. And I am displaying jobs on particular day. i.e. if job starts on March 1 then I will have to display that job on March 1 cell and so on. Now what I need to do is to display a bar in the calendar as per the start date and end date of the particular job. i.e. if job starts on March 1 and ends on March 5 then I will have to display a bar starting from March 1 to March 5 and that particular job number on this bar just like Google Calendar. When we create an event in Google Calendar from one date to another date, you will get to see one bar displaying from one date to another date.