Yep, if in Query analyzer then set your options.

Tools --> Options --> Results Tab- Maximum Characters per columnt: 8000

But I doubt this is the issue.

Without sample data and table definition,...

Stupid is as Stupid does.

How about a create table statement for [view_machine_hours]

and some example data, and what you want the results to look like.

http://www.aspfaq.com/etiquette.asp?id=5006

Now your thinking outside the box.

Not sure how big the box is though.

A good question indeed.

A new table for each day of the week right?

Thats about the only reason I can think of.

He is using CommandType.StoredProcedure.

cmdSave = New SqlCommand("Test", GlobalConnection)

cmdSave.CommandType = CommandType.StoredProcedure

parmReturnValue = cmdSave.Parameters.Add("RETURN_VALUE", SqlDbType.Int)

parmReturnValue.Direction = ParameterDirection.ReturnValue

cmdSave.Parameters.Add("@UserID", lvUserID)

cmdSave.Parameters.Add("@test", TextBox1.Text)

GlobalConnection.Open()

cmdSave.ExecuteNonQuery()

GlobalConnection.Close()

To do it this way you do need...

Are you sure you are restoring it to the correct server, and the name your trying to restore it as does not exist.

How are you restoring, with enterprise manager, or...

Or

CREATE PROCEDURE SP_NEXTUSER @NEXTUSERNUM smallint OUTPUT

AS

--ME REGRESA EL SIGUIENTE NUMERO MAS PEQUEÑO DESOCUPADO PARA UN USER_NUMBER

-- EJEMPLO SI TENGO DADOS DE ALTA 1,2,7,21... ME REGRESARIA UN...

I see this alot, people need Dynamic sql to solve problems where they are trying to build an application so obscure that there is no known values.

If you try to...

I told the dude before I started helping him that his schema was crap, and he needed to do some table modeling.

No he's trying to pass in a comma separated list of integers.

He's got a poorly defined schema, where "Fields" for a virtual table are defined as rows in a table, and values...

Your going to also have issues here

This will always return all field ids

SELECT @SqlString = coalesce(@SqlString,'')  + ' min(case B.FieldID when ' + ltrim(Str(A.FieldID)) + ' then Response end) as...

I created a table variable and inserted some records so I could run the query to test for the correct results

http://www.aspfaq.com/etiquette.asp?id=5006

First of all what is the colation set for the field on that table?

Default is SQL_Latin1_General_Cp1_CI_AS

Meaning Latin, General, CI = Case insensitive, AS = Ascending Sort If this is the...

Try this.

Your missing the ' around the Character fiedlds your trying to insert

When your having issues with dynamic sql,comment out the execute, and put a select statement prior to execution...