Selectcount(Bug_Table.ixBug) as Case_Count,

Bug_Table.ixProject as BTixP

from Bug Bug_Table

INNER JOIN Project Project_Table

on Bug_Table.ixProject = Project_Table.ixProject

INNER JOIN Status Status_Table

on Bug_Table.ixStatus = Status_Table.ixStatus

WHERE Bug_Table.fOpen = 1 AND

Bug_Table.ixFixFor = 23

Group by Bug_Table.ixProject

-- I am...

Well I actually want to retrieve data from Bug Table, based on the Id's retrieved from Project and another table.

The Problem is that there is one-to-many relationship of the Project...

I would like to know, whether there is a way to schedule a task whether we can create a script of the transactions that have been done over the day...

Quite a good point identified, that I was not focusing on all. by the way QUOTED_IDENTIFIED settings -> can you please guide me through that.

Well I am using Won't Fix in the where clause, can you please guide my what should be done in that case.

Thanks you gentlemen for your help - I have finally connected to SQL Server via DOS and you were right the problem was the Domain, everything else was right.

The error that comes from while connecting is as follows:

Login failed for user 'admin'. Reason: Not associated with a trusted SQL Server connection

------------

Robert Davis: Well I cannot switch from SQL...