Viewing 15 posts - 22,231 through 22,245 (of 26,490 total)
John Erdovegi (3/2/2009)
I always trust computers more then stupid humans.Computers listen to me and don't take bribes.
Even good governments can go bad or get worse.
Unfortunately, computers are programmed by humans,...
March 2, 2009 at 12:14 pm
You're welcome and thanks for the feedback.
March 2, 2009 at 11:51 am
What they are saying is that it takes planning and design work up front in your application to achieve. I don't think it is something that is easily done...
March 2, 2009 at 10:22 am
Not really sure. I understood the question well enough to answer it and get it right.
March 2, 2009 at 10:17 am
I assume you are asking if the SQL Server instance is using Integrated Security or not, here is a simple query to accomplish that:
select serverproperty('IsIntegratedSecurityOnly')
1 = Integrated security
0 = Not...
March 2, 2009 at 10:08 am
GilaMonster (3/2/2009)
Lynn Pettis (3/2/2009)
You gave the OP EXACTLY what he asked for in his post.
Nope. Barry's solution equates to IIf([x]="YEN","JPY",IIf([x]="EURO","EUR",NULL)) , ie
If X = 'Yen' then 'JPY' ELSE If...
March 2, 2009 at 9:36 am
RBarryYoung (3/2/2009)
Lynn: Thanks, but as Gail pointed out, I was not entirely correct.
Edit: Said "was", should have said "was not". slight...
March 2, 2009 at 9:23 am
gyessql (3/2/2009)
cast(cast('dd-mmm-yyyy' as smalldatetime) as nvarchar(11))
select cast(cast('21-jan-2009' as smalldatetime) as nvarchar(11)) use_cast,
convert(nvarchar(11), '21-jan-2009', 106) use_convert
which outputs:
use_cast ...
March 2, 2009 at 9:20 am
RBarryYoung (3/2/2009)
Hmm, I think it's this:
CASE x
When 'YEN' Then 'JPY'
When 'EURO' Then 'EUR'
End AS InvCurr
At...
March 2, 2009 at 9:13 am
Have you looked up CASE in BOL (Books Online)?
March 2, 2009 at 8:49 am
gyessql (3/2/2009)
cast(cast('dd-mm-yyyy' as smalldatetime) as nvarchar(11))
Nope.
convert(nvarchar(11), x, 106)
March 2, 2009 at 8:41 am
Have you tried looking up CONVERT in BOL (Books Online)?
March 2, 2009 at 8:37 am
Dean Jones (3/2/2009)
I have tried the index with the INCLUDE statement, and although it doesnt seem to make much diffrence to be honest, in fact when used in the...
March 2, 2009 at 5:58 am
Viewing 15 posts - 22,231 through 22,245 (of 26,490 total)