Hi Kevin

I wasn't aware of this, thanks for the warning!

I am a beginner in SQL Server, and am trying to find my way, doing as much new stuff SQL Serveras...

The complete function is as follows (but basically what you already know):

CREATE FUNCTION [dbo].[fnTimeCalc]

(

@OriginalTime AS INTEGER

, @TenthsOrHundredths AS INTEGER (code 0: 1/100, code 1: 1/10, code...

Thanks You Luis for your response.

You suggestion would mean that I have to add a line for each of the 5 codes there is.

At the moment I have 10 lines...

Hi Kevin

I have added, in my earlier thread, an Excel file with (maybe too much) data.

In my 2nd thread (from yesterday) I have posted an Excel files with the 6...

Hi all

I see that my thread receives replies from several people, thank you for that.

Kevin sorry for not replying yesterday to your thread, it got kind of late in the...

Hi Kevin

I have already, in an earlier stage looked at tyour suggestion.

In my query I ask for the top 100 results in a database that holds up to 10 million...

Hi Kevin

Thanks for your reply

I have made an exmaple for you, containing the 6 different query results.

Hope this helps you to get an idea

Hein

Hi Sean

Thanks again for your contribution and advise

I will study the added link carefully and hopefully get the "feel" for it which fields to use and which fields not to...

Hi Sean

Thx for your reply

The fields I did mention in my question are the fields that will be used most in queries.

Sometimes all fields will be necessary, sometimes only (eg)...

Hi Shahnawaz,

I did as you suggested.

After installing the driver it took a while to get it mentioned in the administrative tools\data sources (odbc) dialogbox, but using the file C:\Windows\SysWOW64\odbcad32.exe got...

Hallo Eirikur,

I will give it a go, thanks for your suggestion

Hein

Hallo Eirikur,

I don't think that is the solution

The linked server only allows me a small portion of the things I want to do

1 of the tables I need to address...

No harm done Ed,

I agree with you on many topics.

Because I didn't want for people having to read a very long story I skipped some parts.

Your suggestion on installing SQL...

Ed

Thanks for your, somewhat harsch, reply.

The situation that you describe (Scratchpad etc) is just what I wanted to avoid by asking my question.

Just because there are so many SQL Server...

Hi Bob,

After a (hopefully) well - earned weekend away I have completed the "task" of deleting everything related to the previous installations of SQL Server.

A moment ago I have installed...