I C.

Tx.

Why do you use dynamic sql anyways?

That can't be the full code????

Anyways this works :

Declare @Exec as varchar(100)

set @Exec = 'select ''' + convert(varchar(20),getdate(),106) + ''''

exec(@Exec)

I'm surprised nobody answered this one faster :

--I use this table for many other string operations as well

CREATE TABLE [Numbers] (

[PkNumber] [int] IDENTITY (1, 1) NOT NULL ,

CONSTRAINT [Pk_Number]...

Forgot to add this :

You need the microsoft common controls 6.0 reference. Then check the toolbox for the extended list of available controls (toolbox icon) : Microsoft listview...

Please search the net before asking questions like that :

http://abstractvb.com/code.asp?A=712

If you prove he's wrong then I think you get the job .

I think you'd be better off using a listview to show the results... You could populate it for any query since you can dynamically add columns.

There's none really. Functions are meant to either return a table or a scalar value. Sp can do the same thing but they can't be used in a...

Depends how you use them... this is really where you make the choice. The server will still optimize the query equally in each object.

Did you have a case scenario...

The error should still be clearer than that.

You guys need to pay attention :

Category = HUMOR. Stop thinking rationally when you see this .

Will be simpler for me to do the package... give me a few hours, I have something else to do first.

Now I would call that a bug .

Thanx for the info.

Yes it does. If you read correctly I have a : for each field in myrs.Fields()

This will work if you have 0 to X nullable columns and...