Tom.Thomson (12/16/2010)

---

WayneS (12/15/2010)

---

We're planning to reschedule it for the LV UG in January - they meet at 6:30PM PST - it will be done via LiveMeeting - is that something...

Michael Valentine Jones (12/16/2010)

---

There are a lot of people that think that if you do a "select * from MyTable" that it will return data in order by the clustered...

Hey Jack, sorry I fell off the earth on this, kind of got distracted with my own local insanity.

How'd this end up working out for you?

The correct answer, then, is: "I don't know, I haven't...

Brandie Tarvin (12/16/2010)

---

Steve Jones - SSC Editor (12/16/2010)

---

I think Intellisense can make this just as bad. If you're used to using "p", downarrow to get to ProductDetail and someone adds...

Well, this depends on how you run it. If they manually trigger the job, they get a little box on the screen showing it's running, then either error or...

TravisDBA (12/15/2010)

---

I worked in a shop where we bantered crudely and rudely back and forth all day. Females were included, even expected to join. The three in the...

Worse in our case is the 'Job built for Bob' scenario...

Heh, and here I just dropped a line on the original article about what Jeff explains clearly in that link above. The division from decimal(x,x), at least on 2k5,...

srinivas-406082 (12/15/2010)

---

I'm using multi value parameters in one of my reports and I'm calling the report from an aspx page.

My report runs just fine when I select one or...

CELKO (12/15/2010)

---

=================

DECLARE

@mon1 MONEY,

@mon2 MONEY,

@mon3 MONEY,

@mon4 MONEY,

@num1 DECIMAL(19,4),

@num2 DECIMAL(19,4),

@num3 DECIMAL(19,4),

@num4 DECIMAL(19,4);

SELECT

@mon1...

Agreed with Gus above, more information about what you're trying to do would help.

If you're just trying to see if anyone uses it (the old, shut it off and listen...

dso808 (12/15/2010)

---

Got it Craig. here it is:

SET @Where = @Where + 'AND ProbTicketSubDept LIKE ''%'' + @_Dept + ''%'' '

All single quotes of course. Seems to be working...

Actually, the WHERE 1=1 is a neat little trick to avoid doing extra if statements to determine if something starts the clause and needs an AND. Since 1=1 is...

WayneS (12/15/2010)

---

Paul White NZ (12/15/2010)

---

The last thing Craig needs...