my firstfeeling was also the same?. but there can be some tools.

http://www.sqlservercentral.com/columnists/sjones/businessdays.asp

this is the exact article phillcart is talking about

thankx it works!!!

Well, I our organization all have rights to develop the DTs, BUT under the DBA supervision

Well, can u to a substring function for a image field? I doubt.

from the http://www.sqlservercentral.com/columnists/bsyverson/sqldatetime.asp article

To visualize how date/time values are stored, you can think of them as consisting of two parts. The integer portion represents the number of whole days since...

That is unkown to me. I will try and let you know

There is a thrid party tool where you can search whether that field is used by other sps or views called SQL Digger

Search the internaet this is a free tool

use  'MultiGroove'

Main idea of the julian dates to order by date and get the date differences.

but now those funtions are bulit in with sql server. so I would think that it is not...

from DTS you can tranfer flat files to table

Yes Adam, I accept your word

Frank Kalis has done great jobs. I have learnt lot from his.

Keep up the good work Frank Kalis

 Does your view contain any of the following:

- TOP clause

- text, ntext, image columns

- DISTINCT

- MIN, MAX, COUNT(*), COUNT(<expression&gt, STDEV, VARIANCE,...

you can use text or ntext filed

 from the bol

ntext

Variable-length Unicode data with a maximum length of 2³⁰ - 1 (1,073,741,823) characters. Storage size, in bytes, is two times the...

in simple terms transaction is a sequence of operations performed as a single logical unit of work