Viewing 3 posts - 1 through 3 (of 3 total)
This is good to generate an initial cut of the SQL code that I will then use at the start of my SSIS package to create the staging tables if...
January 12, 2012 at 7:21 am
Just a few things.
1. The script stops coping when the copy from schema comes up as the target, so as written it you would end up with the stored proceure...
August 31, 2011 at 7:16 am
You can use a function to reformat the data as a string.
The function could look like
create function MoneyToFixString(@InValue Money)
returns varchar(30)
as
begin
declare @TempValue varchar(30)
set @TempValue = CONVERT(varchar(30), @InValue, 1)
return '$' + substring('...
June 24, 2011 at 6:59 am
Viewing 3 posts - 1 through 3 (of 3 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy