Search results for query: *

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'...

...all select 2, 15, 10, 5, 15 union all select 3, 25, 12, 35, 18 union all select 4, 25, 20, 35, 25 union all select 5, 45, 25, 15, 30 select * from #tblTest SELECT IDENTITY(INT, 0, 1) AS RowID, s.ID, s.Price_in INTO #Bx FROM #tblTest AS s inner join UTIL_NUMS AS V...

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...

...'Intruder Alarm' union all select 9 , 9 , 0, 'Air Conditioning' union all select 22, 9 , 1 , 'Fans' union all select 23 , 9 , 2 , 'Pump' select * from (select *, row_number() over ( order by catid desc, subcatid asc)as rowid from @tbl1)b order by...

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)

Using sql2005.... SELECT a.* FROM ( SELECT customerID, OrderDate, ROW_NUMBER() OVER (PARTITION BY customerID ORDER BY OrderDate DESC) AS RecID FROM Orders ) AS a WHERE RecID = 1

WHERE adm_ts >= DATEADD(MONTH, DATEDIFF(MONTH, 31, CURRENT_TIMESTAMP), 0), AND adm_ts < DATEADD(MONTH, DATEDIFF(MONTH, 0, CURRENT_TIMESTAMP), 0)

Check the permission of the Account that ran the xp_cmdshell. I have the same problem with Delete...found out the network shared drive did not have the right permission for the the Account that ran the xp_cmdshell. thanks

This will give you what you wants: exec sp_help 'YourTableName'