Search results for query: *

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...

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...

wow. that's it! Thanks :)

Here is a very modified version of the trigger. It's enough to show the logic of the trigger, but I had to modify some info so that I could post the question: CREATE TRIGGER [person_tbl_trigger] ON [dbo].[person_tbl] FOR INSERT, UPDATE, DELETE AS declare @my_id varchar(100) declare...

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...

Hi, Thanks for the suggestion. I apologize for not including everything in my code question....here is most of what I truly have in my db function: set @nameStr = 'aaa,bbb,ccc' set @case_str = replace(@cases,' ','') -- get rid of spaces set @case_str = '''' + replace(@case_str,',',''',''') +...

I have a variable that doesn't work properly, but 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...

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...

thanks for the tips :)

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.

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...

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!

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...

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...

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!

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...

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...

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

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 =...

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