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 Chriss Miller 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. karen4201

    starting a website- advice needed

    Keep in mind that a copyright and patent are DEFENSIVE legal tools. It won't prevent someone from copying the material, but you could use your copyright/patent to ask them to stop using the material in bad ways. Basically, what you're looking to do is take "ownership" of those words, so that...
  2. karen4201

    group by 30 min. intervals

    Hi, I'd like to organize my data based on a datatime field grouped by 30 minute intervals. I'm thinking about using a CASE statement that would look at the minute and if 0..30 then it would get 1, otherwise it would get 2...so 1 is the first half hour, and 2 is the second half hour. There are...
  3. karen4201

    trigger doesn't work. why?

    wow. that's it! Thanks :)
  4. karen4201

    trigger doesn't work. why?

    ...where c.my_id = @my_id) -- if the row has not already been created, then we create a new row with an insert-operation if 0 = (select top 1 count(*) from person_tbl where my_id = @my_id) insert into person_tbl(my_id,parent_id, my_title, cnt_pass, cnt_fail, my_grade)...
  5. karen4201

    trigger doesn't work. why?

    I've developed a trigger that runs for an UPDATE on table A. It simply calculates some information and updates table B when table A has an update. It works fine if the update is on only 1 item in table A. However, if table A has multiple items that are updated, then the trigger returns an...
  6. karen4201

    sql variable not working. why is this?

    ...= '''' + replace(@case_str,',',''',''') + '''' -- create a variable to hold the seperated values I think I may try a temp table to store the values, then do something like: select * from tableA where name in ( select the_name from temp_table ) [i wrote this by hand, so it's sort of pseudo...
  7. karen4201

    sql variable not working. why is this?

    ...the query works when I use a string of characters.... DECLARE @nameStr _str varchar(3500) set @nameStr = 'aaa','bbb','ccc' this works: select * from tableA where name in ('aaa','bbb','ccc') but this does NOT work: select * from tableA where name in ( @nameStr ) Why does the variable not...
  8. karen4201

    what sql would do this?

    Hi, I have a table with a document's history. The table's fields are: docid (int), name (varchar), version(int), status(varchar) status could be = under construction, published, expired with each editing of a document, a new record is inserted and the version number is incremented. Here is...
  9. karen4201

    xsl question...

    thanks for the tips :)
  10. karen4201

    xsl question...

    Hi, I couldn't find an XSL forum, so I thought I'd post my question here. I'm trying to create a hyperlink based on a value-of. Here is the code, which is not working: <a href='<xsl:value-of select="myURL"/>' >the link</a> How could I get this to work? Thanks in advance.
  11. karen4201

    how do I modify a string field?

    Let's say I have a table field that contains "Joe, Bob, Mike" and the names might be rearranged (like "Bob, Joe, Mike"). Is there an easy way to update ALL fields that contain "Bob" so that the field would simply have Bob removed from it? So, in essence: there is a table with a text field...
  12. karen4201

    handling the &quot;&amp;&quot; character in a string

    correction: I meant to type.... So the "copy&amp;paste" becomes "copy&paste". Now that I'm doing the adjusted string comparison, it's working!
  13. karen4201

    handling the &quot;&amp;&quot; character in a string

    Thanks for the tips. I figured out what was going on. It seems that the browser (IE 6.0) will accept "copy&amp;paste" and display it properly. However, when I do the dropdown selection, the JS does a string comparison as though the value was passed as an html string. So the...
  14. karen4201

    handling the &quot;&amp;&quot; character in a string

    Hi all, I'm trying to build 2 drop-down lists. When the first (list A) drop-down is selected and an item is picked, the JS will automatically populate the second (list B) drop-down list. I have it working for most items. However, if list A contains an item with a "&" character, such as...
  15. karen4201

    SQL Server version control?

    Yeah, I was thinking about using VSS or CVS and do versioning of the text scripts for the database objects. I'm glad to see that other people think the same things :) Thanks!
  16. karen4201

    SQL Server version control?

    I'd like to apply the principles of Version Control to my database objects. How are others doing this? I am thinking about saving the db scripts as text files and then using a version control program to organize and manage the text files. However, this puts a requirement on any database...
  17. karen4201

    Project Management for a 15 year Technical person

    Basically, a project is defined as a task that has a beginning and an end. The PMI tries to organize best practices of project management for a project within any field. IT certianly has its own qualities that need to be considered while doing project management, but the basics of PM can be...
  18. karen4201

    can I do a combined update?

    can the update be performed by only doing a set number of items, such as when you do a "select top 20 * from..." ?
  19. karen4201

    can I do a combined update?

    I'm not sure what it would be called, but could this be done? Just as how I could do an INSERT by using a SELECT statement, such as: insert into tableA(the_id, the_date) select tableB.the_id as [the_id], '2006-01-01' as [the_date] from tableB left outer join tableB_other on tableB.the_id =...
  20. karen4201

    set VS. select...difference?

    Thanks for the info. Is there any speed or memory issues that would suggest using one approach over the other?

Part and Inventory Search

Back
Top