Viewing 15 posts - 16 through 30 (of 35 total)
Yes! That worked. Thanks for the assistance.
August 23, 2005 at 8:01 am
Let me be a little more specific about the issues we're facing:
The application will be...
August 8, 2005 at 10:02 am
"I think there are definitely some great leaders and those that build companies. But lots of business is luck, it's timing, it's taking advantage or being able to take...
August 2, 2005 at 11:33 am
"So stop paying the CEO's so much money. They're not the reason for the company succeeding."
I agree in part and disagree in part. Yes, there are a number of business...
August 2, 2005 at 9:39 am
That appears to be the issue. I found this article on Microsoft Support:
http://support.microsoft.com/default.aspx?scid=kb;en-us;247527
Unfortunately, this solution only applies to delimited text files, not Excel spreadsheets. Maybe I could export to...
May 2, 2005 at 11:26 am
What Transaction Isolation Level are you using?
I found this on Microsoft Support:
http://support.microsoft.com/default.aspx/kb/815008
Also what service pack is installed on your instance?
I found this article about a situation similar to...
April 30, 2005 at 10:56 am
It all makes sense now. Thanks noeld.
The developer reported that only one column, Zone3Price, was converting incorrectly. This didn't make sense to me, because the conversion was supposed to be...
April 18, 2005 at 11:24 am
The code is part of a DTS package. As you can see, I'm taking the value from the text file and dividing it by 100:
'**********************************************************************
' Visual Basic Transformation Script
'************************************************************************
' Copy...
April 18, 2005 at 9:22 am
Okay, that was easy enough. Thanks!
January 6, 2005 at 8:45 am
Yes, I successfully inserted the exact same data with a standard INSERT statement. I decided to abandon the Bulk Insert approach for this load. I need to do other transformations to...
October 26, 2004 at 9:27 am
Moderator:
Please move this post to the SQL Server General forum. I clicked the wrong link when I created this post.
October 7, 2004 at 8:26 am
Thanks Frank, I got another variation from someone in my office:
Select @SQLCmd3 = 'where name = ''' + @DatabaseName + ''''
Glad you like my signature, Thomas Sowell is one of...
March 4, 2004 at 1:45 pm
Okay, I'm trying Frank's approach again. Now I'm having trouble writing a dynamic sql statement.
Here is the code:
Declare @DatabaseName varchar(50)
Declare @ServerName varchar(50)
Declare @SQLCmd char(29)
Declare @SQLCmd2 varchar(125)
Declare @SQLCmd3 varchar(61)
Declare @SQLCommand varchar(215)
Select...
March 4, 2004 at 1:25 pm
Frank:
I was originally thinking of doing a direct query from sysdatabases as you do here, but it was difficult getting the values for all possible combinations of options. I may...
March 3, 2004 at 8:31 am
Here's the complete table design:
CREATE TABLE dbo.Databases (
ServerName varchar(50) not null,
DatabaseName varchar(50) null,
DatabaseCreationDate datetime null,
SQLVersion varchar(4) null,
DatabaseSize int null,
ANSINulls bit null,
ANSINullDefault bit null,
ANSIWarnings bit null,
ArithabortEnabled bit null,
AutoClose bit null,
AutoCreateStatistics bit...
March 3, 2004 at 8:26 am
Viewing 15 posts - 16 through 30 (of 35 total)