Good to see the humour working it's way in.

Another thing I think adds to the subject is the abality to correct (or be corrected) without taking offense.

On another thread, I...

quote:

---

Crispin,

I think I understand the ## designation differently. As far as I understand, putting ## before the table name designates that,...

Best way I can see. Must be a cleaner way. I would like to know if anyone does know a better way.

 

ALTER Procedure CPTest

as



If...

Another way would be to use the OR method (Better name?)

Select * From xx Where

(Col1 = @param1 OR @Param1 Is Null)

and (Col2 = @param2 OR @Param2 Is Null)

If any of...

A temp table lives and is unique for each connection. When the query goes out of scope SQL cleans up after you. (Deletes any temp tables.)

If you want the temp...

You could use BULK INSERT (That seems to be my solution for a lot of things) or BCP to insert it into a text field as plain text.

Problem is it...

Does the table exist? Before you do the insert, try select * From #Test.

Are you creating the table and the building up a string with the insert syntax?

If so, this...

What actually timed out? ASP or SQL?

If it was ASP script timeout then the reason was because ASP was waiting for to long (15 minutes default) before getting a respone.

Increasing...

Nope, you gonna have to use EXPLICIT.

It was confusing for me as well. Once the lights get turned on, it became quite easy.

It's extremely powerfull!

Have a look at the exqamples...

The problem you have there is lack of a root node. Not to serious though.

To get exactly what you want, have a look at EXPLICIT. You can do it with...

You can also use BULK INSERT (Which is rapped by BCP) from within script of a proc.

See BOL for help on that. Works well and fast.

Cheers,

Crispin

I take one day off and the thread turns serious....

Cheers,

Crispin

lol. The rugby lives on...

You can use AUTO, ELEMENTS.

What you do need to add is an alias for your table.

If you want to change the element and or attribute...

Greetings.

One of the guys here has created an app which generates all the common procs for you.

You give it a DB and tell it you want the inserts or deletes...

Here is the ultimate time filler game!

http://www.superliminal.com/cube/cube.htm

Download the NT version. The file name might be truncated...

Cheers,

Crispin