I'm sure there is probably a more efficient way to do this, but this would do the trick.

declare @counter int

declare @max-2 int

select @max-2 = max(mesage_reference) from table_name(original table)

select @counter =...

When you need to change the view, just change it to alter view. It's just the way things work in 2000

OK this is a new one - I was using dmo to grab all my table objects, loop though them appending the script for each one to a variable. then...

Well, I only have one step, and it does the vbscript. there is only one line after it writes the file (the file does get written, so that line executes...

I would change your proc to do a few steps -

1. Identifiy the records you would need to insert and possibly put the records to insert into a temp...

I think you need to make the procedure you are calling a function so that you can use it in a select list

I enjoy playing music - guitar and bass. writing music, listinign to music - it really makes me forget about the rest of the day

well, the problem is that cold fusion has a hash function that I guess is similar to the checksum function - it will evaluate to the same set of digits...

Im guessing you want something like this:

Month     Visits     payments

Jan          5           8

Feb          8          7

Mar          10          2

Total       23          17

if you are using a query like this:

select [month],sum(visits) as visits,sum(payments) as payments group by...

I guess a from clause would help.....

select I3_rowid,sum(case when querytype = 'escalation' then 1 else o end) as escalation,sum(case when querytype = 'rejection' then 1 else 0 end) as rejection,sum(case...

select I3_rowid,sum(case when querytype = 'escalation' then 1 else o end) as escalation,sum(case when querytype = 'rejection' then 1 else 0 end) as rejection,sum(case when querytype = 'illegible' then 1...

you would do this:

Execute servername.databasename.ownername.procedurename

then pass parameters like you normally would

sp_addrolemember [db_denydatawriter],[veeresh]

This statement keeps him from modifying data - add him to the datawriter instead of denydatawriter role

You can just run this:

 restore 'database name' with recovery

you don't even need to give it a backup or log file, it will just bring it online.

Just go into enterprise manager and right click the database. Go to properties and on the options tab it will tell you what recovery model is set