ADS version : ADS-windows-x64-14.0-rc-13
Connect to Sybase ASE
Go to Query analyzer window
Run select query
Click on Pivot Grid
Add any cloumn to column area
Righ click anywhere in Pivot grid->Save Results->Browse for a particular file->Save to file
Instead of saving Pivot grid results,it saves grid results.
Create table script:
CREATE TABLE dbo.test_Narendra (
studentid int NOT NULL,
name varchar(25) NULL,
std varchar(25) NULL,
CONSTRAINT pk PRIMARY KEY CLUSTERED(studentid)
WITH max_rows_per_page = 0, reservepagegap = 0
)
LOCK ALLPAGES
GO
Insert table script:
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(1, 'Narendra', '100')
GO
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(2, 'vaibhav', '16')
GO
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(3, 'Umesh', '19')
GO
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(4, 'Joshya', '19')
GO
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(5, 'Tushar', '20')
GO
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(6, 'Raghav', '20')
GO
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(7, 'Joshya', '15')
GO
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(8, 'Raghav', '25')
GO
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(9, 'Raghav', '28')
GO
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(10, 'ABCD', '1')
GO
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(11, 'abhi', '16')
GO
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(12, 'Anil', '160')
GO
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(13, 'Nilesh', '116')
GO
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(14, 'Swapnil', '0')
GO
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(15, 'Nik', 'NULL')
GO
INSERT INTO dbo.test_Narendra(studentid, name, std)
VALUES(0, '', '')
GO
You can also right click on a cell, select Copy -> Copy Pivot Grid and Save it to a text file. You can also save Pivot Grids as Excel.
However, we won't support the Pivot Grid Save Results for generating Insert Statements, Delimited, HTML file etc as generating insert on Pivot Grid wont make sense, since the values are applicable to the Grid results.