To handle the non date values, incorporate the use of a conditional split transformation. You are the best judge on what the non date values are like. You can state...

I use this when I am developing and want to set up the structure to easily comment out conditions in the WHERE clause if needed. It was weird to me...

Jeff Moden (2/17/2015)

---

MMartin1 (2/17/2015)

---

Using tables like a Calendar, Course, TimeOfDay table (separate from Calendar which implies a day as the primary key) or Period ...

you could employ a simple...

Using tables like a Calendar, Course, TimeOfDay table (separate from Calendar which implies a day as the primary key) or Period ...

you could employ a simple snapshot table that...

Hi Jeff, from reading your thoughts I hope I understood all of the points you made. I drew out here a base and audit table as

CREATE Table table1

(

IDINT IDENTITY(1,1)...

Just to note, the DATENAME functions requires a date for the second argument. They way you have it you are expressing 1900-01-01. If...

Eric M Russell (2/3/2015)

---

MMartin1 (2/3/2015)

---

Maybe I missed it somewhere but it seems as though you are reporting from the same system you insert into. You generally want to build a...

Koen Verbeeck (1/19/2015)

---

What I would do:

* Read the flat file like you normally would, i.e. with a flat file source. You can use a for each loop container with a...

Maybe I missed it somewhere but it seems as though you are reporting from the same system you insert into. You generally want to build a warehouse to store your...

The ".." represents the default schema for the security context accessing the data, without you having to type it. Let us say that I am logged in as loginA. Under...

Could the 'safe' plan that incurs a higher cost be helped by updating statistics?

Luis Cazares (1/27/2015)

---

If it's a string column with underscores between each part of the date. This could be an option.

SELECT columns_to_return

FROM dbo.XYZ

WHERE date_column > REPLACE( CONVERT(...

I too like the column on the left and expression on the right. I also like to use the year argument to know I am interested in one year back,...

I thought something like the following may be helpful as well , based on your requirements of course...

select postalCode = Case when patindex('%[0-9]%',postalcode) > 0

...

keshav_nitrkl (1/23/2015)

---

Hi ,

My report is having three fields : NAME || Level || ID .I have a single dataset and a filter to my dataset. The dataset filter should work...