couldn't you just add row_number to the results with the PARTITON BY and with DESC, then wrap it to exclude the "first" row (the last change?)

something like this?

(untested:)

SELECT * FROM...

right along the lines of what opc.three was suggesting, you could look at the code behind the scenes of sp_help and do something with it.

on my shared hosted server i...

looks like a sum of case statements to me:

you have to group by the patient,and then selectively sum the charges based on the Department(code?)

something like this, i would think:

SELECT...

add a rownumber() :

ie:

ROW_NUMBER() OVER (PARTITION BY [The text Column] ORDER BY [The text Column] ,[TheNumeric Column] ) As RW

with that, you could join the data against itself with...

MysteryJimbo (5/15/2012)

---

IMHO if its not restored on SQL Server, it hasnt been tested. If a restore fails, no manager in any company will accept the excuse "well it worked...

in a similar situation, i've used a function dbo.StripNonNumeric, which leaves just the string 0-9, which i could convert to an integer;

then i could do

ORDER BY

CONVERT(int,dbo.StripNonNumeric(SomeColumn)),,

SomeColumn

As long as you understand...

for testing backup validity, i would think the Developer version (~$50 dollars on Amazon) is ideal; it has all the abilities of the Enterprise version, but is for testing and...

access denied is due to the account running SQL server.

To access anything outside of actual databases, SQL uses a different account than you might think it should.

you will probably want...

pwalter83 (5/15/2012)

---

As far as I know, the login name on both...

there's an extended stored procedure to help you with that situation.

you can use it to query an iindividual's domain login, or a group from the domain:

try these out and see...

Only way i see getting those totals would be by using Change data cature on those tables in question.

Then you can query the cdc schema rltables for the counts

One example i can think of when see that behavior if you ALTER TABLE , and then insert into the table while referencing the new row; to get it...

SQL formatting is important for me, and i tested the RedGate tools, which are really nice, but they were more than I wanted to spend.

I ended up purchasing "SQL Pretty...

others will certainly do it differently than I do, but I have three different tables for accomplishing Tally-related objectives:

Tally, which starts with 1,

TallyCalendar, which is all date related.

and Numbers, which...

if it helps, i usually create this temp table, and then insert multiples into it via the script below:

i don't keep track of the specific file the way Bhuvnesh ...