Build Drive Path of File

• pilotjwr74

  Newbie

  Points: 5

  More actions

  January 28, 2013 at 10:19 pm

  #267815

  I need to build the drive path in the select query???

  Tables:

  Drive

  DriveID (int)

  DriveLetter char(1)

  Directory

  DirectoryID (int)

  DriveID (int, fk)

  DirectoryName varchar(255)

  ParentDirectoryID (int, null) -refers to DirectoryID in same table

  File

  FileID (int)

  DirectoryID (int, fk)

  FileName varchar(255)

  ReadOnly (bit)

  Size (bigint)

  CreatedDate (datetime)

  Select

  FileID,

  --FullPath, need to build it

  [FileName],

  [ReadOnly],

  Size,

  CreatedDate

  From

  [File]

  Where

  [FileName] Like '%' + @criteria + '%'

• hb21l6

  SSCommitted

  Points: 1647

  More actions

  February 1, 2013 at 1:10 am

  #1583289

  .