Can you please post how do you want to see the output data with an example so that it would be easy to understand what you are looking for.

Thanks

Check this hotfix if it helps

http://support.microsoft.com/kb/912439

Thanks

I feel the forum caters enough for SQL Server 2000 and SQL Server 2005. Whenever a product has a upgraded version released and people start using it, they come across...

TRY.....CATCH exception handling is something that is introduced in SQL Server 2005 to introduce a new paradigm of Error Handling in SQL. However it is a proven and familiar methodology...

Hi Gary,

Please post your SQL Query so that we can suggest you the solution.

I assumed so that it could be a VARCHAR, makes sense to change the datatype to desired format unless you really forsee a condition where it has potential need to...

Select <FieldName>

FROM

<TableName>

ORDER BY

<FieldName> ASC

Use this query to fetch only the data where employee has more than one address. You can also use derived tables.

SELECT *

FROM

   mst_ServiceUser as Users

INNER JOIN

  mst_Address as...

Well using cursors are least recommended unless otherwise there is no other way to fulfil your requirement. UDF would have been handy if Danial had no limitation with respect to...

For your requirement, it makes more sense to use a User Defined Function.

I have not tested this and please ignore if doesnot yeild the desired results.

SELECT  users.Uname,

 users.UnameFirst,

 users.UnameLast,

 ROUND(SUM(workcompleted.WCmileage), 2)/(COUNT( WXlinkItemID)) AS totMileage,

 ROUND(SUM(workexpense.WXamount), 2) as totExpenses

FROM

 workrequest,

 worktask,

 users,

 workcompleted

LEFT OUTER...

You can set the Hidden property to False using expressions and checking the AddressID. But its better to handle this in your stored procedure or query. Post your Query or...

DECLARE @Date DATETIME

SET @date = (SELECT GETDATE())

SELECT 'Yes ' + CONVERT(VARCHAR(10),@date,101) + ' '  + CONVERT(VARCHAR(10),@date,108)

It can also be termed as Master and Child records residing on the Same table. One LeaID can be referenced by Multiple PriorLeaseIDs .

AS Posted by Micheal, you are not clear on what you want to know. However from your post LeaID is your Primary Key of Lease table and PriorLeaseID is a...