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...

You can create a clustered index on the UpdatedDate column. This will cause a logical ordering of the rows on disk which may, for example, be helpful if you...

That's the kind of thing that SSIS was designed for. If you insist on doing it in a single stored procedure, you can try creating linked servers, or shelling...

I've done something similar recently, although I was looking for linked server names in stored procedure and view definitions. Here is what I did. It may be more...

The question assumes that XACT_ABORT is set to OFF. I know that's the default, but it would be worth mentioning in the question or explanation for clarity and completeness.

John