You could define a computed column with the formatted user...

rmattaway (3/13/2009)

---

One method used by my employer is what we call the window of time. It was decided that everyone in our databases could not be older than 120...

Another key advantage of normalised databases is that they can easily enforce referential integrity.

(e.g. A 'class' must have one 'teacher').

These constraints can be harder to enforce in a denormalised design...

siewlian908 (3/11/2009)

---

the report is working as following.

1. User enters a large number of ocmi.name values in a form. It is about 300 ocmi.name is used to build the form.

2. These...

Just to make sure I understand, the report works something like this:

1. User enters a large number of ocmi.name values that they want displayed

2. These are stored in a vb.net...

To answer Q1:

Your code:

Param_Value =

case when valuetext is null then value

else valuetext end

can be implemeted...

ian.f.scott (3/2/2009)

---

Jack,

I checked the BOL entry you provided (http://msdn.microsoft.com/en-us/library/ms156493(SQL.90).aspx)

I have been through every setting I can find on both Reporting Services server and the server my database is...

tung (2/25/2009)

---

I've got a textfield for gross margin percent, and I have the value set like this:

=IIF(Sum(Fields!sales.Value) <> 0,(Sum(Fields!sales.Value)-Sum(Fields!cost.Value))/Sum(Fields!sales.Value),0)

The intention is to use the value 0 if the sum of...

You may have to request it from someone who does:)

brewmanz (3/3/2009)

---

SQL Server should act like a Finite State Machine, to be able to predict its...

raymond lew (3/3/2009)

---

I am glad to see so many people getting this right. And for 3 points!

It certainly does not operate according to how I expect things to work....

Please post your question with examples in a SSIS forum - i.e. http://www.sqlservercentral.com/Forums/Forum148-1.aspx

The article Forum Etiquette: How to post data/code on a forum to get the best help at http://www.sqlservercentral.com/articles/Best+Practices/61537/...

SET FMTONLY generates metadata using the structure of the query - metadata can be derived from the types of constants, columns, or expressions.

In the case of stored procedures, which aren't...

You might want to try posting your question in a more appropriate forum.

A clearer question could also attract more answers.

(For example, are you talking about SQL Server views or queries,...

This is a double (actually quadruple) post.

Please respond here http://www.sqlservercentral.com/Forums/Topic652704-338-1.aspx