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.

Try calling the package in the Job Step by Name instead of the GUID.  Use the following syntax:

dtsrun /S servername /E /N PackageName /M password

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...