Regarding the use of the ^ in the formula, I did not look much further than what I had in the Excel formula.

Instead I concentrated on HOW to organize the...

And that was just a litteral translation ...

In SQL, G4 does not mean anything as already mentioned.

One much smarter way to go about it would be to use meaningful names...

Yup !

Here goes, not fully completed yet

[font="Courier New"]CREATE TABLE Fund

(

EntryName varchar(5) NOT NULL PRIMARY KEY,

Perf_Val decimal(4,2),

Result decimal(4,2)

)

INSERT INTO...

This is precisely what I am working on right now.

The Excel formula DOES work when fixing this typo

[font="Courier New"](PRODUCT(1+$G4;G$6/100)[/font]

By replacing the semi-colon character with a comma.

[font="Courier New"](PRODUCT(1+$G4,G$6/100)[/font]

Let me look at an SQL solution, I'll get back to you.

See more here Difference between predicates in ON clause vs. predicates in WHERE clause

Nice !

By the way, the Original poster still has not provided the table script, data entry script...

I meant the effect of a NULL in a WHERE clause, not in the JOIN clause.

Something like

select a.i, a.c, b.i

from a left join b

on a.i = b.i and a.c =...

Cast the output as CONVERT(VARCHAR(DesiredColumnWidthHere), long_column_name) AS long_column_name.

Interesting.

So I suppose this is more efficient than SUBSTRING ?

Regards

Mind you, I was talking about the Query Analyzer only.

"Are you Sarah Connor?"

I agree that for a team, a private jet MIGHT be justified, provided the the plane has the capacity for this. But, typically, this rarely happens.

Having said this, in the...

You are getting 128 dashes because that column has been declared as having a lenght of 128.

I can only suggest using [font="Courier New"]SUBSTRING(long_column, 1, 30) AS long_column[/font].

I cannot test it...

If I read your sql statement correctly

[font="Courier New"]

SUBSTRING

....(

........ISNULL(' , ' + a.DDS, '') + ISNULL(' , ' + b.DDS, '')

......+ ISNULL(' , ' + c.DDS, '') + ISNULL(' ,...

One reason why an INSERT or UPDATE does nothing without reporting an error is a WHERE clause that evaluates as false the conditions under which the staement should apply. It...

FWIW,

I tend to avoid *= like the plague.

Although more verbose, "LEFT OUTER JOIN" is, in my opinion, much easier to follow when reading a long script.

I would say, if you...

This, although revolting, is due to the sense of entitlement on the part of administrators and officers of a company.

The car auto executives who paraded in front of a Senate...