kyagi.jo (8/7/2015)

---

I did think that would have been likely, does anyone know if there there are any resources on the internet that might give me a headstart on getting this...

ShorePatrol (8/7/2015)

---

Hi Folks,

I have some indexes over 30% fragmented. Some are much more...

I have a job maintenance plan to "re-organize" indexes every Sunday on all databases. I didn't know if...

Thanks for the question. Good one to end the week with.

j-1064772 (8/7/2015)

---

[font="Comic Sans MS"]OK, I though it was something that was well known and that someone would clarify. Given your level of experience I have to take your comment seriously...

kyagi.jo (8/7/2015)

---

Hi,

I have a problem at the moment, where the client wants to be able to type in a custom algebraic formula with add/minus operators, and then to have...

ChrisM@Work (8/7/2015)

---

Sean Lange (8/7/2015)

---

j-1064772 (8/7/2015)

---

[font="Comic Sans MS"]One simple improvement would be to avoid DDL in the middle of DML statements.

Move to the top, before any DML the following:[/font]

[font="Courier New"]CREATE...

Lowell wrote up a script to do this sort of thing in the past. I will ping him and see if he can post script in here for that since...

j-1064772 (8/7/2015)

---

[font="Comic Sans MS"]One simple improvement would be to avoid DDL in the middle of DML statements.

Move to the top, before any DML the following:[/font]

[font="Courier New"]CREATE TABLE #results(...[/font]

[font="Comic Sans...

Andrew P (8/6/2015)

---

I don't think you need that COALESCE call. NULL > 0 is not true, so [ID] > 0 should be equivalent. My memory is a little rusty on...

WhiteLotus (8/6/2015)

---

Thanks for the reply . I wonder how to combine that statements into my current script . I want to rewrite the current script but have no idea how...

Great. Glad that worked for and thanks for letting me...

If I understand the problem correctly this should work.

select *

, case when DEPT in (102, 103) then SEC1 else isnull(SEC1, 'Y') end as NewSEC1

, ISNULL(SEC2, 'Y') as NewSEC2

from EMP_INFO

where DEPT...

Lynn Pettis (8/5/2015)

---

Sean Lange (8/5/2015)

---

GAH!!! Sometimes I hate having to work with so many different versions of sql all the time. I have been beating my head against the wall...

GAH!!! Sometimes I hate having to work with so many different versions of sql all the time. I have been beating my head against the wall trying to write a...

Ed Wagner (8/5/2015)

---

Or just create the objects in tempdb. :hehe: