ooops! Sorry misread the data

If the data contains many tables than put code in a loop processing each tablename using a cursor

OK I will elaborate on my answer in the other post here.

Create a DTS package to

1. Create a fixed named table (eg IMPORTTEXT)

2. Import the text file to IMPORTTEXT

3. Extract the...

Deja Vu

Is this is related to the other post?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=159281

In addition to Antares, when you found the text file name, import the data into a fixed table name, validate the data and if OK use sp_rename the rename the...

Ryan,

The vunerability is not definate but in the variability of what is passed. If there is no possibilty of free text then the vunerability is minimal however any single field...

Dynamic sql (as well as Ryans solution) is vunerable to sql injection. Many posts on this site cover this. If this is acceptable then building the query in or out...

Here you go

Sub Auto_Open()

    Dim SQL

    Dim r As Integer

    Dim c As Integer

    Dim i As Integer

    Dim OldBook As Workbook

    Dim NewBook As Workbook

    Dim Conn As ADODB.Connection

   ...

I create hidden spreadsheet in a workbook with a macro that automatically starts when the workbook is opened and creates a new workbook, populates it with the data and closes the...

Try using

set @frm='Select Area_code, years,Sex,Marital_Status From Population'

and

set @bcp = 'bcp "' + @frm +

' where Area_code = ' + CAST(@i as varchar) +

'" queryout "D:\Temp\' + CAST(@i as...

This is the format you want

"INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database='" & App.Path & strWBName + "', [sheet1$]) (col1,col2,col3) SELECT col1,col2,col3 FROM TEST.dbo.Testing'"

Note that the spreadsheet must exist and have columnheaders in...

No need to apologize Noel

Besides, made me look again to make sure though

More Coffee the...

I beg to differ, this an insert trigger, the timestamp in the inserted table will be the same as the row inserted in the actual table.

Removing the first comma from the EXEC statement seems to have done the trick.

Correct.

The update works fine when I tested it. Are you sure you have matching field1 and field2 in [othertable], if not then not update will be made

I do this

 STUFF(STUFF(RIGHT('000000' + CAST(run_duration AS varchar(6)),6),5,0,':'),3,0,':')