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

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

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

ColdCoffee (3/1/2012)

---

Hey R.P.R , the OP does not want the rows that have 12 values , instead the rows that contain the value 12 ; look at the expected output...

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

That's not what the...

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

But why would you do that? the...

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

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

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

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

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

My guess would be they were asking for sp_getapplock (link).

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