Have a look here, http://www.sqlservercentral.com/articles/SQLServerCentral/66909/, and then the experts will all come out to play and you will get a very nice solution to your problem.

The key thing I would be looking for is a level of salary standardisation, same pay for same work type things. I've worked in places where when they promoted...

The last place I worked for that had in house development and hosting was about 1 to 8. It was a strange mix as one system had two developers...

I just use a concatenate and a right.

So select right('00' + cast(1 as varchar) ,2)

I love a question that should have a 100% success. It is a very nice way to get me to research new features.

Thank you for the info, looking forward...

One method you could use is create a new table with the new column as an identity column, then run an insert statement, not populating the identity column, with an...

No, a real professional will understand IT security and never expect anyone else to open a zip file from an unknown source.

I just keep repeating the mantra "no one has ever lost their job for failing to take a backup, only for failing to recover the application to the required state"....

And unfortunately none of them are intelligent enough to investigate. Oh for the good old days when IT was a black box that no one got involved in unless...

Get use to using the INFORMATION_SCHEMA version as it is a part of the SQL ANSI Standard whereas MS can modify the system tables with releases and patches INFORMATION_SCHEMA will...

If i create a single composite index on [LKUP_ID] and [ATTR_VAL] columns, will the index be useful if I run a query like this:

SELECT LKUP_ID, ATTR_VAL

FROM [APP_DEAL]

WHERE ATTR_VAL=97067

My question is,...

I have a very strict self rule on working from home, I won't. Two key reasons. Firstly as a project manager I feel I need to alwaays be...

Have a look at using the information_schema.colums collection, you can find the tables with the column you are interested in, then get all columns from the table and build your...

Have a read through this article on how transactions work to make sure you get what you expect.

http://www.simple-talk.com/sql/t-sql-programming/handling-constraint-violations-and-errors-in-sql-server/

To provide full character support, including double byte characters.