Not a good way to ask for help or advice!! 😉

Just my two cents but I really don't like nesting views in...

You can use these in your WHERE clause to change what is returned:

SELECT

DAY(DATEADD(dd,1,GETDATE())) --Tomorrow

SELECT

CAST(DATEADD(DAY , 7-DATEPART(WEEKDAY,GETDATE()),GETDATE()) AS DATE) --Last Day of the Week

Andy

So based on your data above what would you like to be returned as Anthony asked?

Are you...

If you just want to show records that are due use GETDATE()

SELECT *

FROM YourTable

WHERE

DueDate > GETDATE()

Andy

Hi

Does this help?

CREATE TABLE #SAMPLE

(

SOURCE_FILE_ID INT,

CYCLE_ID INT,

TASK_ID INT ,

TASK_STATE_DESC VARCHAR(100)

)

INSERT INTO #SAMPLE

SELECT 22,1,1,'Valid' UNION ALL

SELECT 22,1,2,'Error' UNION ALL

SELECT 22,1,3,'Error' UNION ALL

SELECT 22,1,4,'Setup Fail' UNION ALL

SELECT 22,1,5,'Setup Fail' UNION ALL

SELECT...

anthony.green (5/28/2012)

---

Right well tomorrow is going to be a scary day.

Not only do I have my 70-450 exam in the morning, in the afternoon I also find out what sex...

Not sure sorry as I've not used 2005

I can only suggest giving it a try and see if it produces the desired result?

Andy

Do you mean is SSRS?

If so yes.

In VS look at the bottom right of the screen where your column groups are displayed, click on the small down arrow to...

Hi

You can do all of this using SSIS packages

This Stairway may help you

http://www.sqlservercentral.com/stairway/72494/

Andy

Hi

You are trying to JOIN on a table that you havent defined yet:

from GLDEFRLS

INNER JOIN accropts AC

ON AC.AccAccrOption = EM.EacAccrOption

You are joining AC.AccAccrOption on EM.EacAccrOption but this...

I may be misunderstanding but in the query designer enter:

Exec YouRStoredProcedure (@Param1, @Param2)

Andy

pawana.paul (5/11/2012)

---

Good Question. This is required as there will be changes made to the columns at Source (adding or dropping columns). If we go with SSIS, we need to do...

Personally I would go with SSIS as it was created for this kind of work.

There are many advantages of using SSIS to name but a few:

- Good error handling possibilities

-...

What are you trying to achieve - what results are you expecting?

Could you post some sample data?

Andy

Yep off you pop then 😀

Glad to help 🙂

Andy