You can use this query too...

SELECT

COUNT (DISTINCT ACCOUNT)

FROM dxhistory

WHERE RANK=1

GROUP BY ACCOUNT, RANK

HAVING COUNT(RANK)>1

UPDATE TABLE1

SET TABLE1.FIELD1 = TABLE1.FIELD1 + TABLE2.FIELD2A

FROM TABLE1

INNER JOIN TABLE2

ON TABLE1.FIELD2 = TABLE2.FIELD2b

Try this

insert into empcheck1

select * from emp

where emp.empid not in(select empid from empcheck1)

declare @i as numeric(18,0)

declare @sql as varchar(8000)

set @i =4

set @sql ='select top ' + convert(varchar,@i) + ' * from dbo.tbl_ls_feed_data'

exec(@sql)

SELECT 'Total'

,(SELECT SUM(totalprocessed)

FROM vw_total_numbers_0

WHERE RIGHT(trust,4) = 'goal') AS 'Total Goal'

,(SELECT SUM(totalprocessed)

FROM vw_total_numbers_0

WHERE RIGHT(trust,4) <> 'goal') AS 'Actual'

Execute dynamic SQL statement using sp_executesql system stored procedure, if you want a output to a variable. It allows input parameters as well as output parameters.

DECLARE @cmd NVARCHAR(100)

DECLARE @parm NVARCHAR(100)

DECLARE...

Try this,

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=505&lngWId=5

Functionally, TOP and SET ROWCOUNT do the same thing. However, SET ROWCOUNT will affect any subsequent queries in a connection. To remove the row count option, use SET ROWCOUNT 0....

Try this,

DBCC CHECKIDENT('MyCustomers', RESEED, 200)

You may do this way,

[font="Courier New"]DECLARE @cmd varchar(100)

DECLARE @fldname varchar(50)

DECLARE @number int

SET @fldname = 'ContactName'

CREATE TABLE #number (RecordCount INT)

SELECT @cmd = 'INSERT INTO #number SELECT COUNT(*) FROM CONTACT2 WHERE '...

SQL compiler doesn't return any error message, if the table doesn't exist. Check this,

[font="Courier New"]if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SomeThing]')

and OBJECTPROPERTY(id, N'IsUserTable') = 1)

select test...

Try this,

[font="Courier New"]DECLARE @ID AS CHAR(2)

DECLARE @Name VARCHAR(10)

DECLARE @Region VARCHAR(10)

SET @ID = 'OH'

SET @Name = 'OHIO'

SET @Region = 'MIDWEST'

IF EXISTS(SELECT * FROM States WHERE [ID]=@ID)

BEGIN

INSERT INTO error_log VALUES(@ID + '...

You can't execute a store procedure inside the function!

Save the time in DATETIME data type in you database. When you retrieve you may convert it to the format you mentioned.

[font="Courier New"]DECLARE @date DATETIME

DECLARE @time CHAR(5)

SET @time = '07:45'

SET...

p21_view_invoice_hdr.invoice_date < DATEADD(dd,-90,GETDATE())