Viewing 15 posts - 22,231 through 22,245 (of 26,484 total)
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
GilaMonster (2/26/2009)
Steve Jones - Editor (2/26/2009)
Bob Hovious (2/26/2009)
Sheep without a shepherd are prone to wander....
I'm just glad we have a consistent URL and I don't need to Google for this....
February 26, 2009 at 4:29 pm
I also wouldn't worry about posting a question that may have already been answered somewhere else on SSC. You will either get a direct response to your question, or...
February 26, 2009 at 4:24 pm
Steve Jones - Editor (2/26/2009)
Bob Hovious (2/26/2009)
Sheep without a shepherd are prone to wander....
I'm just glad we have a consistent URL and I don't need to Google for this. Not...
February 26, 2009 at 4:13 pm
(([ServiceDate]>='2009-01-01 00:00:00.000' AND [ServiceDate]<='2009-01-31 23:59:59.000'))
This will miss records with a datetime > '2009-01-31 23:59:59.000' and < '2009-02-01 00:00:00.000'.
The upper bound of this constraint really should be [ServiceDate] < '2009-02-01 00:00:00.000'.
February 26, 2009 at 4:09 pm
Viewing 15 posts - 22,231 through 22,245 (of 26,484 total)