Hi,

I have made a sample of result set in attached xlxs as well as in below script but the values are dummy. Please get back to me if anything required....

Hi,

Thanks the quick Reply.

As My Table Structure, all are columns.

I Want ID to be pivoted and rest of the column value should also be pivoted accordingly.

Some_Derived_Column nameIDIDIDID

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

Value OF SDIDValue OF...

John,

I dont know what is the exact problem.

Regards,

Vijay

Hi John,

Thanks for the reply. Problem is, i am unable to log in via Windows authentication as well.

Regards,

Vijay

Hi ,

Now we decided to have mapping metadata table with source columns and destination columns details. Now how to archive this?

Thanks in Advance

Regards,

Vijay

Hi Suresh,

BCP is the best and fastest way to migrate data. BCP sybase tables into .dat files and then use bulk insert.

Regards,

Vijay

Hi John,

Please find the error message below.

Msg 3169, Level 16, State 1, Line 1

The database was backed up on a server running version 8.00.0760. That version is incompatible with this...

Hi John,

I tried restoring it in 2008 R2. But i got the same compatibility error.

Regards,

Vijay

Try this if it helps you.

CREATE FUNCTION [dbo].[fnSplit]

(

@sInputList VARCHAR(8000) -- List of delimited items

, @sDelimiter VARCHAR(8000) = ',' -- delimiter that separates items

) RETURNS @List TABLE (item VARCHAR(8000))

BEGIN

DECLARE...

What you want to do after fetching 20000000 rows? Do you want to display all rows the screen?

Regards,

Vijay

Thanks a lot Lowell.:-)

Regards,

Vijay

Thanks laurie:-).

Even i tried the first Query and its working fine. But just wanted to know why its is not working in Usual way.

Regards,

Vijay

Hi,

Please find the code below.

CREATE TABLE MyTable

(

BatchFileID INT IDENTITY,

LineItemValue NVARCHAR(256)

)

INSERT MyTable

SELECT 'EFC'

UNION

SELECT '3456.5070'

UNION

SELECT '253434.5670'

UNION

SELECT '345.5070'

UNION

SELECT '1234.5670'

select * from MyTable

WHERE

--CAST(LineItemValue AS NUMERIC(28,5))=1234.5670 AND

LineItemValue NOT LIKE '%E%'

AND ISNUMERIC(LineItemValue)=1

select...

Hi,

I checked the query by parsing XML and inserting rows into table but i dint get any warnings or errors. I checked even the table structure and it looks fine....

Hi,

I reseed the table and the issue is fixed. But i want to know how this problem occurred.

Thanks,

Vijay