********This is the DDL***************

USE [stgFACTS]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[I353_SalesOrder](

[I353_DATE_TRANSACTION] [decimal](8, 0) NULL,

[I353_TIME_TRANSACTION] [decimal](6, 0) NULL,

CONSTRAINT [PK_I353_SalesOrder] PRIMARY KEY CLUSTERED

(

[I353 _ITEM_NBR] ASC,

[I353...

Thank you guys for trying to help me out,

I'm trying to get the ddl,insert statements..give me a minute

Thxs

SM

Lowell,

I tried the following code

select CONVERT (varchar, CONVERT(datetime,STR(MY_COLUMN)),101)

FROM mytable;

It is giving me the following error

Msg 242, Level 16, State 3, Line 1

The conversion of a varchar data type to...

Thank you for the reply Lowell,

I was trying to create a view for all the tables.

Could you demostrate how to implement this commoand inside a DDL statement for creating view

Thanks

SM

Thank u Sean,

Actually I was trying to create a view ,I can't modify the real table.

SM

Hi Sean,

You are right mycolumn is defined as decimal in its DDL statement.

SELECT convert(varchar, mycolumn,101)

FROM Mytable;

that's why the above code is not giving the right result.

COuld...

Hi Sean,

You are right mycolumn is defined as decimal in its DDL statement.

Thanks

SM