Here would be a booster to aid in acceptance. Since lots of us developers embed SQL...

Good article Phil. I got to

and it put me in mind of my cats. 🙂

Then I saw your create table template....

I guess I'm still an old fart. I like having my SQL and applications separate. Then if Phil is getting on the bandwagon ...

Jonathan, if you want to...

Well I could not prove that it was malicious. Could be just incompetence or the "many cooks" syndrome.

What I say is: If it walks like a duck and...

:w00t: And here I keep buying your books to wave around in our ethics meetings! :w00t:

Good, fast, cheep. Pick any...

Could you make a version of up_CalculateEPoints_Insert (say up_CalculateEPoints_Insert_All) that would incorporate the selection logic query so that the whole solution could be set based?

SELECT 'EXEC up_CalculateEPoints_Insert ' + EID AS Command

FROM Es

WHERE ProjectID=@ProjectID AND Scanned=0

ORDER BY EID

Save the result to a text file and run it back though SQLCMD...

So was God overreaching when he first spoke? Today would that read, "To improve the customer experience we are undertaking an expansion of our 'dark mitigation' process."

Thanks Bill.

I don't list COBOL, FORTRAN, 360 ASM, Hasp, Wylbur, Course Writer II, APL, Word Star, or Electric Pencil any more. And those are the ones I can remember...

I used it to look at old versions of...

Irish Flyer (1/29/2009)

---

4) CLR assumes you want to use OO code, which is highly inefficient for procedural operations. SQL is a procedural language and does what it does very...

Three things:

(1) Congratulations. When other place are losing people SSC is growing.

(2) I've been telling everyone that they should come here and join. They do, not because of...

The other day I was doing a search on Testing Methods. I was floored when an article I was reading linked to an item on my own web site....

ASCII silly question, get a silly ANSI.

Able: "Why do the Britts always say 'Ten minutes Time'? Are there any other kind of Minutes?"

Cain: "Define the word 'parsec'."

Able:...

majorbloodnock (1/26/2009)

---

To anyone concerned with the number of responses on this thread, I'd offer a thought. There's not one suggestion yet that concerns SQL Server's ability to efficiently, stably and...