Hey,

I would use a bit, because it maps nicer over to a boolean value than any other value.  For a radiobutton, I would think the same because you base it...

Hey,

Did you try possibly uninstalling the XP Service Pack 2?  Maybe that's a side-effect from that.  It did have a lot of issues with it.

Brian

Hey,

Don't think so; you could try splitting the queries into multiple values and concatenating them at the end like:

exec @SQL1 + @SQL2

But I don't think that will work.

Brian

Or left(field, 100)

Brian

Hey,

Yeah, the one thing that I should of mentioned but didn't, and that is present in Aaron's response is that for string values, you need to use '' to represent a...

Posted to http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=138740

Hey,

Are we talking about numerical data or text?  For an insert statement, you can do:

fieldname in ('10', '85', '13')

'10, 85' wouldn't work because that's assuming one value.

For numerical, remove the...

Hey,

I don't think you can do that, because I thought select into created a new table, which would need dbo or ddladmin rights.  Regardless select into would probably need insert...

Hey,

Well, one other thing your street address has the following suffixes shown above:

St

Ctr

Rd

Ave

There is a list of these suffixes (I believe) on the US postal services web site.  If you search...

Hey,

It has the potential to be a problem in the future...  Do you also trust the network staff too?

Brian

I guess I should add that if you could, it would be by putting a template in the model database.

I don't think so.....  I would save a template to a SQL file, and run it, then don't save it so you still have the original template.

Hey,

Try:

IF ISNULL(DTSSource("Field2")) Then

  IF DTSSource("Field2") = 0 Then

    'Do whatever

  End If

End If

Did you find where a end if or end function may be missing?

Brian

Hey,

It means there is no End If that it can find.  Make sure of that.

In addition, if you still have problems, it may be that you want to check null...

Hello,

I don't know of any TP tools, but with .NET that probably would be easy, what you could do is use the INFORMATION_SCHEMA.COLUMNS table to retrieve the database information, and...