We have recently upgraded our SQL and are having the same issue, but I don't know how to change my statement to get blank results instead of "null" in my...

Just an FYI - when I create the ODBC SQL connection I am provided a list of over 600 SQL servers on our network.

What I currently have is very limited access to a sql database through sql client services.

I access the database using query analyzer, run my query to extract just the data...

Not familiar with SSIS, but a quick read on the internet suggests you may have a point. Since cost is such a great factor these days and this is...

Please don't get me wrong - I love working in SQL, but for newbies trying to learn database design I think Access is easy. It is a good starting...

Like you, I love data, and like you I went through the learning process of design and development, only to find that my real calling was data analytics. I...

It looks like I am back to the drawing board. Don't understand why anyone would create a data file with no way to identify the records and all updateable...

Looking at the data they provided we have 6000 of the 7000 records added with the same date time. They returned the data as dd/mm/yyyy hh:mm:ss AM formatting. ...