Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO #RECORD AS
- SELECT
- RIGHT('0000000000' + RTRIM(field01), 10)
- +RIGHT(' ' + RTRIM(field02), 10)
- +RIGHT('00000' + RTRIM(field03),6)
- + etc ...
- +RIGHT('0000000000' + RTRIM(fieldnn, 10)
- FROM sourceTable
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement