Hi,

Thankyou for your reply, the fields are :-

Field1, Field2

23116,02 etc etc

The output would need to be 23116/02.

Thanks

Excellent stuff!.. I will be able to work through the code.

One thing I've noticed is that an event of 1.30 creates five seperate records. Is possible to split a...

 Hi,

All fields are decimal values, but I still need the decimal value of > 0.30 as the flag.

All values from the source table should be inserted into a...

Hi,

Yes are correct :

0.37 should be split like this :-

0.30 (first row)

0.07 (second row)

1.33 means 1 min 19.9999 seconds

Thanks,

Hi,

To further explain the issue I've created a dummy table below. Where the duration field is > 0.30 the record will need to be split the first record containing...

Hi,

Initially I thought the issue could be with AWE, until I noticed that the fix had been applied sometime ago.

We have just added additional memory to the server, and have...

Thanks, I'll run a trace for a day and review the results.

Regards,

Gentlemen,

Thankyou for your replies.

Russel,

Would your solution also work if an application updated the tables? 

If I concatenated date + time to Eg 01/12/2006 08:15:13 for the entered record how would i write the following query:

Source table Last record in date field SOURCEDATE 01/12/2006...

Hi,

Unfortunately the table has no identity column.  There are date and time fields would it be possible to perform an extract based on the time of the last record...

Hi,

Here is the code that I have to date for the view

SELECT 

 CAST('' AS VARCHAR(20)) AS 'cre_nm',

        create_date AS 'cre_dt',

 update_date AS 'lst_updt_dt',

 CAST('FLAXBY' AS VARCHAR(20)) AS 'lst_updt_nm',

--  CONVERT(VARCHAR(10),CAST(WW_EDIT_DATE AS DATETIME),112)...

Hi,

Here is the code that I have to date for the view

SELECT 

 CAST('' AS VARCHAR(20)) AS 'cre_nm',

        create_date AS 'cre_dt',

 update_date AS 'lst_updt_dt',

 CAST('FLAXBY' AS VARCHAR(20)) AS 'lst_updt_nm',

--  CONVERT(VARCHAR(10),CAST(WW_EDIT_DATE AS DATETIME),112)...

The data is going into a table for presentation to an ETL process, I am merely creating a new view containing data from multiple tables. The target table requires a...

So would that be...

SELECT IDENTITY(int, 1,1), DESC, ID, DESC, POS1, POS2 INTO #TempTable

FROM <your query>

so How would I apply that to a view?

regards,

I am exporting the data from one database into a data warehouse, ideally I would like the sql script to create the unique ID's as the application will not touch...