Hi there,I'm new to both the forum and the world of SQL programming, so please bear with me.I am currently using Sybase to pull information from a few tables and collate them into one table which I can then export. I can get the data to display but the data in the end column (LogoutDt) is full of duplicates of that days date.I would like any duplicate dates in that column to display Null. eg:LogoutDt01/01/2012(null)(null)(null)02/01/2012(null)I have looked online for this, however can't find anything that has been able to help me. I am unsure if this can even be done. Also, I do not have full access to this database (read only) if that makes any difference; here is the code I have so far:SELECT DISTINCT dbo.AgentIdleDetail.User_Id, IdleStartDt, IdleEndDt, dbo.AgentLoginLogout.LoginDt, LogoutDtFROM dbo.AgentIdleDetail, dbo.AgentLoginLogoutWHERE dbo.AgentIdleDetail.User_Id = dbo.AgentLoginLogout.User_Id
Help with duplicate values
Posted - 2012-01-06 : 11:18:38
