Recent content by jacck

thanks PH i haven't tried anything...didn't know where to start. problem is i'm not a programmer and was hoping to set up some kind of odbc into the windows file system and then just use the obvious data query tools in excel !!!. the link you sent looks like its straightforward enough if you...

Subject heading should have been "Creating...

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...

that's great.. thanks a lot for your help - i'll try this tonight

Thanks very much Can i use the parameter in the same way if its a stored procedure? I'll get back to my SQL Bible and do some more reading - i'm no programmer as you can tell, just a dangerous user. Thanks again

sorry - better brush up on my posting technique in the meantime, here's the function: CREATE FUNCTION dbo.fProduction_Record (@job char(10) = NULL) RETURNS table AS return ( SELECT TOP 100 PERCENT dbo.JOBS.JOB_NUMBER AS Job, dbo.JOB_OUTPUTS.PART_CODE AS Part...

well now you all know how much i know - obvious beginner ! and i don't even have a signature! getting back to the question, is vongrunt asking me to post all the code that i have in the function ?

sorry, don't follow that. what is the replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/') bit tried typing: select * from dbo.fproduction_record(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/') but getting syntax error please expand

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...

EXCELLENT. Why didn't i think of that. Duh ! Thanks very much

tried Not Isnull .... and it returned the 15 records from Table D. What i need is the one Table C record with a Null value in the dbo.d.CODE column

Thanks Zathras I just tried this now and it still results in no record being selected at all. When i remove just this statement i get 15 records (none with CODE='RM') so i don't think there are any other errors in the statement I'm not familiar with the syntax of isnull but should i be...

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...

thanks all on demand subreport worked perfectly. i overlayed it on an obvious graphic already in the report so users would know where to click and suppressed it so no caption showed. and it worked fine in the distributed version. like you said synapsev it wasn't precisely what i was after...