Trekkie_SG9


How can I make the values for certain cells in a table in a database show the day a folder was created

On the same note, How can I make other values in other cells change (say the values 101 through 200 had to change to 1-100)




Re: Dynamic SQL Cells

Arnie Rowland


For the first part, you would have to explicily 'store' the "day a folder was created" in the field.

On the second part, if you wanted to subtract 100 from a current field value, and replace the current field value with that subtracted value, you would use a query similar to this one.

Code Snippet

UPDATE MyTable

SET MyColumn = ( MyColumn - 100 )

WHERE MyColumn BETWEEN 101 and 200







Re: Dynamic SQL Cells

Trekkie_SG9

How am I supposed to "store" the day a folder was created in a field




Re: Dynamic SQL Cells

Arnie Rowland

Well, somewhere, somehow, the folder was created. It was not created in SQL Server. SQL Server does not know anything about file folders UNLESS we tell give it a value and tell it to store the data.

So, unless your 'process' that creates the folders is smart enough to add that data to SQL Server, it will be left up to you to determine the creation date, and to add that creation date to a field in a table.

You haven't provided enough information to get the type of help that you are seeking. Perhaps if you were to provide a better description of what is happening and what you desire to accomplish, someone here 'may' be able to assist you.