Luis Cazares (9/26/2016)

---

drew.allen (9/26/2016)

---

xr280xr (9/26/2016)

---

I don't specifically care about short circuiting. I just need to only evaluate b if a is false and only evaluate c if a and b...

xr280xr (9/26/2016)

---

I don't specifically care about short circuiting. I just need to only evaluate b if a is false and only evaluate c if a and b are false. It's...

I was also wondering if instead of mutually exclusive you meant disjoint. Mutually exclusive means that you want to exclude the intersection of two sets, whereas disjoint means that...

xr280xr (9/26/2016)

---

I have a where clause with some mutually exclusive OR expressions. With a procedural language that allows short circuiting it would look like this:

a || b || c

The important...

The DELETE statement has two FROM clauses: one mandatory and one optional. The FROM keyword is optional in the mandatory FROM clause...

You haven't given us the definition of your function, you haven't given us sample data, you haven't given us expected results, and the code you've given us won't even parse,...

YES!! It is Friday!! Unfortunately, it's not Friday here, yet. :Whistling:

Drew

Do you want to store that expression or the results of evaluating that expression? If the first, then you're missing some single quotes. If the latter, then you...

The best option here may be the EXCEPT operator.

INSERT INTO [dbo].[ErrorLog_last48]

([EventDate]

,[ApplicationID]

,[SessionID]

,[ServerName]

,[Level]

,[Message]

,[StackTrace]

,[MetaData]

,[DateIn])

SELECT TOP 10000

[EventDate]

,[ApplicationID]

,[SessionID]

,[ServerName]

,[Level]

,[Message]

,[StackTrace]

,[MetaData]

,[DateIn]

FROM [dbo].[ErrorLogExport]

EXCEPT

SELECT

[EventDate]

,[ApplicationID]

,[SessionID]

,[ServerName]

,[Level]

,[Message]

,[StackTrace]

,[MetaData]

,[DateIn]

FROM [dbo].[ErrorLog_last48]

It's not clear which of your columns can be NULL, but EXCEPT will treat NULLs as...

This looks like generated code.

1. Extreme overuse of parens. NOBODY writes SUBSTRING([ID_NUM], (3), (20)) when SUBSTRING([ID_NUM], 3, 20) means the same thing, is easier to read, and takes...

The answer...

SQL Server add XML functionality to SQL 2005. This allows you to read/create XML fragments. The FOR XML tells SQL Server that you want to create an XML...

Part of the problem is that you are reading the same table twice when you only need to read it once. I've rewritten this to use a CROSS APPLY...

Also, the ELSE clause within your CASE statement is missing an expression, and your CASE statement is missing an END.

Drew

There are several issues here.

1) By default, SQL Server is case insensitive. Unless you've overridden these defaults, the two subqueries are going to return the same results.

2) You say that...