Initializing files that size will take a while, even on a blazing fast machine. Give it some time.

Excellent. Then the join should speed things up considerably. Assuming you have indexes it can use.

The documentation on sp_send_dbmail includes rules on attaching query results. If that won't do for what you need, what I often do is turn the query results into an...

Try this:

update orderimport

set import_rec_status = 'A'

from pharm.dbo.cms_medorderimport as orderimport

left outer join pat..cmspatviewl vw

on orderimport.patientid = vw.patid

and orderimport.mardbname = vw.mardbname

where orderimport.import_rec_status = 'i'

and vw.patid is null;

Might be faster.

Also, guessing from the...

I run into the same issue. Can't authenticate into the page. Can post as a guest, but anyone who wants to post as GSquared can pretty much do...

Just change the row_number() partition and order by in my query to suit your needs.

Not a chance. He's already got another thread on this site where he's bragging about the fact that someone provided a link to an article about index fragmentation, and...

Slight benefit that you can use the log for an audit trail. Major drawback that it's going to consume more and more drive space as time goes on.

Is the Passwords table just a log of the most recent 9 (or less) passwords that someone has used?

If so, you could incorporate that into a single trigger that would...

To do that, you need to set it up as an output parameter for sp_executeSQL to use. Books Online has the rules for that and examples of how to...

Per your first post, the problem is the ID not resetting. Maybe I'm misreading this:

As seen the first student processes just fine however the classId isn't reseting on...

Trust me, that's not just a UK thing. I've never encountered it yet in the US. I was asked what I would do. I consider most managers...

I use either joins or subqueries. I've found both effective.

WayneS (10/20/2009)

bitbucket-25253 (10/20/2009)

Wayne I submit that your problem is NOT with the developer but with either the hiring/current Manager who think that the...

The best method I know for deduping looks like this:

;with CTE as

(select row_number() over (partition by [Load Number], [Event Code] order by 1) as Row

from dbo.MyTable)

delete from CTE

where Row >...