Hi Imu,

Thanks for the kindly help .the code which you have given is very helpful for me.

Side note: What is the reason to store the id...

Hope this too will work ,but while coming to performace related point of view hope this query will degrade.I have posted this because it may help someone in future.

SELECT

...

Hi all,

I have got a solution by surfing in Sql server central forum discussion .

Solution:

SELECT * FROM fn_trace_gettable('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log.trc', default);

Is there any other thing to identify the same?

Hope...

Another solution hope this too will work.

select

[EmpId] ,

[EmpName],

[DeptId],

[Salary]

from

[DirectEmp]

union

select

[EmpId],

[EmpName],

cast('--' as sql_variant)...

instead of going for varbinary or something you can use varchar(max).

Just try out that.

Thanks,

Chandru

If you want to do it apply the same logic...

select substring(column_name,20,8340) from table_name

is the above one is not working for you ?

Thanks,

Chandru

i think round(number,0) -->round (85.074626865671600,0) will display like this '85.000000000000000'

Thanks,

Chandru

Try out this sorry if I'm wrong,

select ceiling(85.074626865671600),floor(85.074626865671600),round(85.074626865671600,1)

This 'Plannnig' and value '5' is input or the values fetched from the select statement ?

Thanks,

Chandru

I'm also not sure about this just try to view errorlog and application application event log so that you can get some clarity on this issue.

Just confirm Sql server folder...

You can't insert explicit values into a timestamp column.

Timestamp values are unique binary numbers that are automatically generated.

You will need to explicitly state the columns you are inserting data into:

_________________

insert...

Thanks Mr.Krayknot it worked well..

Cheers.

Ofcourse you are correct i dont want to generate random numbers i want to generate sequential numbers for each unique vendor-company combination that arrives.

Thanks

Chandru

Sure .......

Hope this helps for someone

My requirement is i want to generate the tracking number in random order

based on the vendor name and company code that too if a different...