Hi again

I did a test

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[waID]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[waID](

[aID] [int] NOT NULL,

[wID] [int] NOT...

No I am doing this in my private business

I do the programming maintenance is not a problem...

but I have never expiriance with binary in SQL never do this logic...

this will...

This my first choice and have JOINs

the second choice Go binary

define my logic...

website1 = 2

website2 = 4

have one column websiteIDs

if I update websiteIDs = 2

and do

select * from Ads...

Thank you very much for all responses

Yes

There is one column INDENTITY all the rest columns accept NULLS no duplicate check nothing

ONLY SIMPLE INSERT

There NO DB Error log when call...

Hi

you can check your Web page and prevent F5 , disable SUBMIT button(when submits)

Valentin

Yes SOMETIMES is Null

What is your oppinion can relly on

http://msdn.microsoft.com/en-us/library/ms175098.aspx

Failed statements and transactions can change the current identity for a table and create gaps in the identity column values....

INSERT INTO Results (companycode, GUID, ComeTime)

VALUES (@companyCode, @GUID, GETDATE())

SELECT @@IDENTITY as ID

where there is column ID autonumer identity...

Thanks for respond

The problem is we do not want to redo the store procedure because there is replication....

in this situation I can not improve the query.

But still I want to...

There is One table No trigers

But it is return Null that's mean did not success to INSERT and this is confim!!! no inserted row

Thanks

for respond