Excellent method of placing an index on a UDF. However the 32 level limit of UDF's is annoying when we have a recursive relationship. I have recently been looking at the nested set model and this seems to have a lot to offer if the recursive level goes beyond 32. Takes a little bit of […]
2003-06-18
Hello. Based on your post you could take it a step further and create a temporary table instead of a cursor and use a function to assign the appropriate value to the column. When finished select the rows from the temp table. Everett
2003-06-16
I may be over-simplifying this, but: SELECT col1, Max(col2) FROM t1 GROUP BY col1 --SJTerrill Ah, I'm definitely over-simplifying. I believe you'll have to resort to subquery to return the contents of the whole row. Edited by - TheWildHun on 06/12/2003 12:49:27 PM
2003-06-12
2003-06-11
We are doing something similar, but not because of the primary keys though...Anyway, what we did was create triggers on the base tables for insert/update/delete that will insert a record into a "queue" table. You must have some sort of identifiers on the base tables that you can use to determine which rows were changed […]
2003-06-11
2003-06-04
Thank you so much Julie... Your comments certainly were helpful. Also if anyone knows if using DTS would be the best most efficient way to import the data and/or are there other utils that anyone may be able to suggest which could possibly do a better job. Thanks again in advance for any information Pharoah35
2003-05-30
As a Software Engineer, I would like to replicate a copy of my database...
I have heard about many interesting things about programming in Rust and I decided...
A recent Microsoft outage caused by a bad patch pushed out to Windows instances...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers