I forget to mention we are using SQL Server 2000 and we use DTS and stored procedures for ETL tools.

My old company spent millions of dollars buying Ab inito.  It...

My company just changed to use Hyperion.

In my old company, the developers developed in-house reports using Actuate report (terrible tools), Active X report (OK) and microsoft reporting service (now it...

I wanted to clear something.

When I put anything into production, the company required us to fill out a form and had at least 6 manangers signed the form.  The DBA...

First, I would like to thank Clarold Britton to edit this article for me since I am still struggling my 'Chinlish' - English grammar.

I am working in a different company...

Now I understand what you want to do, you want the job to run every 15 minute interval.  The frequency interval only has hours and minutes.

Instead of using schedule job,...

When you open the job in EM, click on the Schedule tab, you can set the schedule there and you can schedule in hh:mm:ss.

Is this a joke?

Create view Candidate

AS

SELECT c.CandidateID, c.FirstName, c.LastName, c.Email, c.Nationality, c.English, c.Spanish, c. French, c. Portugese, c. OtherLanguage, c. OtherLanguageLevel, c. DOB, a.PostingID, a.CategoryType, e.DegreeID, d.Degree, x.exp

FROM CandidateTable...

So I assume Table B the identity column is the customer key and the customer may exist in table B already.

You should do two steps, one is insert customer that...

Can you be more specific?  Does table "A" have the same number of column as table "B" except there is no constraint and identity column ?

For example:

Table A (col1 varchar(10),...

select ('adfd'  + cast(18 as varchar(3))) as  'cvr < '

Is this what you want?  The result is 'adfd18'

Why do you need to use a cursor?

The big 'C' is a big No No in SQL Server.

Is it difficult to attract good programmer to a small town especially if both husband and wife working on different fields?  It is not easy to find a job if...

Nice article.  However I never see any DBA get fired who had made the mistake on your list.

In my last job, the junior DBA...

The whole query looked liked an Oracle query.

Decode, month_between, sysdate are all oracle terms. 

Do you want to write an Oracle query or SQL Server query?

I don't think there is any difference in using INSERT INTO #Temp (  ) SELECT

and SELECT ... INTO #Temp FROM

SELECT ....INTO created the table by itself instead of the...