User Profile

glennyboy · Oct 20 '14, 12:41 AM

thanks a lot Rabbit.

glennyboy · Oct 16 '14, 08:47 AM

here is my revised code, but im unable to separate column of sales code and unit price

Code:

SELECT
	[SSI$Sales Price].[Sales Code]
    ,[SSI$Sales Price].[Item No_]
    ,[SSI$Sales Price].[Variant Code]
    ,[SSI$Sales Price].[Unit of Measure Code]
    ,[SSI$Sales Price].[Unit Price]
    ,SSI$Item.[Unit Cost]
    ,[SSI$Sales Price].[Starting Date]
    ,[SSI$Sales Price].[Ending Date]

...

glennyboy · Oct 9 '14, 08:24 AM

Rabbit,

thanks for the reply.

i want to separate the column of [SSI$Sales Price].[Sales Code] into C00020 and SRP in the same table.

thanks.

glennyboy · Oct 8 '14, 06:26 AM

here is revised query:

Code:

SELECT
	[SSI$Sales Price].[Sales Code] AS CUSTOMER
	,[SSI$Sales Price].[Sales Code] AS SRP
	,[SSI$Sales Price].[Item No_] AS [Item No]
	,[SSI$Sales Price].[Variant Code]
	,[SSI$Sales Price].[Unit of Measure Code] AS [Unit of Measure]
	,[SSI$Sales Price].[Unit Price] AS SALES1
	,[SSI$Sales Price].[Unit Price] AS SALES2
	,SSI$Item.[Unit Cost]
	,[SSI$Sales

...

glennyboy · Oct 8 '14, 05:54 AM

error message

Msg 1013, Level 16, State 1, Line 3
The objects "SSI$Sales Price" and "SSI$Sales Price" in the FROM clause have the same exposed names. Use correlation names to distinguish them.

glennyboy · Oct 8 '14, 05:50 AM

here is my query code

Code:

USE [SSI-HQ]

SELECT
	[SSI$Sales Price].[Sales Code]
	,[SSI$Sales Price].[Item No_] AS [Item No]
	,[SSI$Sales Price].[Variant Code]
	,[SSI$Sales Price].[Unit of Measure Code] AS [Unit of Measure]
	,[SSI$Sales Price].[Unit Price] AS SALES1
	,[SSI$Sales Price].[Unit Price] AS SALES2
	,SSI$Item.[Unit Cost]
	,[SSI$Sales Price].[Starting Date]
	,[SSI$Sales

...

glennyboy · Oct 8 '14, 03:20 AM

ck9663,

thanks for the reply.

its only 1 table.

glennyboy · Oct 8 '14, 12:24 AM

Frinavale,

thank you for the reply.

- This is for MS SQL Server.
- Im using SQL Server Management Studio Express to test the sql query, then i will use it in MS Excel to export data from sql server to MS Excel.

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Same Column, Same Table - Query