I'm sorry, but I still can't work out what you're trying to do. Please will you describe in words what your query should achieve?

Thanks

John

No, not unless you give us some more information. Please post DLL in the form of CREATE TABLE scripts, sample data in the form of INSERT scripts, a brief...

Then I think your original code should be OK. But check the execution plan to see whether it is using any index that you expect it to, and if...

So you're only testing for the NULLness of @Param1 and @Param2? That doesn't relate to the columns at all, and so you're either going to get all the rows...

A function will only stop an index being used if it's applied to the column, not a parameter or constant.

John

Assuming the only two values allowed in the type column are CRT and DBT, something like this:

SELECT InvoiceNumber, MAX(type), MIN(type)

FROM MyTable

GROUP BY InvoiceNumber

HAVING MAX(type) > MIN(type)

John

Debra

If you don't have more than one update in any particualr second, you could do something like this:

select datediff(s,'01 Jan 1980',getdate())

If your updates are more frequent than that, you could...

Debra

Have you tried NEWID()?

John

Debra

I think the simplest way to achieve what you want is with an identity column. If this is a new table, add the identity column before you insert any...

Yes, there is. Look up the sys.database_permissions metadata view.

John

If EXCEPT works for you, then go with it, although I don't think you need to waste time concatenating into a single column - just specify both in the query...

What happens if you try to assign permissions to individual tables? Choose a table and execute this:

GRANT SELECT ON dbo.MyTable to NPQuiggin

John

Nigel

According to Books Online:

The names of users that are mapped to SQL Server logins, certificates, or asymmetric keys cannot contain the backslash character (\).

What is the actual name of the...

Shouldn't be too complicated... what have you tried so far? What I'd do is use a LEFT JOIN to identify which records are to be deleted, and a RIGHT...

OK, I don't think you can just back that query out. So what you need to do is restore to a different database, then do something like this:

UPDATE d

SET...