Recent content by tran008

Thank you very much...

Hi all, I'm trying to understand the code below, with (+). Comming from MS-SQL server, I never seem this before. Can some explain what the (+) does? thanks SELECT tblA.FIRST_NAME, tblA.lAST_NAME, tblA.STREET_NUMBER, btlA.CITY FROM tblA, tblB WHERE...

Not sure about the condition join, but I would do a union select field1, field2, field3 from OOMM inner join SER on comm.userid=ser.userid where comm.type='SER' union all select field1, field2, field3 from OOMM inner join EMP on comm.userid=emp.userid where comm.type='EMP'

George, Any change this could product a duplicated? :)

Put the Recovery Model to simple instead of Full.

Hi all, I need to generate a report to show all current user(s) login the Active Directory. Anyone have the script, or point me to the right direction? This is a Windows 2003 Domain server. thanks

Look up convert or cast from BOL: eg select convert(varchar, DateOfReferral,120)

select patID, txtCode into #table1 from ( select 547385 as patID, '001' as txtCode union all select 547385 , '002' union all select 547385 , '01B' union all select 547385 , '026' union all select 1094870 , '001' union all select 1094870 , '002' union all select...

SELECT O.FILEID, O.OFFICE, I.INVOICEID, (CASE WHEN I.STATUS = 'closed' THEN 'Invoie Finalized' ELSE 'Invoice Not Finalized' END) INVOICESTATUS FROM ORDERS O LEFT JOIN INVOICE I ON O.FIELID = I.FILEID WHERE O.STATUS = 'closed'...

Base on the code below, this is how I came up with the result, however this involve with temp table...which taking a bit to return the resolved. Anyone have any other suggestions on how to do this. thanks --table UTIL_NUMS is a number base from 1 to 5,000,000 select 1 id,150000 as qty_in...

I have the following in the table: id QTY_IN Price_IN QTY_Out Price_out 1 150000 10.01 150000 10.01 2 15 10 5 15 3 25 12 35 18 4 25 20 35 25 5 45...

SQL2005: declare @tbl1 table(ID int, CatID int, SubCatID int, Description varchar(35)) insert into @tbl1(id, catid,subcatid, description) select 7, 7 , 0, 'Sprinklers' union all select 8, 8 , 0 , 'Intruder Alarm' union all select 9 , 9 , 0...

search for Pivot or have a look at this thread http://www.tek-tips.com/viewthread.cfm?qid=1479412&page=6

Select Name From master.dbo.SysDatabases

something like this? select dateadd(month,datediff(month,0,datefield),0) as [month], count(groupmember) as [Auth Count] from table group by groupmember, dateadd(month,datediff(month,0,datefield),0) order by dateadd(month,datediff(month,0,datefield),0)