tank you solve 🙂

thank you vary much 🙂

thank you vary much 🙂

next time not lazy:)

hi ,

first thank you 🙂

second i do it for test some of tables with float data that i need to convert to

char. ( dont look for logic :))

i...

hi ,

just to be clear 🙂

i didn't write this code ,

i need to improve this code, i put all my

knowledge as dba to solve it but still i cant...

thank you vary much 🙂

hi ,

ddl:

GO

/****** Object: Table [dbo].[TBL_STREET_ROAD] Script Date: 7/24/2016 5:23:24 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[TBL_STREET_ROAD](

[ID] [int] NOT NULL,

[source_column_ID] [bigint] NOT NULL,

[CITY2]...

thank you vary much

it help me alot

sharon

thanks you for replay,

so you say if column bigint define with null

and i didnt insert data to this column this column

will be null with over...

THANK YOU VARY MUCH

ITS WORKED FOR ME

hi,

trying to build SQL Query to retrieve the data

sharon

hi ,

sql 2005 sp4

sharon

perfect

thank you 🙂

sharon

thanks you for you your answer

how can i mark your answer as a good one

thanks sharon

THANK YOU

IT HELP ME ALOT