cgyrob

unless I am missing something in your table structure or what you are trying to achieve I think the following is more of what you are looking for. [code=SQL] Select d.pointerField, Case When clm_dateQualifier = 439 Then Case When isdate(CLM_StartDate) = 1 Then CLM_StartDate Else ' ' END END AS …

Link82 Group by does exactly that; groups your result set by the fields provided, in the example provided by sknake. [icode] GROUP BY tblManagers.managerID, tblManagers.managerLastName, tblManagers.managerFirstName [/icode] This will give you the number of rows selected grouped by Managers Id, Last Name, First Name so you get results like the …

I would do something like the following. This will give you all the records for the users that have any of the 3 AOI and with removing the left join you will not retrieve all the null returns. You can also make the join to the AOI table if you …

Try something like [code=SQL] Select Top 1 from Project order by date desc [/code]

There are a few ways to do this. 1. When you choose your connection and the report wizard runs you can pick your table, then it will ask you which fields you want to include from those tables. 2. When you create your connection choose add command, here you can …

Its an easy search [url]http://msdn.microsoft.com/en-us/library/ms181765.aspx[/url]

Not sure what you are asking. This statement will most likely return an error. (Multiple values returned when expecting single value) To make it work you will either have to use an "in" instead of "=" for your sub query or use a where clause within your sub to limit …

Query optimization is the process of optimizing the performance of a query to utilize as little system resources as possible.

[url]http://www.samspublishing.com/library/library.asp?b=STY_Csharp_24hours[/url]

You should have a seperate table which holds your costs and is referenced to the item table. Items -------- id item_name Desc etc. costs ---------- id items_id Costs effective_date expiry_date When you need to update a cost you set the expiry_date for the current record and insert a new record …