As you said, have you tried wrapping all the process in a transaction? I think, that is the usual and best way to utilize the maximum availability...

I beleive your Web application was developed in .NET and .NET framework has class libraries to acheive this functionality.

Convert it from FRONTEND and send the actual value to your DB.

Further...

Try selecting approximately 1000 from rows from other table (if you have any) and then do .../

INSERT INTO TESTTABLE(Col1)

SELECT Tcol1 FROM OTHER TABLE WHERE .....

If you need this for any...

Why not you can try with a job, which can capture the last modified date on the table and to to send emails?

You need to provide more details on the table details for creating index.

There are several ways to do acheive the same...

Here is the simple/basic query which strikes to my mind immediately

SELECT A.ClaimKey,

CASE WHEN A.MinClaim > B.MinClaim THEN 'Y' ELSE 'N' END AS...

I like the way Jeff determined to identify the issue 🙂

No you can't

Hi Achtro,

Is this is the query you are looking for? If so, in the same query you can filter using HAVING clause to identify the columns which is having more...

Thanks John!

Hi Linda,

There are many ways to acheive the same and mentioned below is the basic query which satisfies your logic..

You can also use other function which optimizes your query output...

Wrong syntax.....

You need to use both the columns seperately in the WHERE clause

Like this..

WHERE COL1 IN (SELECT COL1 FROM.....)

AND COL2 IN(SELECT COL2 FROM........)

How it's possible to have more than one unique constraint on the same column? Obvoiusly, you should get an error, if I understand your question right....

Could you please provide your...

Literally speaking,

a) "Select *" will return the result set , whereas "Count(*)/Count(1)" will return a scalar value and this will result in significance difference in terms of I/O

b) ...

Shadhab,

The one which you tried joining schema_id, is must in case, if you have the same table name in different schema's with same/different data types

SCENARIO EXPLAINED

a) Suppose you have created...