Search results for query: *

Do you think it is appropriate to give a client their data structure for free? We have built and housed a data mart of their data warehouse for simple access to their data. Now they are asking for the relationship and data structure. Should we place a fee on this?

Do you think it is appropriate to give a client their data structure for free? We have built and housed a data mart of their data warehouse for simple access to their data. Now they are asking for the relationship and data structure. Should we place a fee on this?

I found this same message from Chris on the SQL board as well and there was a tip how to increase the number of locks on a database and reconfigure without restarting the server. He said it did work for him and it also worked for me. I am not sure how or why this works but it did. The SQL...

Chris, Did you ever get around this error? If not, I wish I could help you out. Unfortunately, I am getting the same error. I have looked at the Locks/Process Id and I have 22 spids. Is this the same as locks? I have looked under the help menus and online and I have not seen any information...

Thank you that is all I needed!

I have had this issue before.  I set up two new number fields to update. One for the text length from the left side to the first space, and the other for the text length from the right side to the second space.  Then using those new numbers, I used LEFT and RIGHT functions to...

I tested the Microsoft article "How to Fill a Table with Random Records from another table", see link below.  It works great! However, I am trying to automate how to enter the number of records to fill in a table.  The example has it all contained in the...

I figured it out - the scale on the data type needs to be set as well.  I just thought it was the precision.

I have a field set as a decimal data type. However, when I update the field with a calculation, (A+B+C+D)/E - these letters are fields, it does not show as a decimal.<br><br>Example - (2+5+9+0)/3 - should equal 5.33, it is calculating as just 5.&nbsp;&nbsp;<br><br>Is there something I am missing...

Thank you - I do follow. I have not had a reason to do this until now. That makes sense to open a report that uses the datasource.<br>

I think I would like to be able to have combobox show on a report. For example, I need to be able to pick criteria from fields of an inventory table and print out the findings. (make=Ford, Model=Explorer, Year=1997, then gives list of all vehicles matching criteria). I know I can get these...