SELECT ITEM_NO, iv.ITEM_VEND_ID, PRICE, ivp.CTLG_NO

FROM ITEM i

INNER JOIN ITEM_VEND iv ON i.ITEM_ID = iv.ITEM_ID

INNER JOIN ITEM_VEND_PKG ivp ON iv.ITEM_VEND_ID = ivp.ITEM_VEND_ID

WHERE i.ITEM_NO = '3501'

AND iv.ITEM_VEND_ID = (SELECT MAX(ITEM_VEND_ID) FROM ITEM_VEND...

>On a slightly different note I have some "horrible" views which work 100 times fater if I can turn off parallelism

http://blogs.technet.com/mat_stephen/archive/2005/02/08/369120.aspx

The statement in the EXEC is run in a separate batch, so it needs to be declared there.

However I think I would rather suggest that you change the design of...

Try my article here at SQLServerCentral: Fragmentation 101

If the table always contains two rows for each id, then this should work.

SELECT t1.id, t1.key, t1.val, t2.key as key2, t2.val as val2

FROM sometable t1

INNER JOIN sometable t2 ON t1.id...

Depending on how a 'fairly complex SP or statement' is written, it will often be much slower when executed with SET FORCEPLAN ON. If you use that you are now...

As Remi shows, this way of naming procedures can be used to group them together and drop them all with one DROP-statement. However it is not used by SQL Server...

Is this KB of any help? http://support.microsoft.com/default.aspx?scid=kb;en-us;308766

Books Online - Functions

No, if you are sysadmin you can do:

EXEC master.dbo.sp_password @new = 'NEWPASSWORD', @loginame = 'LOGINNAME'

The old password parameter is optional.

What do you want to do? Just store a big enough value in the column? Then you can just convert the varchar, like this:

DECLARE @foo VARBINARY(MAX)

SET @foo = CONVERT(VARBINARY(MAX), REPLICATE('foo',...

The version using Stream is best, imo. The problem might be that the account running ASP does not have access to the local file you have specified.

>waht i do is I introduce a new Field in every table that atcs a primary key.

>Am i wrong ?

Yes, like I said you have confused primary keys with surrogate...

Maybe you should be asking at a Postgres forum instead then? Not that we do not want to help with non-SQL Server questions, but it is quite possible that you...

David, you did get them mixed up.

The clustered index key is stored with other index keys (in non-clustered indexes). A primary key can...