Viewing 15 posts - 3,991 through 4,005 (of 4,080 total)
You can't insert values into calculated columns. The answer is to list all the columns.
Also, you are looking for trouble by doing a...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 7, 2008 at 10:45 am
Hey Seth,
Work got busy so I had to leave this behind. Please let us know if you pursue it. I don't expect my cte-on-cte...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 6, 2008 at 12:16 pm
(Conceding in advance that if you answer Jeff's question he will know a better way...)
This approach can handle your search, but comes with two caveats: (1) It involves creation of...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 4, 2008 at 5:48 pm
Without seeing it, there is not much way to see if there is a way to locate the value to be replaced and fix it with string manipulation. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 4, 2008 at 4:59 pm
Mark, please consider something like this as an alternative solution to the cursor approach. On my box, this is running in under 1 ms, while the cursor...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 4, 2008 at 4:57 pm
Arrrrrrgggggggggg CURSORS!!!!
MY EYES!!! :w00t:
I'm blind...........:cool:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 4, 2008 at 3:59 pm
Look at your where clause: @col = @search !!!
Using your input parms you are asking for rows where '[1]'='how'.
Usually you have to...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 4, 2008 at 3:43 pm
Glad you got an answer Mark. Sorry I couldn't get back to check on this quicker.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 4, 2008 at 2:49 pm
I just have to ask... does this have to be a view? If you call a stored procedure you can build a solution that will run more...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 3, 2008 at 5:00 pm
Michael, I'm posting this message a lot today, but it would be really helpful if you could post up some sample data and expected results.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 3, 2008 at 4:51 pm
How complicated is your malformed XML? Can you paste a sample here? You may have a potential solution just using string manipulation. This...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 3, 2008 at 4:36 pm
Mark, it would be most helpful if you could provide an example (or better yet examples) of input data in table form and what you would expect the output from...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 3, 2008 at 4:19 pm
Here's an example of parsing using a tally table, but the article is really worth reading. This example creates the tally table on the fly from CTE's,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 3, 2008 at 3:32 pm
smunson (11/3/2008)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 3, 2008 at 3:19 pm
Garadin (10/30/2008)
NO BREAKS FOR YOU!
Tough crowd today....
Hey! I got the quote to work!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 30, 2008 at 2:50 pm
Viewing 15 posts - 3,991 through 4,005 (of 4,080 total)