Create a File called export.csv with the same columns.

Create a DTS Package with a datapump task that will pump the various files from your client into the export.csv file.

Use...

I would imagine that 1 Function call is faster than 2.  I'm glad you've got a fix.

Are the values in order in the table.  If so, maybe there is a key column you can sort off of.

The 1E2 is a float data type and will not convert to an integer.

Try:

Update Table Set IntegerField = Convert(int, Round(VarCharField,4))

Let me know how it goes.

Its also a good idea to Save your DTS Packages as Structured Storage Files and Store in a Code Vault such as Visual SourceSafe or StarTeam.

If it does turn out you need to do it in ActiveX script, here you go:

'**********************************************************************

'  Visual Basic ActiveX Script

'************************************************************************

Function Main()

 x = DayOfQuater(now())

 msgbox x

 Main = DTSTaskExecResult_Success

End Function

Public Function DayOfQuater(dtDayInQuarter)

Dim...

You can use:

SET DATEFORMAT mdy

This doesn't affect the way the date is stored in SQL server, only how it is displayed. 

Also you can use,

convert(varchar(10),getdate(),101) = convert(varchar(10),'07/15/2004',101)

Unicode constants are specified with a leading N: N'A Unicode string'.

Unicode supports a wider range of characters

You will probably have to run your Select query prior to performing the insert and do your variable assignment here.

For example:

Declare @TestGradeValue smallint

Select @TestGradeValue  = TestGrade

FROM

(

SELECT

     AD.TestGrade,

From tblADRawAnswerData AD

Cross...

Try this:

Alter Procedure MM_G1_SFMath_A_EOY_AUTO_sp

@ProcessPermnum varchar(12),

@ProcessTestShortName1 nvarchar(8)

AS

Declare

@TSName1 as nvarchar(8),

@TestGradeValue smallint

Set @TSName1 = @ProcessTestShortName1

Insert tblMMStanTestScores

(Grade, TestShortName, Permnum, QID, QNum, NullChk, Score, CA, SA)

Select 

@TestGradeValue = TestGrade,

TestShortName = @TSName1,

Permnum,

QID,

QNum,

CASE

WHEN SA...

Thanks, Rene, ALL.

This solution should work nicely.

P

Hi Robert,

Local Temp Tables are session aware.  So If each user has a unique session then it shouldn't be a problem.  However, If you are using COM objects in the...

The values are in multiple columns in a table.  I need a function that compares multiple values and determines the max value.  I know I'll probably end up writing my...

You will likely have to look at the data from your source before import to see why there is errant data.  But first you might try importing the data into...