Hello,

I have updated the file. There are tables and functions in it and also the requirement is specified in requirement sheet. Can u help me out?

I have also provided the ddl statements

Hello,

Using the table EmpHistory, it is not satisfying all the rules. So I want to use this function as it satisfies all the rules. This is what I want:

I have...

Hello Luis,

Actually, there is table valued function which gives the same data as the emphistory table. I want to use that tabel instead of CTE. I have also provided the...

Hello,

When I print it its correct. But when I see the report online that column doesn't show up. Can you help me with this?

Hello Rob,

Can u also tell how to covert if the data type is varchar.

Thanks in advance.

This too doesn't work. Is there any other way to do this.

With Format(), I am getting some thing like this:

OctAber

SetAmber

etc

Hello,

Originally, that column has Date as Data type. So, now what to do? IS there any other procedure to do this?

Hello Rob,

Few data is correct and few is wrong. Here is the sample output I am getting:

Octaber 12

Jul12 12

SetpAmer

What is the problem?

No there is no network down. Stored proc is working good. But I cannot see the result in crystal reports.

Let me clarify my question.

PKCostCenterAmountAssignment Xfd1

501002101250.00T0250076 100210

501002101250.00T0250076 100210

401002501250.00T0250076 100250

401003701250.00T0250076 100370

I want "100250" and "100370" (which is in CostCenter column in 3rd and 4th row) to be filled in place...

Sorry, my mistake, A and B are not the tables, just ignore that sentence.

There are many tables which are joined to build the 2 result set and then these 2...