In this situation where there is a minimal difference in with and without the variable on submit I personally prefer Steve's code with a twist.

---------Call this...

This is called a pivot table.

If you know the number of items you are going to pivot then it is as simple as

SELECT

ItemNum,

SUM(CASE Store WHEN 1 Then Traited ELSE 0...

Also, try running the query a couple of time, the provider doesn't always give the return error. Then finally can you post an example of what is failing, since you...

I would have also added the difference in cost between and Oracle developer and a SQL developer for ongoing maintainence which can cause a TCO (Total Cost of Ownership) blowup.

...

It comes from Robert Heinlein's classic "The

Moon is a Harsh Mistress"

"There Ain't No Such Thing As A Free Lunch"

or

TANSTAAFL

Or something like this where you can also control rounding.

create function dbo.fn_format (@value numeric(38,1))

returns varchar(200) as

BEGIN

declare @string as varchar(200)

if @value >= 1000000

set @string = replace(rtrim(replace(cast((@value / 1000000) as...

Overall the performance should be the same but you are wasting 3 bytes per row of data so always use the simplest value. If you think you may expand the...

Guess I should have looked that up myself first (ooops). Anyway the answer is still no.

I just tested it myself and got the following

"INSERT statement conflicted with COLUMN FOREIGN...

Self-Contained Underwater Breathing Apparatus

I bet you knew that and just wanted to test me.

And as for how to pronounce. Afraid not since he is right either way and if you...

Ok, after a bit of research the only way to fix up the system tables is using sp_fixindex (or at least the code in the Proc). But you have to...

First off the code won't run as is since Table t1 requires that table t2 exists and vice versa. So you have to create the table then alter the table...

It is a personal preference on what is right but Sequel is the same as S Q L just said as a word kinda the way you say SCUBA instead...

If occurrs again I would definently check the MS KB site again at that time and if nothing related give them a call or email depedning on the urgency. Let...

I have to agree also. Could you post your current DDL for your table and exaplin a bit about the system? Is this a datamart?

But whatever works best and does accomplish the task is the better answer. So hopefully for Crispin yours fully meets his needs as it does provide a faster output. But...