Well except for any details about how you split your string. That is the root of where...

btull89 (7/28/2011)

---

I could add an order column, and I have a split string function that I use. When I split the string how do I assign it a value for...

If you want results in a certain order you have to use an order by. Looking at the very sparse bit of information you have provided it does not seem...

Have you looked into SSIS? It can do this kind of stuff really nicely, all wrapped up in a slick package with bows and ribbons.

Didn't exactly follow your description there but to get the first 20 characters just use Left([filename or variable], 20).

If you need to save this to a table just change the select to an insert.

Here is a generic template.

create procedure blah

(

@parameter1 int,

@parameter2 int

) as

begin

select MyCols from Table1

join Table2 on Table1.ID = Table2.ID

where MyVal1 = @parameter1 and MyVal2 = @parameter2

end

You want to receive a parameter and retrieve data from a current table based on what they passed in?

You also have the "increment" be a negative number in sql. Set your identity seed to a large number (10,000) and the increment value to -1.

First record will be 10000

next...

Maybe if you explain...

be careful with this. For this to provide any useful information you need to make sure this select will return ONLY 1 row.

SELECT

@Codarticolo = [SomeField1],

@codlotto = [SomeField2],

@giacenza = [SomeField3],

@datamodificalotto =...

The BEST solution BY FAR is to use proper datatypes. Don't store datetime data in a varchar column. It is frought with errors and has been the topic of so...

Just create a variable to hold your primary key.

declare @MyID int

Then add the column to your select statement.

select [file name], MyID FROM [Actions Open] WHERE [MAIL] LIKE '' AND [File...

You can have both running on the same box. The installer will find 2005 and ask if you want to replace it or create 2008 as a named instance. If...

You have 4 parameters inbound (3 of them are output). The body of your procedure doesn't actually do anything. You create a temp table and populate it with the values...