I agreed with Jasmine, programming will not faded away.  If the computer can do anything, then it does not even need Captain Kirk, actually it becomes the 'TERMINATOR'. 

I do not particularly like IT.  I chose to major in IT in college because my parents thought it was easy to find a job.

I can do a good job...

Besides technical skills, I think DBA should have people skills too.  I saw one DBA got fired because he thought he had the best skill set, he was arrogant and...

I have a question about the item cost, even it changes daily, don't you need to keep a history of it, otherwise how do the users know what happen?

I am not sure if this is what you are looking for.

                                    Tbl_HAART

DECLARE @Location VARCHAR(2000)

SELECT @Location = @Location + dbo.LOCALITY.LOCALITY + ','

FROM dbo.LOCALITY

 INNER JOIN  dbo.BranchLocality

  ON dbo.BranchLocality.LOCALITY_ID = dbo.LOCALITY.ID

where dbo.BranchLocality.BRANCH_ID = 34

SET @Location = SUBSTRING(@Location, 1, LEN(@Location) - 1)

SELECT @Location

@Location...

Yes, I don't know what happened.

Status = 'Change' or 'Switch'

No one ever asked me weird question but I thought that your manager was very smart.  She was not only hiring someone with the right skill but also looking for...

Jasmine,  congradulations on your new company.  Before you start all kind of perks, make sure you hire the right people with good technical and communication skills and make sure they can...

administration, clustering, partitioning, anything that DBA does

For SQL Server 2000, I am an application DBA, the only thing I don't know how to do is clustering,  nt server administration, calcuate...

Jasmine, somehow I have the same feeling about people.  I also work for IT about 20 years.  When I started working, people and company had different mentality and attitude, they...

The bcp call is in dynamic sql of part of the codes.

SET @SQL1 = 'bcp TempClientTable IN  ' + @TextFileName + ' -t","  -T'

EXEC(@SQL1)

I was thinking about using format file but...

To find the missing month and roll up the budget from previous month.

I did not test this so I did not know if it would work.

SELECT a.dept, a.budgetobject, a.Fiscal_key, b.fiscalmonth,

         ...

First I think you are making things too complicated.  Also if there is no activity in Month 06, then you need to add a record for Month 6 from month...