Indeed. Hence the warning about performance.

John

It's checking to see whether @Num has any non-numeric characters in it. Look up the PATINDEX topic in Books Online for more information.

John

Something like this should work, although performance could suffer since any index on ProGroup will not be used:

WHERE COALESCE(pg.ProGroup,'No Group') = @userParam

John

Karen

If you have a backup file (.bak), you can restore the database. If you have the database files (.mdf and .ldf), you can attach the database. The procedure...

Here's how to get the results you need:

SELECT CompanyNumber, ProductOrdered, OrderDate, COUNT(*) as OrderCount

FROM dbo.testtable

GROUP BY CompanyNumber, OrderDate, ProductOrdered

As you'll notice, they're not presented in the way you need. ...

Could this be anything to do with the double hop authentication issue[/url]? I think that may be what Tony touched on.

John

How are you connecting to Enterprise Manager and Query Analyzer? Please will you post the command you use to invoke OSQL?

John

That article talks about handling errors using Event Handlers. What it...

Just create a table (either permanent or on-the-fly) with the range limits in, and join it to your data to get the row counts.

John

It's for your consumption rather than mine. You stated that all logins have master as the default database - I just wanted you to check that that is indeed...

An index on a dual-valued column isn't likely to be of much use, unless one of the values occurs significantly less often than the other, and that's the value you...

WITH RowNos (MAIN_SKU, DEDUCTIBLE_amt, RowNo) AS (

SELECT MAIN_SKU, DEDUCTIBLE_amt, ROW_NUMBER() OVER (PARTITION BY MAIN_SKU, ORDER BY History_id DESC)

FROM [History table]

)

SELECT MAIN_SKU, DEDUCTIBLE_amt

FROM RowNos

WHERE RowNo = 1

John

I would recommend that you use an unambiguous date format in your code, such as '20130512' for 12th May 2013, if you have the option.

You can set the format using...

I know you said the default database is master for all logins, but please humour me - what does this return?

SELECT name

FROM sys.server_principals

WHERE default_database_name <> 'master'

John

I think the login failure error you're getting points to not being able to open the specified database. What is the default database for the user(s) this is affecting?...