I got the solution for this!

Thanks,

Farooqh

Thanks for the response.

If I get any help in SQL Server then will try to implement in MYSQL as well.

Sample DDL:

CREATE TABLE Open_Clos_Bala ( DATE_ACT DATE, Measure CHAR(100), PROCESSED FLOAT,...

The problem is with this below query,

DECLARE @WorkStation TABLE ( [IPAddress] NVARCHAR(100) )

INSERT INTO @WorkStation ( [IPAddress] ) VALUES ('255.255.0.0')

INSERT INTO @WorkStation ( [IPAddress] ) VALUES ('98.123.251.21')

INSERT...

OR is there any solution to enter the calculated string into each column

For example:

68.121.54.90.23

34.42.79.89.63.90.10.0.1

Column1 Column2 Column3 Column4 Column5 Column6 Column7 Column8 Column9

68 ...

Thanks!!

But i am not getting the desired result.

Basically i want to order the (SequToParse) field value.. If you could check the data then you will notice there is no proper...

Thank you!

But we are not suppose to use functions.

I found the solution..

LEFT([field], CHARINDEX(',', [field]) - 1)

:):):)

Thanks:-):-):-):-)

It should be between two dates.

Min Date : 2012-04-01

Max Date : 2014 -03-31

I need somethings like this

2012-04-01 to 2012-06-30

2012-07-01 to 2012-09-30

2012-10-01 to 2012-12-31

2013-01-01 to 2013-03-31

2013-04-01 to 2013-06-30

2013-07-01 to 2012-03-30

2013-10-01 to...

Thanks for the replies..

🙂

I got the solution..

CHARINDEX(',' ,@string) > 0

Thanks

Farooqh

Thanks for the reply.

I used calendar month table, but it returning two or three rows for one name project because some 2 or 3 phase are present in the one...

Hey Use Pivot Logic to get the result!!! 🙂

Thanks for the reply.

I did the same to get the result.

I tried using Execute SQL TAsk and Script Task

The output is

<EMPID>1</EMPID><EMPFName>Karthik</EMPFName><EMPLName>Anbu</EMPLName>

But i want the output similar to the...

It is not taking the second file.. And it is not inserting the file name too.

Hi guys,

I have many excel files in the folder. I want to insert the data of all these files into tables with the excel files name.

I create a package with...