Aplogies, that was for Emmanouil.

More coffee? he he he... Being in the UK and being of a slightly insomniac disposition means I get a head start! 😀

Hi,

I noticed that on your example of your Format file you have 59 columns defined whereas the file you are importing only has 56 columns. The last line in your...

I suppose it depends on the individual; for some reason I have a penchant for DTS and SSIS. Although I also enjoy seeing if I can get a T-SQL based...

Ok, cool.... A simple data transformation task between the source file and the destination table would remove the trailing spaces in the fields.

In English, the DTS package (attached as...

Hi guys,

Have I missed something? Is using DTS or SSIS out of the question? :ermm:

The best way to answer any interview question is honestly. Any interviewer worth their salt will pick-up on insincere answers.

You may be leaving because the work that your presented with...

I'm afraid I have to agree, sometimes it's just not worth it.

If you really want to try it, you're best bet may be to insert the data from the XML...

With the sample data provided you could use MAX or MIN functions to return one record per first and last name:

SELECT First_Name, Last_Name, MAX(major)

FROM myTable

GROUP BY first_name, last_name

This would return...

If you want to see your leading zeros in Excel then you need to either:

1. Qualify the field with quotes (e.g. "0000123") when exporting to the csv

or as said before...

2....

Hi Sandy,

I like the question! It really got me thinking.

It's going to be a bit of a busy year for me I think. I've got 3 Open University Courses (in...

I'm afraid that we're all going to need a lot more information than that to help you..... Information such as:

What is the incoming XML and what does it mean?

What processing...

I guess it's just experience. For a lot of the RBAR solutions (now considered problems!!!) that I used to come up with, I can work out the set-based way of...

I'm so glad that you've got an interview! :w00t:

Remember to concentrate on what you can do, highlight what you have done in previous similar roles, and point out occasions where...

Hi,

I am not a scientist but I have worked on a number of database and reporting applications for an environmental services company in the UK. I have found that there...

I think that the question is quite useful, especially if you are starting a new DBA job or contract; poorly formatted coding is out there. The author may well feel...