table , table [transaction]

or

table tuser, table ttransaction

the t prefix helps when it comes to some common reserved words.

I don't mind using t and v as prefixes on tables and views,...

I just got swamped, I was meaning too, and so on...

Finally searched through my gmail 🙂

Thanks for the help Jeff, it was not my intention to delay this much.

And I...

Hi guys,

I am just dropping by to give a very belated thank you to everyone on this thread.

We implemented:

UPDATE t(HOLDLOCK,ROWLOCK)

WHERE ...

IF @@ROWCOUNT = 0

BEGIN

INSERT t

WHERE NOT EXISTS(SELECT * FROM t(HOLDLOCK,ROWLOCK)...

Hi,

There still are issues, but we are going to oversee the whole process.

There is plenty of room for improvements

As to EXIST or NOT TO...

 Like this:

 KEYWORD COLUMN| SEP |CODE COLUMN

                             |       |

                  SELECT|       |col1

                     FROM|       |theTable

                             |       |

Sorry about all the formatting Jeff

I just opened the topic in INTERNET EXPLORER, which...

You are a real formatting fascist 🙂

It gave me an idea for an editor that has 3 fields,

where the first one is CAPITALIZED by default and right-aligned,

the middle one is...

Thanks for all the input Jeff!

and yes, the original proc can be coded more efficiently 😉

"if you do put an explicit transaction in the proc, you must do error checking...

Wow thanks Jeff!

That quite some reply :-), and I am very happy!

Great points, I will rewrite the proc for better upsert - processing logic with some of the modifications you...

I'd love to format the post better, how is that done ? 😉

Other sql soduko's:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50372

Nice job David P. 🙂

rockmoose

Hi fellows,

I am having a similar problem. I can develop and deploy AS projects. In the business intelligence studio I can browse dimensions. But when trying to browse a successfully processed...

Very good and interesting article

Thanx.

Yup, nice and slick.

And bcp is a great tool.

Hi,

I tried to do this in 1 select, and this is what I came up with,

there is probably room for improvement but seems to work

By using bcp. ( see BOL for this )

There was a discusiion here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=44176