I just quited that job !!!!!

Now I know why 99% of DBAs want telecommute !!!!!! They don't need to go through the back door because they don't even show up at the office. They...

It sounds to me your job is a helpdesk technicians. However you have a chance to write SQL Scripts and touch some database stuff, that is a good sign.

If you see a lot of job postings, they don't ask for MCITP DBA. Even some of them just said it would be nice to have but not required....

Don't go to HCL. My old company outsourced to HCL, they had the worst developers.

It is not going to hurt if you know BI. Most of the job these days requires to know .Net, SQL Server, BI. So if you .Net and...

I think right now most SQL job requires you to know SQL Server 2005. Of course most of the job description includes .Net, BI, reporting service, DBA experiences, performance...

sorry, it should be

Here is an example of using input parameter in OPENQUERY.

declare @input VARCHAR(10)

declare @sql nvarchar (4000)

SET @input = 'abc'

SET @sql = 'SELECT col1, col2 FROM server1.dbo.table1 WHERE col3...

Here is an example of using input parameter in OPENQUERY.

declare @input VARCHAR(10)

declare @sql nvarchar (4000)

SET @input = 'abc'

SET @sql = 'SELECT col1, col2 FROM server1.dbo.table1 WHERE col3 = ''' +...

Have you created the linked server between the two servers? Otherwise OPENQUERY is not going to work.

I don't understand what you want to change?

First of all you need to change the end date to include the timestamp, I would do a change to convert(VARCHAR(20), enddate, 121),...

It depends. I know I got burnt in my previous workplace (actually more than one) about having my colleagues as friends.

I still think it was much easier to make...

Sorry I have to disagree with you. Communication is a big part of software development. If you misunderstand what your client wants, even you spend 80 hours a...

Anders - basically you change job if the company does not keep up with the technology. Well, I did the same thing too and I was called a 'job...

Most people apply for a job that they are not qualified for because they do not have a job and they desperately need a job or some people just hate...