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!

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

Search results for query: *

  1. yuchieh

    SQL 2000 and 2005 on Windows 7 machine

    yep, seen that thread, not working. reinstalled SQL2000 SP 4 as well, not working. they were okay when I was using WIndows XP machine, even with DTS Components installed. But for Windows 7.... :( We have legacy DTS in SQL 2005 database, so we have to install and use that DTS thing. thanks
  2. yuchieh

    SQL 2000 and 2005 on Windows 7 machine

    I have a Windows 7, 32-bit machine. I need to use both SQL2000 Enterprise Manager and SQL2005 Management Studio. I did the followings -- install SQL server 2000 install SQL2000 SP4 install SQL server 2005 developer version install SQL server 2005 SP4 at this point, both were working...
  3. yuchieh

    convert code to plain txt

    Hi George, thanks for all the ideas. out of the sudden, our web developer found the solution on his end so he fixed the data and the forms. if he could have implemented this in the beginning,... dauh... anyway. we are good. again, thank you for all the replied.
  4. yuchieh

    convert code to plain txt

    yeah, I figured. any other possible solutions? Thanks for testing it for me.
  5. yuchieh

    convert code to plain txt

    <html>&lt;p class=&quot;MsoNormal&quot; style=&quot;margin: 0in 0in 0pt&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight: normal&quot;&gt;&lt;span style=&quot;font-size: 14pt; mso-bidi-font-size: 10.0pt&quot;&gt;&lt;font face=&quot;Times New Roman&quot;&gt;Summary of...
  6. yuchieh

    convert code to plain txt

    I only ran one record for testing.
  7. yuchieh

    convert code to plain txt

    Hi, unfortunately, those fields are using text datatype in the database. I did create the function using varchar. then when I did select to call one of the fields, it took forever to run the query and nothing came up. so I killed it. any other way? thanks
  8. yuchieh

    convert code to plain txt

    I have data like this in SQL (server 2000) -- &lt;p class=&quot;MsoNormal&quot; style=&quot;margin: 0in 0in 0pt&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight: normal&quot;&gt;&lt;span style=&quot;font-size: 14pt; mso-bidi-font-size: 10.0pt&quot;&gt;&lt;font face=&quot;Times New...
  9. yuchieh

    SQL 2005, create Alert

    I tried to create new alert via SQL Server Agent. keep getting this error. using SQL 2005. HELP!! TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot create new alert. (SqlManagerUI) ------------------------------ ADDITIONAL INFORMATION: Could not load...
  10. yuchieh

    group by date

    I think I got it. Thanks much.
  11. yuchieh

    group by date

    I have a table that stores donation information - name, transaction_date, amount, fund how do I select: total amount >= $100 accumulated in one day, by one person? and yet, I need to display details. in other words, display individual records if the total amount belongs to multiple funds. Thanks
  12. yuchieh

    backup job on SQl agent

    OK. thanks.
  13. yuchieh

    backup job on SQl agent

    Hi M. this is exactly what I needed and it fixed the problem. Thank you Thank you Thank you!!! I am not familiar with that line of command and what they means. somebody else did the code. where can I find such information? Thanks again!!! :)
  14. yuchieh

    backup job on SQl agent

    We are using Lyris Listsev, which runs on SQL Agent databse. We set up a backup job and code is below (all in one line) -- BACKUP DATABASE [TestLyris] TO DISK = N'E:\Backup\TestLyris.bak' WITH NOINIT , NOUNLOAD , NAME = N'TestLyris backup', NOSKIP , STATS = 10, DESCRIPTION = N'Weekly...
  15. yuchieh

    duplicate record

    Sorry I didn't make it clear. Actually users want to find a record from the form and duplicate the record as a new record in the form. Maybe just change the values in a couple of fields in the new record. It would be one record at a time, not batch.
  16. yuchieh

    duplicate record

    I would like to create a onclick command button for users to duplicate records. However, there is an auto-number (unique ID). How do I set it up to generate the auto-number? Thanks
  17. yuchieh

    pass-through query for subreport

    I tried to use a pass-through query for a subreport and got an error. I found out that pass-through query cannot be used for subreport. Is there a way to work around it? Also, there is filter for the main report and the subreport will display the results based on the filter from the main...
  18. yuchieh

    find MAX value of a field among multiple tables

    I did it and it works. learn something new; feels good. Thank you all so very much.
  19. yuchieh

    find MAX value of a field among multiple tables

    do you mind explaining this part insert into @a select 1 union select 2 union select 3 what are those 3 selects? thanks
  20. yuchieh

    find MAX value of a field among multiple tables

    value is not null. there are date in each dateUpaded field. For example, max(table1.dateUpdated) = '11/5/2007' max(table2.dateUpdated) = '11/7/2007' . . max(table9.dateUpdated) = '11/1/2007' How do I compare these 9 dates and find the maximum one? thanks

Part and Inventory Search

Back
Top