They're not impossible to write in T-SQL, just difficult, because T-SQL doesn't provide the variety of operators provided by a full-blown programming language. For example, hashing and encryption algorithms often...

Regardless of how the cheque number is entered into the system, whether by GUI or by auto-generation, maintaining a single table of cheques allows you to insure uniqueness of cheque...

quote:

---

Andy I agree with you, but am providing the standard warning. I've been burned on NICs with the...

Agreed.

Why would he have to apply the where clause against both queries? Couldn't he just do:

SELECT *

  FROM (SELECT Address, City, Region, PostalCode, Country

 ...

Or - do it one statement:

INSERT INTO tblA

SELECT 'xyz' AS ID,...[all other column names]

  FROM tblA

 WHERE ID = 'abc'

To clarify what I'm saying in...

Also, it looks like you said that your index is on the column: PRPR_ID. Your query, however, does not involve that column; therefore, the query optimizer is very unlikely to...

Try this (using apinelli's example table):

SELECT *

  FROM Products AS a

  JOIN (SELECT b.ID_REC

          FROM...

Try marking the stored procedure as a system object:

sp_MS_marksystemobject 'SP_PH_WHO2'

and see if it works properly after that.

Matthew Burr

I just wanted to correct something. It is not true that inserts to a heap will always go at the "end" of the heap. SQL Server maintains PFS (Page Free...

I would usually use DBCC PAGE to view the page in question; the page header indicates what object the page belongs to. For example, given the information you provided, I...

On the contrary, you can mark a user object as a system object by using the stored procedure "sp_MS_marksystemobject" (as documented in Ken Henderson's The Guru's Guide to Transact-SQL. The...

A clustered index is one where a leaf-level of the index is an actual data page, i.e. it contains the actual row data on it. This differs from a non-clustered...

You have to have a separate Virtual IP and Virtual Name for each additional clustered SQL Server instance you install on a cluster; according to Books Online each Virtual Server...

quote:

---

On first thought I like the DSN idea. You could use a UDL instead if you're using an OLEDB connection rather than...