I did learn something from this article - Step 5 - Building and Referencing the DLL.

Since the example was not overly complex, it was easy to absorb the part I...

Not I hope, by breaking all existing code in production - this they did when they killed basic to introduce dot nyet basic.

Two pages is now out of style. Large companies are now using an Applicant Tracking System. Incoming cv's are scanned by the ATS for the purpose of identifying the relevant...

declare var = ...

not valid in sql 2005 ...

I also go the same route, but I'm a bit lazy and typing @q is only 2 letters instead of the eight characters in CHAR(39).

declare @q varchar(1)

set @q =...

I agree with Gila.

Your first cursor code is only 44 lines of code. So this should be manageable for your first cut at rewriting the cursor-based code with a few...

It looks like a problem I had before in a Delphi application.

I solved it by casting to int and comparing to1 (integer value).

Sergiy (5/21/2009)

---

If an error happens in a job the whole job fails.

No matter if you have error handler in the code or not.

Forget your Try-Catch habits while in T-SQL, they...

What you need is to create 3 distinct tables.

CREATE TABLE County

(

pk_ CountryID CHAR(3) NOT NULL PRIMARY KEY,

...

By default, a column declared as a PRIMARY KEY should be clustered. Looking at the script I did not see anything about dropping an existing clustered index prior to creating...

Books are something I still cherish. As a dinosaur (57 as of last Friday), I still find a good much more user friendly. And for a long time there was...

Michael Valentine Jones (3/20/2009)[/b

Not that I would ever recommend using this to get the next ID for anything I was designing, but when someone has already put something like this...

-> Foxjazz:

I insisted on the WHY of things not in the mindset of an inventory manager who does not want to get off his steak. In a previous life I...

Heh... nope... I don't believe I ever wrote that... If it were for a sequence table, I'd have written something like the following (partial code)....

UPDATE NextID

...

Meaning that noone was ever faced...