thanks for...

mister.magoo (9/5/2013)

---

Hi, this should help:

CREATE FUNCTION FormatLakhCrores (@number SQL_VARIANT,@conversion smallint)

RETURNS TABLE

WITH SCHEMABINDING

AS

--= Function to format a number using the Lakh/Crores style

--= Written 06 Sept 2013 Mister Magoo

--= Permission granted for...

Luis Cazares (9/5/2013)

---

I agree with Koen when he says that formatting should be done in the visualization layer.

But if the column type is money, then you can use CONVERT...

Hi,

We use Informatica for reporting the data and we are able to do it in Informatica. But I am unable to do it in SQL.

Old Hand Pls suggest me ur code so that it will be useful for me to proceed..

If we have any other way to achieve the what I desired please suggest me..

What I need in the end is I have to achieve the Proper case functionality Through...

sgmunson (5/6/2013)

---

I'm at the point of making an assumption about what the poster meant by their most recent post. Given the technique of concatenating a series of ISNULL...

sgmunson (4/25/2013)

---

There may be an easier way. If the data source allows an SQL Query, and supports the ISNULL function, then your SELECT statement could look something like...

dg227 (4/24/2013)

---

If, as Phil has assumed/you've implied, you are exporting data from multiple source columns and concatenating them into a single export/destination column, you still need to account for the...

manibad (4/19/2013)

---

I found a method to achieve my goal in derived column in SSIS.

the code is:

((SUBSTRING(Variable,3,1)=="/"&&SUBSTRING(Variable,6,1)=="/")||

(SUBSTRING(Variable,3,1)=="/"&&SUBSTRING(Variable,5,1)=="/")||

(SUBSTRING(Variable,2,1)=="/"&&SUBSTRING(Variable,4,1)=="/")||

(SUBSTRING(Variable,2,1)=="/"&&SUBSTRING(Variable,5,1)=="/")||

(SUBSTRING(Variable,3,1)=="-"&&SUBSTRING(Variable,6,1)=="-")||

(SUBSTRING(Variable,3,1)=="-"&&SUBSTRING(Variable,5,1)=="-")||

(SUBSTRING(Variable,2,1)=="-"&&SUBSTRING(Variable,4,1)=="-")||

(SUBSTRING(Variable,2,1)=="-"&&SUBSTRING(Variable,5,1)=="-"))?

(DT_STR,8,1252)(REPLACE((DT_WSTR,10)(DT_DBDATE)Variable,"-","")):REPLICATE(" ",8)

but here in this code i have a glitch..

the glitch is...

I found a method to achieve my goal in derived column in SSIS.

the code is:

((SUBSTRING(Variable,3,1)=="/"&&SUBSTRING(Variable,6,1)=="/")||

(SUBSTRING(Variable,3,1)=="/"&&SUBSTRING(Variable,5,1)=="/")||

(SUBSTRING(Variable,2,1)=="/"&&SUBSTRING(Variable,4,1)=="/")||

(SUBSTRING(Variable,2,1)=="/"&&SUBSTRING(Variable,5,1)=="/")||

(SUBSTRING(Variable,3,1)=="-"&&SUBSTRING(Variable,6,1)=="-")||

(SUBSTRING(Variable,3,1)=="-"&&SUBSTRING(Variable,5,1)=="-")||

(SUBSTRING(Variable,2,1)=="-"&&SUBSTRING(Variable,4,1)=="-")||

(SUBSTRING(Variable,2,1)=="-"&&SUBSTRING(Variable,5,1)=="-"))?

(DT_STR,8,1252)(REPLACE((DT_WSTR,10)(DT_DBDATE)Variable,"-","")):REPLICATE(" ",8)

but here in this code i have a glitch..

the glitch is if...

thanks for everyone who have replied..

Actually i am not in a position to work on SQl or Script task and code the data to achieve my destiny..i can do it...

SORRY For guiding you wrong..i need to throw those formats as string literals in text files and not loading those in tables...

I have to work on SSIS to get the first day of following month and the output should be as string value.

Input:getdate()

Output:Firstday of the following month

format of output is=yyyymmdd

Sorry for...