Or more generally, using an outer join:

CREATE TABLE MyProducts (ProdID int, ProdGrp char(7))

INSERT INTO MyProducts VALUES

(11, '*')

,(12, '*')

,(13, 'Group A')

,(14, 'Group B')

,(15, 'Group C')

CREATE TABLE MyGroups (ProdGrp char(6), ProdGrpDesc...

Try passing in your date in an unambiguous form, such as '20141001'.

John

Time for you to use your favourite search engine to investigate, then. It's a fully documented stored procedure.

John

EXEC xp_logininfo 'DomainName\GroupName', 'members'

John

Read them in as integers, do your arithmetic, then cast as a string. Something like this:

SELECT RIGHT('00' + CAST(1 AS varchar(3)),3)

John

Keep collecting the data as you are doing, and use a view to show the daily difference. You can use the ROW_NUMBER function to number each row, then join...

If you can get it down to one instance, yes. There might be reasons why you can't: some applications may not support the version of SQL Server you wish...

Have you considered consolidating your databases to a smaller number of instances, or even to a single instance?

John

I thought about using a function but I don't think it will be flexible enough as in certain cases I want to parse 2 or more IDs back into the...

Yes and no. If the same login exists on both servers, that'll work. But also, if you're a member of GroupA and GroupB, and GroupA has access to...

Please can we see the table that contains the grouping information?

I think the best way will be to add up and and number the groups in a CTE, then do...

spaghettidba (10/15/2014)

---

John Mitchell-245523 (10/15/2014)

---

I think filegroup restores are for you. You may need to organise your database first so that only the file in question is in the filegroup...

I notice you have at least one duplicate index in your list. It won't make much difference to how quick your query runs, but it will slow down inserts,...

Abhas

That query isn't syntactically correct. Please will you post the actual query you're running, along with table DDL (in the form of CREATE TABLE statements) and sample data (in...

I think filegroup restores are for you. You may need to organise your database first so that only the file in question is in the filegroup you're going to...