Database

Re: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

15-Apr-09 20:59

Well, the error says it all. You are using windows authentication on sql sever and trying to connect from an untrusted domain.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

ap_wooka27-May-10 10:11

ap_wooka

27-May-10 10:11

Thanks captain obvious, I don't think I would have know that without your astute insight.

Re: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

Ashfield27-May-10 23:09

Re: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

27-May-10 23:09

ap_wooka wrote:
Thanks captain obvious, I don't think I would have know that without your astute insight.

1. The error message was so obvious it deserved some sarcasm. It states quite clearly what the problem is,BOL tells you how to fix it, so why post here? Simple laziness probably.

2. What was your point in replying to a post over a year old that wasn't even yours in the first place - unless you are one of those morons who has multiple logins so you can answer your own questions and look good.

Bob
Ashfield Consultants Ltd

poparosa27-Oct-10 8:35

poparosa

27-Oct-10 8:35

So we found this thread with Google's search engine, Problem is that we do not know what "BOL" is, so please answer the question if you know the solution, or post a link where we can find it.

Thanks - we all appreciate it.

Re: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

liviucatrina13-Apr-10 4:24

liviucatrina

13-Apr-10 4:24

Hi!
Did you find a solution for this?

SQL IF statement

DBLearner15-Apr-09 8:31

DBLearner

15-Apr-09 8:31

We know there's conditional branching facilities in T-SQL and PL-SQL etc. Is there a similar IF clause available for use in flat SQL statements?

I can't use stored procs for certain restriction reasons, and my scenario is this.

I have one table, with columns [a, b, c, d, e, f]

I will pick rows, where column c = column d.

However, if column d is blank (null), then column e will be used for the comparison, if e is blank (null), then column f will be used for the comparison.

This is easy as pie in T-SQL, PL-SQL etc. Is there a way to do this in flat SQL statements?

Thanks.

Luc 64801115-Apr-09 8:47

Luc 648011

15-Apr-09 8:47

Hi,

you can use AND and OR operators and effectively build a WHERE clause that calculates this (pseudo-code):

c=d OR (d=null AND (c=e OR (e=null AND c=f)))

DBLearner15-Apr-09 9:00

DBLearner

15-Apr-09 9:00

Thank you! That was fast. Smile | :)

Luc 64801115-Apr-09 9:02

Luc 648011

15-Apr-09 9:02

You're welcome.

Smile | :)

Ashfield15-Apr-09 9:47

15-Apr-09 9:47

Yo can also use the CASE statement or (depending on exactly what you want) possibly the COALESCE statement in SQL Server.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

DBLearner17-Apr-09 1:08

DBLearner

17-Apr-09 1:08

Sorry if this sounds dumb, but I thought CASE decision making was only available on the procedure/function side, and not in flat SQL?

If not, can you point me to some sample flat SQL code with CASE usage demonstrated? That'll be very helpful.

Ashfield17-Apr-09 1:49

Any shorter way to total this?

17-Apr-09 1:49

You can use it anywhere, I'm not sure what you mean by Flat SQL - T-SQL is T-SQL, which runs trhe same in stored procs as out of them - the only execeptions are triggers and functions which are more restrictive.

select NonEoM = case <br />
when  [Receive side type] = 'floating' and [Receive Convention] = 'EOM' then 0 <br />
when  [Pay side type] = 'floating' and [Pay Convention] = 'EOM' then 0 <br />
else 1 end<br />
from table1

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Muammar©14-Apr-09 21:10

14-Apr-09 21:10

Hey everyone,
Just wondering if there's a better way to do this:

SELECT
SUM(LOOOOOOOOONG EXPRESSION) AS EX1,
SUM(ANOTHER LONG EXPRESSION) AS EX12,
SUM(LOOOOOOOOONG EXPRESSION)+SUM(ANOTHER LONG EXPRESSION) AS TOTAL
FROM SOME_TABLE

Can't it just be

SELECT
SUM(LOOOOOOOOONG EXPRESSION) AS EX1,
SUM(ANOTHER LONG EXPRESSION) AS EX12,
EX1+EX2 AS TOTAL
FROM SOME_TABLE

Anyway to make this possible??
Thanks!

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Giorgi Dalakishvili14-Apr-09 21:30

Giorgi Dalakishvili

14-Apr-09 21:30

CTE?

Giorgi Dalakishvili

#region signature
My Articles

Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^]

My blog
#endregion

15-Apr-09 0:03

Giorgi Dalakishvili wrote:
CTE?

Ok, I googled for Oracle CTE and I think you're talking about some Toolbox package, can you tell me what is it and why do you think it should help me??
Thanks mate!

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Eddy Vluggen15-Apr-09 0:28

Eddy Vluggen

15-Apr-09 0:28

I believe that Common Table Expressions are limited to SQL Server 2005 and higher. I don't know of any way to use the column-alias within the select statement itself.

I are troll Smile | :)

Re: Any shorter way to total this? [modified]

15-Apr-09 0:44

Ok, I'm sorry, I'm using Oracle and that's why I didn't come across this CTE thing, thanks anyways mate!

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Eddy Vluggen15-Apr-09 2:50

Eddy Vluggen

15-Apr-09 2:50

Sorry for not answering your original question properly! You can use the column-name aliases in the ORDER BY clause.

SELECT Column1, Column2, Column1 + Column2 AS Column3
  FROM (SELECT COUNT(*) AS Column1,
               MAX(COL#) AS Column2
          FROM COL$
       )

--edit--
It's impossible within a single SELECT, both in TSQL aswell as PL/SQL.
Enjoy Smile | :)

I are troll Smile | :)

modified on Wednesday, April 15, 2009 11:08 AM

15-Apr-09 10:36

Actually, I'm already doing this and was looking for a better way.
Thanks anyways mate!

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)