Asking Email Address Up David Portas and Erland Sommarskog

Dear Mr Portas and Mr Sommarskog,

Cause I am a newbie in sql, can I ask for your email address?

My email Address is mike@.ptmb.com

Thanx

Best Regards

Michael

--
Message posted via http://www.sqlmonster.comI would prefer to answer requests for help in the groups rather than by
email. Please do post your questions to the newsgroups so that everyone can
share the discussion and learn from it. I can't guarantee to respond
promptly to email but if you post here others may be able to give you a
quicker or better answer.

My disguised email address is in my message header. Just take out the
REMOVE_BEFORE_REPLYING_ prefix. Most of us don't post a plain email address
because spammers collect addresses from newgroup posts.

--
David Portas
SQL Server MVP
--|||Michael Teja via SQLMonster.com (forum@.SQLMonster.com) writes:
> Dear Mr Portas and Mr Sommarskog,
> Cause I am a newbie in sql, can I ask for your email address?

It happens that people mail me SQL questions, and I try to answer.
However, it's always better to ask question in public forums, rather
than mailing an individual. If you post to a newsgroup, there are more
people who see the question, and who may know the answer. If you mail me,
say, a DTS question, you are only wasting your time, because that's area
that I have no knowledge about. Furthermore, the person you mail, may be
away, so you will have to wait for the answer.

And one thing you definitely not should do is to mail more than one
person, because that means that several of us might spend our time
answering the same question.

Finally, another advantage with posting to a public forum, is that
other people who have the same problem might see the question and
answer and benefit from that.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||As great as David Portas and Erland Sommarskog are( and they have helped me
greatly).

I'd like to think that I can offer something as well.

The whole is greater than the sum of the parts.

"Michael Teja via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:37a558fbb2c645dba637d06eb0419173@.SQLMonster.c om...
> Dear Mr Portas and Mr Sommarskog,
> Cause I am a newbie in sql, can I ask for your email address?
> My email Address is mike@.ptmb.com
> Thanx
> Best Regards
> Michael
> --
> Message posted via http://www.sqlmonster.comsql

Array in expression editor anyone?

I'm kind of a newbie at all this and I'm wondering if I can do the
following. Whithout having to use custom code is there a way to use the IN
function in the expression editor?
I'm currently using the following to accomplish something quite simple:
=IIF((month(Fields!por_POSTING_DATE.Value) = 10 or
month(Fields!por_POSTING_DATE.Value) = 11 or
month(Fields!por_POSTING_DATE.Value) = 12), True,False)
I'd like to use:
=IIF(month(Fields!por_POSTING_DATE.Value) in (10,11,12),True,False)
Can you not use an array in the expression editor (and only in custom code?)
Thanks,
RyanHere's one way to do it:
=iif(Array.BinarySearch(new Integer() {10,11,12},
month(Fields!por_POSTING_DATE.Value))>=0,True,False)
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Ryan Opfer" <ropfer@.usa.ibs.org> wrote in message
news:evyaKVzeEHA.2352@.TK2MSFTNGP09.phx.gbl...
> I'm kind of a newbie at all this and I'm wondering if I can do the
> following. Whithout having to use custom code is there a way to use the
IN
> function in the expression editor?
> I'm currently using the following to accomplish something quite simple:
> =IIF((month(Fields!por_POSTING_DATE.Value) = 10 or
> month(Fields!por_POSTING_DATE.Value) = 11 or
> month(Fields!por_POSTING_DATE.Value) = 12), True,False)
> I'd like to use:
> =IIF(month(Fields!por_POSTING_DATE.Value) in (10,11,12),True,False)
> Can you not use an array in the expression editor (and only in custom
code?)
> Thanks,
> Ryan
>|||Thanks Chris that worked great.
Ryan
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:%23OSa8%23AfEHA.3612@.TK2MSFTNGP12.phx.gbl...
> Here's one way to do it:
> =iif(Array.BinarySearch(new Integer() {10,11,12},
> month(Fields!por_POSTING_DATE.Value))>=0,True,False)
> --
> This post is provided 'AS IS' with no warranties, and confers no rights.
All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No
user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach
of
> children under 3.
> "Ryan Opfer" <ropfer@.usa.ibs.org> wrote in message
> news:evyaKVzeEHA.2352@.TK2MSFTNGP09.phx.gbl...
> > I'm kind of a newbie at all this and I'm wondering if I can do the
> > following. Whithout having to use custom code is there a way to use the
> IN
> > function in the expression editor?
> > I'm currently using the following to accomplish something quite simple:
> >
> > =IIF((month(Fields!por_POSTING_DATE.Value) = 10 or
> > month(Fields!por_POSTING_DATE.Value) = 11 or
> > month(Fields!por_POSTING_DATE.Value) = 12), True,False)
> > I'd like to use:
> > =IIF(month(Fields!por_POSTING_DATE.Value) in (10,11,12),True,False)
> >
> > Can you not use an array in the expression editor (and only in custom
> code?)
> >
> > Thanks,
> >
> > Ryan
> >
> >
>