Thanks for clarification Baskar. Will try monday & post back.

Cheers

Try this article

http://msdn.microsoft.com/en-us/library/ms137656.aspx

Thanks Baskar - If i understand correctly - run the create table in the SSIS data destination then copy the resuting tab and make changes to the copy.

I'll try...

Have you used SSIS?

Try looking at PIVOT & UNPIVOT in BOL, you would then have to concatenate the resulting columns into one.

I'm guessing this is for display purposes so the cocatenation would be...

Sounds like you already have a load method and you just need to get the files, I would...

Some would say presentation is not the function of T-SQL but in the real world you could try something like this

SELECT CONVERT(VARCHAR(50),CURRENT_TIMESTAMP,113)

You could get closer to your requirement by concatenating...

Hi,I think you could use select... into ... because your column names are all unique. Something like this.

select

T1.column1,

T1.column2,

T3.column3,

T2.column4,

t2.column5,

T1.column6,

T3.column7,

T4.column8

into

NewTable

from

table1 T1, table2 T2, table3 T3,...

Yes - that was it!

Another lesson learnt.

Thanks - I'm getting a return code of 1. If I omit the @query parameter I get a return code of 0 and the email is sent OK.

What does...

Hi elutin,

Code is below (a bit messy but a work in progress)

I don't see the mail queued message because the sp_send_dbmail is in a stored proc. Interestingly running the...

Something like this.

ALTER TABLE tblA

ADD Class NVARCHAR(150) DEFAULT 'Some value'

Obviously we nat have 30th Feb so the business logic has to change. I would suggest trapping February and if End Day > 28 then End Day = 28 (and...

Thanks Willem, as usual I didn't see the error because I was looking in the wrong place!

Cheers

Allen

Hi

I'm still struggling, I don't understand how to calculate the divisor to get to the right units. Below is wrong but I cant see why..

DECLARE @myTest tinyint

-- v1 left 2...