Actually, something has ate-up my code....:D:D, missed the table in LEFT JOIN....

its wrking used the same query olny retrived distinct records...

Though the solution provided will give the correct results, but will not perform very well on large amount of rows. You should be careful while using CROSS JOIN as...

RBarryYoung (1/15/2009)

---

Ramesh (1/15/2009)

---

Since you are using SQL 2005, you have the windowed functions and the OVER clause....

Here is that query

SELECT *

FROM (

...

Since you are using SQL 2005, you have the windowed functions and the OVER clause....

Here is that query

SELECT *

FROM (

SELECT...

AndyD (1/15/2009)

---

Hi Ramesh,

First off, thanks very much for investigating! And you are exactly right, specifying

SET TEXTSIZE { number }

within the Step of the Agent Job solves the...

You have to use the function COALESCE or ISNULL (I prefer using COALESCE)....

SELECT COALESCE( people.last, '') + ',' + COALESCE( people.first, '' ) + ', ' + COALESCE( address.street, ''...

I've verified your sample and its indeed truncating the result to 512 characters. I think SQL Agent's default TEXTSIZE is 1024, whereas SSMS' default size is 2147483647. So, you...

It's actually much simple than you are thinking....

here is the simplified version of it...

SELECTEarn.RowID AS EarnRowID, Earn.SalaryHeadName AS EarnSalaryHeadName, Earn.HeadType AS EarnHeadType,

Earn.SalaryAmount AS EarnSalaryAmount, Dedn.RowID AS DednRowID,

Dedn.SalaryHeadName AS DednSalaryHeadName,...

Indeed, its possible to get aggregates without actually grouping the resultset in SQL 2005 using the...

Have you selected "Development Tools" in Component Selection?

Actually, I think its not RBAR, as its like merging two resultsets on COLUMNS...so its more like CBAR(Column-By-Agonizing-Row):hehe:

....because you don't have...

S Hodkinson (1/15/2009)

---

It seems I have installed it (I tried a re-install) but I cannot see it in the folder. I've got Analysis Services, Configuration Tools, Performance Tools and...

Q1:

You can use package configurations to save connection information and get it into variables and use those variables in the connection objects.

Q2:

I am sure there are tools that migrate the...

What errors are you getting when trying to connect to the server?

The system variable "MachineName" can give the name of the machine running the package, but I don't know how to get the IP address. May be there is one...