Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by SQLScholar

  1. SQLScholar

    Subform not firing event

    Hey all, I dont "do" access stuff very often and i am struggling. I have a form\subform all working fine. However on the subform design i have added this Private Sub Form_AfterUpdate() Me.Form.OrderBy = "OrderKey" Me.Form.OrderByOn = True End Sub This works fine when i view the form on its...
  2. SQLScholar

    Problem with an SQL Database

    Firstly that doesnt look like an error - that sounds like a command. Does this use SQL server as a database? I recommend finding a nortel forum to try and find more details on the issue. ---------------------------------------- www.fountain.me.uk Be who you are and say what you feel, because...
  3. SQLScholar

    Is There A Way to Relate Similiar Data Between Two Tables?

    Just to clarify - my view is that no other system can be 100% accurate. At the end of the day its common sense - can you program that? ---------------------------------------- www.fountain.me.uk Be who you are and say what you feel, because those who mind don't matter and those who matter...
  4. SQLScholar

    Is There A Way to Relate Similiar Data Between Two Tables?

    But how do you know that its not ASHLEY COMPANY CONSERVATION DISTRICT? My personal view on this.... If you need 100% accuracy then there is only one way to do it. Do a straight match (maybe change Ltd to LIMITED?). Then see whats left. Lets assume there would be less than half, maybe a...
  5. SQLScholar

    SQL 2008 - Update mulitple databases with 1 script

    You could use dynamic sql if all the structures are the same. like it suggests here: http://stackoverflow.com/questions/3206304/loop-through-databases-on-server-and-update-data But be careful and make sure you have a good backup. You may also want it to exclude any other system databases...
  6. SQLScholar

    How to hide/view a SSRS report parameter control dynamically at runtime?

    As far as i am aware you cannot hide parameters. The only thing i can sugguest is setting them to "unused" or similar dependant on the other filters. Then obviously you will have to cope with this "unused" wherever this parameter is used. ----------------------------------------...
  7. SQLScholar

    How to hide/view a SSRS report parameter control dynamically at runtime?

    As far as i am aware you cannot hide parameters. The only thing i can sugguest is setting them to "unused" or similar dependant on the other filters. Then obviously you will have to cope with this "unused" wherever this parameter is used. ----------------------------------------...
  8. SQLScholar

    SQLCMD

    Hi, In this instance i would compare the files and find the difference first and foremost. To do that i would use an app like WinMerge (i believe it is free) to compare the two files and find the difference. That may then get you closer to the why? Dan...
  9. SQLScholar

    Add Parameter into the report and pass it to a function

    Hi, I am not sure if you even need a table function for this. Can you explain what the report does? So it takes in a year - but then it has to work out the quarters for what reason? I am not trying to be awkward but it sounds like you are thinking about this in the wrong way. For a starting...
  10. SQLScholar

    Remove Range of Numbers from a Text String

    The convert function will fail unless you remove the letters first. I would suggest a post on the oracle forum will get someone who can help you with the PL\SQL for that. Dan ---------------------------------------- www.fountain.me.uk Be who you are and say what you feel, because those who...
  11. SQLScholar

    Link to Dbase IV with SQL Server 2012

    This link may help you http://www.dbforums.com/microsoft-sql-server/1214500-linked-server-sql-dbase-db4.html ---------------------------------------- www.fountain.me.uk Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch...
  12. SQLScholar

    How to check on date time stamp when record has been inserted into table

    Sorry to be the bearer of bad news. I am quite sure there is no such date stored. The only other way would be attempting to get the date out of the transaction logs back to whenever it was inserted - if you have them, but i cant imagine that would be easy even if you did. Dan...
  13. SQLScholar

    rank() OVER / PARTITION BY vs CTE for numbered groups

    I am not sure this would be possible (i may be wrong). Without recursion\CTE\Cursor SQL works in batches of data, not at individual row level. A row does not know what the previous row was. Would love to be proved wrong however :-) ---------------------------------------- www.fountain.me.uk...
  14. SQLScholar

    How do I turn this statement into an IF NOT EXISTS statement?

    Hi, Its because of the order by. Do you need to order the insert? If so i can probably code round it. Dan ---------------------------------------- www.fountain.me.uk Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch...
  15. SQLScholar

    How do I turn this statement into an IF NOT EXISTS statement?

    How about this (untested so please try on a dev box) INSERT INTO Product_SpecificationAttribute_Mapping (ProductId, SpecificationAttributeOptionId, AllowFiltering, ShowOnProductPage, DisplayOrder) SELECT PD.Id AS ProductId, sao.Id AS SpecificationAttributeOptionId, '1' AS...

Part and Inventory Search

Back
Top