Viewing 15 posts - 736 through 750 (of 1,156 total)
thanks for the feedback on that, but doesn't
this do the same thing?
update myTable
set myCol = round(myCol, 10, 1)
No. The reason it is not the same is because when...
February 4, 2008 at 10:56 am
Can you connect to this server via SSMS using the IP and same credentials?
February 4, 2008 at 6:50 am
You have to use dynamic sql for this one.
e.g.
DECLARE @SQLString nvarchar(500),
@srv VARCHAR(25)
SET @srv = 'MyServerName'
SET @SQLString = N'
SELECT
invoicedate,
invoiceno,
invoicenet
FROM [' + @srv + '].TestPOS.dbo.invoice_header
'
EXECUTE sp_executesql @SQLString
February 3, 2008 at 11:24 pm
simsql,
You need to do a conversion and round to the nearest whole number. From your post it seems like have a E15 is your largest float. If it...
February 3, 2008 at 11:06 pm
You need to use the code like this:
SELECT
CAST(MyFloatColumn AS DECIMAL(11,2)) AS [Decimal],
MyFloatColumn AS [Float]
FROM MyTable
February 2, 2008 at 5:52 pm
You need to set your decimal percision correctly otherwise it will overflow as a general rule of thumb, you can count the digits to determine what you percision should be...
January 31, 2008 at 3:04 pm
I just did a test where I made an Excel spreadsheet with a column that contain numbers for the first half of the the file then text for the remainder....
January 31, 2008 at 11:12 am
I know you can change the data type. Have your tried changing both the "External Column" data type and the output column data type? You can use the...
January 31, 2008 at 10:57 am
I believe you may be experience something similar to this bug.
January 31, 2008 at 10:24 am
This link is for DAO OpenRecordsets. When you drop a Excel source in a dataflow task the connection string is OLE DB. Are you using the Excel source...
January 31, 2008 at 10:11 am
You could do something like this:
DECLARE @tbl1 table(
Col1 varchar(10),
dt varchar(15),
ti varchar(10)
)
declare @tbl2 table(
Col1 varchar(10),
dt datetime
)
insert into @tbl1
select 'test', '1/31/2008','11:00 AM'
insert into @tbl2
select 'test2','1/31/2008 11:30 AM'
select...
January 31, 2008 at 10:03 am
You can tell SSIS which data type to use for output. It doesnt have to automatically choose. You can right click the Excel Source --> show advanced editor...
January 31, 2008 at 9:48 am
I appreciate your suggestion. Unfortunately adding the | character to the format file parameter for the field simply makes the field delimiter a 2 character sequence of ;|
There is no...
January 30, 2008 at 7:58 pm
You will have to create a format file for the bulk insert. Inside the format file you will have to specifiy that after each semi-colon a "|" must exist,...
January 30, 2008 at 1:34 pm
And to clarifiy when I said it worked. I mean the backup file was deleted successfully.
January 30, 2008 at 12:30 pm
Viewing 15 posts - 736 through 750 (of 1,156 total)