Hi,

Your queries to locate the duplicate records in the table,

Ref: http://support.microsoft.com/kb/139444

And the articles by the chris cubley

http://www.sqlservercentral.com/articles/Miscellaneous/findinganddeletingduplicatedata/1075/

More safe is making a return statement with desired messages in the SP,then only the users/sa/dba understand the causes.

ALTER PROCEDURE DBO.MYPROCEDURE

--

--

--

as

begin

begin

raiserror ('your message why its blocked to execute, any specific...

[quote-0Is there a way to find out which program did that using Trigger?[/quote-0]

Add the columns of the following in the main table to avoid the trigger for this particular case,

1)user...

The PURGEWINAUDIT is enough to maintain the x days records,

And to find out the duplicate rows, use this

SELECT ItemValue1, DateTimeDB, AuditID

FROM dbo.WinAudi2

WHERE (ItemName = 'Computer Name')

group by ItemValue1, DateTimeDB, AuditID

having...

Hi,

Post your...

Apply this option with reference of the BOL.

http://technet.microsoft.com/en-us/library/ms188774.aspx

SET ROWCOUNT 10

SELECT * FROM MYTABLE

Hi,

There is no document and undocument procedures available to direct get this result,

you should work lot of scquecne to arrive this result,

Do first with to identify of the result procedure...

select * from #Temp1

where [Key] = 0

Hi,

Second time this query posted,

Dastagiri, mention your problem in

http://www.sqlservercentral.com/Forums/Topic787173-338-1.aspx

So that, will understand your issue better.

Hi,

try this

Declare @RESULT datetime

set @RESULT = getdate()

--

select (cast(day(@RESULT) as varchar)+

(case when (right(day(@RESULT),1) >= 4)

or(right(day(@RESULT),1)= 0)

or((left(day(@RESULT),1) = 1)and len(day(@RESULT))= 2) then 'th'

when right(day(@RESULT),1) = 1 then 'st'

when right(day(@RESULT),1) =...

Hi,

Repeated post, discussion already started,

http://www.sqlservercentral.com/Forums/Topic787173-338-1.aspx

create table #product

(

Title varchar(2),

priid int,

status int

)

insert into #product

select 'A',1,1

union all

select 'A',2,1

union all

select 'A',3,1

union all

select 'A',1,2

union all

select 'A',2,2

union all

select 'A',3,2

union all

select 'A',1,3

union all

select 'A',2,3

union all

select 'A',3,3

union all

select 'A',1,4

union all

select 'A',2,4

union all

select...

Hi,

Refer the Gail shaw remarks,

http://www.sqlservercentral.com/Forums/Topic706167-65-1.aspx

hi,

Try this

select min(id),sum(productsales),

min(CAST(STR(MONTH(saledate))+'/'+STR(01)+'/'+STR(YEAR(saledate)) AS DateTime))

from MYTABLE

group by month(saledate),Year(saledate)