Just remove the arbitrary opening parenthesis

😎

CREATE VIEW abcd AS

SELECT

a.description,

a.corporate_tag,

a.corporate ,

a.banner_tag,

a.banner,

a.region_tag,

a.region,

a.division_tag,

a.division,

a.hierarchy_level,

a.load_id,

a.process_name,

a.loop_id,

( case WHEN b.corporate_tag IS NULL or b.banner_tag IS NULL THEN 'I' Else 'U' END )

/* or ( case...

Missed the 21 days:-P

😎

AppDetails.DateDetailDisposed BETWEEN CONVERT(DATE,DATEADD(DAY,-25,getdate()),0) AND CONVERT(DATE,getdate(),0)

Note, convert...

Slightly different approach from JLS's

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

DECLARE @SAMPLE_DATA TABLE

(

column1 NUMERIC(12,2) NOT NULL

,column2 NUMERIC(12,2) NOT NULL

);

INSERT INTO @SAMPLE_DATA(column1,column2)

VALUES ...

Use DATEADD

😎

AppDetails.DateDetailDisposed BETWEEN DATEADD(DAY,-25,getdate())...

pietlinden (9/14/2015)

---

I looked there, but didn't see a link to download, so that's why I asked here. He explains the patterns, but without the database they're working from, I...

pietlinden (9/14/2015)

---

I'm reading Ferrari & Russo's DAX Patterns 2015 book, which is great, but I'm wondering about one thing... where is the database they're using for their examples?

I just find...

Wayne West (9/14/2015)

---

Matt Miller (#4) (9/14/2015)

---

Eirikur Eiriksson (9/14/2015)

---

Jeff Moden (9/14/2015)

---

Eirikur Eiriksson (9/13/2015)

---

Using heap to speed the inserts is like a very bad Credit Card deal, no transaction fees but X000%...

nightowl23 (9/14/2015)

---

i am modifying a SSIS package which contains SQL task, a dynamic query, and set the query as output parameter, it used to work last week, but today it...

christine 23290 (9/14/2015)

---

I am trying to get this to work without having to write a cursor or something like that. I think it should be able to be done...

zzzzcarl (9/14/2015)

---

Thanks to Eirikur and GilaMonster for your answers, which has helped me a lot.

I thing the problem is solved. Now I have had 2 succesfully start of the...

No, the compatibility level does not affect newer functionality.

😎

This will run...

Animal Magic (9/14/2015)

---

Hi All,

I was hoping someone could help me out with an issue which has been frustrating me this afternoon. All i am trying to do is pass...

Leader

Preriquisites

Jeff Moden (9/14/2015)

---

Eirikur Eiriksson (9/13/2015)

---

Using heap to speed the inserts is like a very bad Credit Card deal, no transaction fees but X000% Annual interest rate:pinch:

😎

Jeff Moden (9/12/2015)

---

It's a...