Search results

I have just inherited an SQL database where images were stored in a table column using binary data type.I have decided to save the images in a filesystem and then just save the path in a databse column. The problem is how i can retrieve all the images in the SQL db export them to a folder in...

I have a query that select rows from the employees,salary_head and salary_group tables this is the query SELECT TOP 100 PERCENT dbo.salary_head.salary_group_id, dbo.salary_group.salary_group, dbo.salary_head.amount, dbo.grade_level.[level], dbo.employees.employ_name...

tracking files last status. Thanks for your response. My problem is how to write such a query.CanU give me an idea? When i tried this query:select file_id,trandate from filetrans where filetrans_id=(select max(filetrans_id from filetrans), the query only returns a single result.I need the query...

tracking files last recorded status thanks for your response.The issue is that it is the files whose last recorded status is out that i want the to capture. For example in the table a file can have several status that is constantly changing has it is released and returned from the unit.What i...

Hi folks, This is my first posting to this forum and I hope someone will be able to help me out with this. I have a table called FILETRANS in a DB.Essentially this table is to track the in-flow and out-flow of files in a documentation unit. The schema of the table is as follows Filetrans_id Pk...