Search results for query: *

Does anyone know how i can generate a database of all the files in a group of folders on my machine. I want to create a query in Excel which imports all the files in a particular folder/subfolders. Each filename becomes a row in the spreadsheet and each row has the following data as individual...

Does anyone know how i can generate a database of all the files in a group of folders on my machine. I want to create a query in Excel which imports all the files in a particular folder/subfolders. Each filename becomes a row in the spreadsheet and each row has the following data as individual...

i have created a user defined function that returns a table. There is one parameter (@Job CHAR(10) ) SELECT * from dbo.fproduction_record(123456) returns the correct results for that job # 123456 For testing purposes i want to be able to return all results of the function but when i try to...

Hi all I have a SQL view which joins a number of tables. One particular join is causing me trouble. I am using a Left Outer Join between table C and D on the fields Lot_Id and Wh_Id. I need the Table C record in all cases. Records in table D may not exist (for any particular combination of...

Is there some way to display a field in the print preview but not have it appear on the printed report. The only thing i can think is to put it on page 2 of the report and only print page 1 but this is a pain. I just want data to appear for the readers benefit before they print the report but...