Can you show me the query?

Anyway I have created dynamic Sql over 8000 characters.

DECLARE @SQL1 VARCHAR(8000),

...

So I assume you have a Date dimension table, Company table, what about gender, ethnicity, marital status, does each one have its own dimension table or all these...

You can use sp_help_job to find out the job status.

EXEC msdb..sp_help_job

@job_name = 'Job'

,@job_aspect = N'job'

This will come back with a result set, the...

That certainly gives the developer who uses both Oracle and SQL Server a headache. I have to use both Oracle and SQL Server in most of my jobs, talking...

The problem is when you execute notepad.exe using Execute task and runs on a job. You need to put the directory, otherwise, it does not know where to find...

My previous obnoxious manger insisted to use trigger to update the table, it created a big deadlock in the system because it locked the table. If your inserted table...

What do you want to know?

Dimension table has the lookup field of the system eg, customer, product....

Fact table has the measure (number) and has the dimensions in it. ...

Oracle used *= but now it always uses outer join. I like to use ANSI standard better, it makes more clear. The Oracle developers still use *= but...

Jez, that is a good idea. If you put a surrogate key in the table, then it will eliminate the possibility if two parents have the same child.

CREATE TABLE...

What about Rochester, NY? Can I work at home? I am 3 hours away from Toronto.

Probably I can make a trip once or twice a month to...

I used to load multiple text files with different format into different tables in a database.

I created a table called TextFileInfo with TextfileName, Path directory, formatfilename with path directory,

table name.

I...

When I designed the drilled down table, it contains level1 info, then level 2....

In your case

Table Material_DrillDown

Material VARCHAR

Item VARCHAR

Table Item_DrillDown

Material VARCHAR

Item VARCHAR

Item_Info1 VARCHAR

Item_Info2 VARCHAR

Material = Paper, Cardboard, Vinyl

Item = for...

I used to work for a software company and I used Installshield to write install script. My DBA used Perl to write install script. No matter what, your...

You mean when you have a deployment ready, you can start a job and update all the clients?

Then why don't you put the clients in a table, then write a...

That was exactly what I wanted to say, if you use 'ALTER TABLE ADD COLUMN....', if the table was big, it would take a long time because during the alter...