Joshua Perry (3/19/2008)

---

The answer is absolutely wrong. You can't use sp_unsetapprole because the cookie was never set using sp_setapprole. If you activate the app role before setting the...

Consulting? Involves a level of self-confidence and self-promotion that escapes me. I do some, for non-profits, for free. They love that they can write me off at...

The DBCC INDEXDEFRAG command is fully logged. There are several things you could do. The first question, however, is what is the current recovery model of the database?...

Not having the DDL for your table or any sample data, I came up with this:

select

sum(case when LastUpdate >= dateadd(dd, datediff(dd, 0, getdate()), 0) and LastUpdate...

Are you doing any data transformations in the direct move to the tmpTable from the MUMPS system, or is it a straight transfer?

😎

jburkman (3/19/2008)

---

Post #1, so I'll try to make it a good 'un.

I've read this excellent thread, I see the vibrant knowledge and experience of the participants, and I'm de-lurking to...

Taking the code posted be Jeff, here is one example of well formatted code.

CREATE TABLE [dbo].[ih_hist] (

[ih_nbr] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

...

Jeff,

I did get a favorable reply to my PM. Not to go into details, but in my reply back I did point the OP to your article on how...

Well, there is always hope. I've learned a lot more through this site, and some of that is from you. I think I try harder on some things...

Based on the OP's last posting, he might not see the posting after his. I dropped him a PM trying to explain some of our opinions and the reasoning...

True, but is the SQL Server 2005 database still around or was it temporary, for development? If it is sourcing the data for the SQL 2000 database then all...

Here is my thoughts. If it is for school, the OP should do as much of the work as possible. If they get stuck, ask for help to...

You think?? :hehe:

The image data type is a BLOB type. It stores a 16 byte pointer in the data record that points to the first data page that holds the image...

From the tests I had the OP run, the GROUP BY and SUM are not needed.

I believe he has the solution.

😎