I bet you've not read the article in my previous post, if you really wants us to help you, then in turn you would also need to help us by...

...Of course, you can replace the COUNT( P.ProjectID ) with MAX( P.Milestone )

...This is what you are looking for

DECLARE @sdtCurrentDate SMALLDATETIME,

@sdtLastDate SMALLDATETIME,

@tiMonthsToAdd TINYINT

SELECT@sdtCurrentDate = DATEADD( DAY, 1, DATEDIFF( DAY, 0, GETDATE() ) ),

@tiMonthsToAdd = 3,

@sdtLastDate = DATEADD( MONTH, @tiMonthsToAdd, @sdtCurrentDate )

SELECT*

FROMSomeTable

WHEREArriveDate >=...

Before posting the solution, I strongly suggest you reading this article on how to post questions to get quick & better responses[/url], it not only saves time of the...

Though the task is quite easy to do, but personally I think you have to start reading books, articles & spend some more time doing practicals.

You build packages in SQL...

Actually, you didn't get my point. Let me put this way....

Suresh Kumar (2/2/2009)

---

As per my understanding, If I use Excel source and OLEDB destination, all rows from Excel will...

Actually, DTS Wizard is not supplied with the Express Edition of SQL 2005 (and its available in 2K8), though you can separately download & install the DTS Components and run...

...Not Enough Information, so I can only guess what you required. And my guess is that you require an INNER JOIN...

SELECT*

FROMdbo.Project_CreateMainTask MT

INNER JOIN dbo.Project_CreateTask T ON MT.ID = T.MainTaskId

To...

...SSIS is the way to go, personally I feel it's easy to understand and has a lot of useful features that can by dynamically changed. However, you can also...

Firstly, you should verify/cross-check your post before posting it in any forum, this will say a lot of time of posters.

Secondly, here is the solution to your query (note that,...

benlatham (2/2/2009)

---

Peter Brinkhaus (2/1/2009)

---

The Join function in SSRS expects an array of objects or strings as its first argument. It concatenates all string values of the elements in the array...

1. Check if the file "C:\Practice Files\Northwind.mdb" exists on the location on...

There are mainly two basic ways you can do it...

1. Create 1 Data flow task, 1 Excel Source Component & 1 OLE DB Command (Transformation) Component (that contain the update...

You have follow these steps.

1. Create 2 String varibles "SourceConnectionString" & "TargetConnectionString"

2. Create 2 Connections, 1 for Source & the other for Target

3. In Source Connection Properties, go to Expressions...

I've understood what you wanted and what is the logic behind it, but I'm confused with the output of row 5, according to the logic it should 1. Am...