Viewing 3 posts - 1 through 3 (of 3 total)
I'v run into the same issue where we had to generate Excel files and didn't have Office on the prod server. The way I was able to get around this...
June 4, 2004 at 11:35 am
#509064
After you have changed the recovery model and scheduled t-log backups, be sure to do a full database backup. T-log backups will not start till the db has been backed...
June 2, 2004 at 9:22 am
#508679
Hows this:
SELECT psno, CAST(REPLACE(REPLACE(REPLACE(psno, 'ab', '.1'), 'a', '.2'), 'b', '.3') AS float) AS sort_ordr
FROM temp
ORDER BY CAST(REPLACE(REPLACE(REPLACE(psno, 'ab', '.1'), 'a', '.2'), 'b', '.3') AS float)
May 11, 2004 at 3:16 pm
#506047