It sounds like you have a good idea of the operations that need to be performed. So, for now we'll make the assumption you can code the stored procedure. To...

Hmmm... Could you call the Notification Service at the end of your batch instead of resorting to a trigger? Perhaps log the changes in another table and then let the...

Here's a quick solution:

SELECT		t1.col1,

		Max(t1.col2) col2

INTO		#tmp

FROM		t1

GROUP BY	t1.col1

SELECT		#tmp.col1,

		#tmp.col2,

		t1.col3

FROM		#tmp

		JOIN

		t1

		ON #tmp.col1 = t1.col1

		AND #tmp.col2 = t1.col2



DROP TABLE	#tmp

--SJTerrill

Edited by - TheWildHun on 06/12/2003 12:56:09 PM

I may be over-simplifying this, but:

SELECT		col1,

		Max(col2)

FROM		t1

GROUP BY	col1

--SJTerrill

Ah, I'm definitely over-simplifying. I believe you'll have to resort to subquery to return the contents of the whole row.

Edited...

I'd have to say I fall more on the development side (229). To tell the truth, I don't consider myself a really good admin... perhaps that's laziness, or just a...

<Preparing for bruised ego> Sounds like fun, indeed!

I recommend using Books OnLine (BOL) to get the full story, but xp_cmdshell allows you to perform a WinX command shell string.

It's like this:

xp_cmdshell '<filepath>\<filename>'

Regards,

SJTerrill

quote:

---

Have you looked at instead of triggers?

---

It's possible that tkbr0wn meant to say, 'Have you...

I just have to weigh in with the 'purists' on this one.

I won't argue that cursors are an appropriate or inappropriate solution. I agree with all the preceding that they...

Could you post the error you're receiving?

trinity, could you give us some more info? Specifically, the relationship between (I think this is it) activity and cert_x and/or activity_type and cert_x? Or is it activity and score...

Gurus,

I've encountered the compilation error referring to a non-existent table in 6.5. I'm wondering if the exclusion of this error in SQL 7.x and later isn't related to a simplistic...

Search BOL for this phrase: Deferred Name Resolution and Compilation.

SJTerrill

Well, if bcp isn't an option, I agree with Andy's recommendation. If you create a stored proc that performs the staging insert into a copy of the target table, you...

Oops. It only works if you run it in QA from the database which you want to check for locks. If you do it from master, I end up with...