Check out this link:

http://www.developersdex.com/sql/message.asp?p=1921&ID=%3C1146409399.447345.7470%40j73g2000cwa.googlegroups.com%3E

I think it is the same problem you are having.

Google is amazing.

KATHLEEN Y ZHANG (2/28/2008)

---

The stored procedure select some data from a table called tblproductoption with (nolock) into a temp table, then use a cursor to loop through the temp table...

This fixes your error, but I don't think it gets the results you are looking for as it returns all the rows.

select

a.*,

b.f3

from

t1 a inner join

t2 b...

First of all you need to post your query if you want that tweaked. Second a difference of 5 what, days, minutes, seconds, years?

THis select will get all the users that completed all the tests.

Select

user_id

From

user_test_results

Group By

user_id

Having

...

master.dbo.sysdatabases will get you the database list.

You need to use sysusers in the database. That has users and roles in it. syspersmissions has the permissions linked on uid...

When using a select to do an insert you do not use the parentheses in your select. Your code should look like:

INSERT INTO intrf_ext_mapped_value

(

ext_system_id,

provider_id,

location_id,

type_id,

mapped_value,

delete_ind,

note,

created_by,

modified_by

)

SELECT

...

Matt's solution will cause an error to be thrown whenever the constraint is validated so you will want to catch the error.

Matt Miller (2/28/2008)

---

I never really understood the "no gaps thing", which is a wrong-headed control measure. Having to resequence your bills of lading because someone calls and cancels the...

now Matt, there are instances where a sequence table is necessary:D. ...

Manie,

You need to supply a lock hint when selecting from the invoice number:

select @nextinvoice = [next invoice number] from company with(updlock)

There is not a simple way to do what you want. You can remove identity from the column set the values to null and put the identity property back, I...

Use sp_send_dbmail. Use BOL for details.

Just be aware that by doing this any...

Nice #. Ray Bourque.