Viewing 15 posts - 166 through 180 (of 428 total)
? I think I don't get it? But isn't this simply answered by no longer specifying the columns names as 'Jan', 'Feb', etc, but simply label the columns something like...
March 3, 2012 at 11:01 am
Think of your query this way:
You specify "left outer join" instead of "inner join" to tell sql server to return all rows from TB_inOUt, even if there is no matching...
March 2, 2012 at 1:18 pm
Just for the sake of the discussion, because this is a useless alternative for the OP's question. You could make it execute the max(len()) only once like this:
SELECT LEFT(t2.TEXTFIELD +...
March 2, 2012 at 8:09 am
ColdCoffee (3/1/2012)
March 2, 2012 at 7:56 am
At first thought I was going to say to use the Delimited8K string splitter for this one and then count the number of results. However I think it is going...
March 1, 2012 at 10:21 pm
Jeff Moden (3/1/2012)
It sounds like the OP has unknown length data and wants to size the output based soley on the max width of the unknown data.
That's not what the...
March 1, 2012 at 10:05 pm
The answer has been given multiple times already, so why are you still trying to make this so complicated? Just use convert or cast to convert the string value to...
March 1, 2012 at 5:05 pm
adrian.facio (3/1/2012)
Hi, i like to use this operation. But i must admit it migth be litle costly:select ROUND( 100 * (99.7971), 0) / 100
But why would you do that? the...
March 1, 2012 at 3:50 pm
Isn't it much simpler to just specify the number of decimals in the convert operation? i.e. simply:
select convert(numeric(10,2), 99.9959), convert(numeric(10,2),99.7971)
which returns:
--------------------------------------- ---------------------------------------
100.00 ...
February 29, 2012 at 3:08 am
I would definitly go for splitting the string into rows at the ','-characters using the DelimitedSplit8K procedure. i.e. I agree with "step 1". Be aware though of 2 things: the...
February 26, 2012 at 3:06 am
Hi Brad,
Welcome at SSC. As was pointed out, we can't do much for you without more information about your specific situation. Please provide (an example of) your specific document...
February 24, 2012 at 2:41 am
Again: post some ddl with test data plus the expected output and we'll all be happy to help you. Or in other words: write a little script with a "create...
February 22, 2012 at 10:16 pm
I've used it in multiple scenarios. One is a sql server agent job that I need to be run once and only once at a time. If it is run...
February 17, 2012 at 1:53 pm
My guess would be they were asking for sp_getapplock (link).
February 16, 2012 at 10:03 pm
After a night of sleep I think I understand what you mean: You want all the rows for which at least one duplicate exists, and leave off any rows for...
February 15, 2012 at 10:09 pm
Viewing 15 posts - 166 through 180 (of 428 total)