Hi Jeff

I am very new to functions concept ,and i can not create table to hold the results.

I wrote the function,but getting errors..

CREATE FUNCTION dbo.fn_nscc_SplitStringToCols

...

thanks jeff,,,,,,

Hi jeff

i am very to sorry to disturb you,

your query is awesome,

but i have to include your bit in my select statement.

here is the code..

SELECT

document.RegdAt AS [Date...

thanks jeff

you are wonderfull ,

I really thankfull to you,you are so wondefull .........

thanks once again...

Hi Jeff

thanks for time.

First i used char(13)+Char(10) function to find out enter symbols(Carraige returns)

then my clomn is displaying like this...

test='GUARD NUMBER:NC122 TauZZDISPATCH TIME:1907ZZTIME ONSITE:1930ZZTIME OFFSITE:ZZOUTCOME:Verbal WarningZZ'

what i want here

guard number=nC122...

Plaese ask me if you want more information,,,,

thanks ,,,

Hi jeff

Sorry for giving trouble to you,,,,,,

i am in trouble in witing sql for below problem

My column has data like this

Number:122

time:1209

nonsite:(menas null)

verbal:out control

What i want

Number time ...

Thanks jeff,i really appreciate your help,,,,,,,,,,,

Thanks ,it gives me some ideas.

Hi

I did half the part by reading some articles in google.

1. to Truncate the Table 1st - Execute SQL Task)

2. Load the Table with fresh data ...

Hi

There is no comma in between 13,40.

I typed for better understanding.

actual format is 1340 ,1220,1440 and data type is decimal.

anyway thanks for help,

it gives me idea....

it was stored in below format

14,23

15,59

12,12

13,45

what i wwant here

14,23 =2:23 PM

15,59=3:59 PM

tahnks

hi

Data type is decimal ,its time field and extracted from AS 400 systems.