inf1154 (5/2/2012)

---

thanks it walk but i gat another problem please it is in german

/**

* when i try to change this operator '= ' to 'IN' i get a...

It's happened to us all at one point or another! No probs glad to help 🙂

At +12K points you must know the points system inside and out...

First will take the first row in the dataset (after all sorting ect) so in this case its not needed as we want all rows to be evaluated

Cheers

Andy

Does this help?

=iif(Fields!related_ticket.Value = " ", true, false)

Andy

BrainDonor (5/1/2012)

---

One way to do this:

CREATE TABLE #Temp(

Rack_LocationVarChar(50)

);

INSERT INTO #Temp(Rack_Location)

VALUES('c1'),

('c10'),

('c25'),

('c100'),

('c3'),

('c102'),

('c12'),

('c2');

select *

from #Temp

order by Rack_Location;

select...

Hi

Assuming you only ever have one non numeric character at the beginning this should do the trick:

DECLARE @TEMP AS TABLE

(VALS VARCHAR(10))

INSERT INTO @TEMP

SELECT 'c1' union all

SELECT 'c10' union all

SELECT 'c100'...

Using a Function is not the best was as it will have a negative impact on query performance.

Andy

These return DateTime the OP wanted Varchar :hehe:

Hi

Does this help?

DECLARE @Date DATE = '13-05-2012'

SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@Date)-1),@Date),112) AS Date_Value

Andy

A point per post I believe.

You can also get points for answering the question of the day correctly the amount of points depends on how many have been allocated to...

Are you certain its a carrage return?

This works

SELECT Addr,

CHARINDEX(CHAR(10), Addr, 1),

LEFT(Addr, CHARINDEX(CHAR(10), Addr,...

Ryan Keast (4/26/2012)

---

Thanks. I tried your code but get the following error -

(2 row(s) affected)

Server: Msg 536, Level 16, State 3, Line 1

Invalid length parameter passed to the substring...

Edited as misread post

There are LOADS of links on the web here is one for the Kimball website, I'm not saying this is the definitive place to look for ideas and strategies but...