I don't understand what you are trying to do?

If you want to create a table, you create column with data type and length.

When you do the SELECT distinct statement ,...

I have this book and I don't find it super helpful.

On page 216, it talked about ActiveX script task, it said 'Visual Basic.Net' is the only language supported by...

The first comment of the first article I submitted for SSC was complaining my grammar !!!

Actually that was not it, one time I had to write a report and when...

I like to write but I don't like to write technical article because I don't consider I am an expert to write some technical topics to inspire people. Another...

Why can't you create a job to run the package and schedule the job to run daily?

According to Princess Diana's interview, there were three people in her marriage. That meant Prince Charles 'was' married to two women at the same time. 😀

However there is no...

Prince Charles, Princess Anne are married twice.

I am very upset because my boss kept yelling to me the whole day to make sure the database correct. I told him if the company did not put...

BTW, I found out the hacker has already hacked into a lot of websites.

http://blog.washingtonpost.com/securityfix/2008/04/hundreds_of_thousands_of_micro_1.html

The main tables are the customer and product table. I am not worried about the product table. The customer table does not have any SSN or credit card...

All the web page connected to the database as 'sa'. Scaryyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy!

If you don't have linked server, you can still query the other server but you need to use OPENROWSET or OPENDATASOURCE.

Have you build a link server between ServerA and ServerB? If not, you could not query the other server.

I had built data warehouse using Oracle (PL/SQL) and SQL Server (T-SQL and DTS) for the ETL process and the build process. I never used those 'fancy' tool to...

I think the location of the job is important, every place has its own cost of living. The higher the cost of living, the higher the salary, but does...