Jeff - If you can talk Steve into it - you can have...

J -

Click on his name on the left - you should get an option to "send an e-mail" to him.

ALZDBA (4/3/2008)

---

Dynamic paging ... :Whistling:

In my SSC-forum-profile I've set...

I'd have to say you have a "bad" query somewhere. Something like an accidental cross join between several large tables. In order to match up the rows, it...

antonio.collins (4/3/2008)

---

to add to mark's comment...

ideally, the FROM clause should describe how the tables JOIN together (dept join emp on dept.deptId = emp.deptId) and the WHERE clause should have criteria...

GSquared (4/3/2008)

---

I like using ApexSQL Diff (similar to a RedGate product). Checks for differences between dev and test, and differences between test and production. Generates the scripts for...

Lynn Pettis (4/3/2008)

---

If your table had 10 rows whaere ID = 1 and 10 rows where ID != 1, your query would be thus

select * from MyTable

if you insisted on...

There's really no reason you can't do it directly in the ON statement:

select b.emp_nbr, begin_rng, end_rng

from range a

join emp b

...

Remember that LOGICAL AND is the "opposite" concept of what "conversational language...

How as in what command is being used to output to the file? BCP? OPENROWSET?

davidsalazar01 (4/3/2008)

---

It's being called frequently and I'm not sure what it's purpose. I kinda inherited the object when I took over. I know that doesn't really help but...

Michael Covington (4/3/2008)

---

I have a variable length flat file that is defined by a "record type" value (first two characters in each row), for example:

01value1value2value3valueINEEDvalue4value5

02newval1newval2newval3

03anotherval1

04differentval1differentval2differentval3differentval4differentval5differentval6

I can read the source file...

GSquared (4/3/2008)

---

I've seen actual portability on real production databases with very complex code.

To achieve it, you unhook the server from its rack, load it up on a dolly, trundle it...

Grant Fritchey (4/3/2008)

---

There is nothing I hate worse than googling a question and finding the place I posted it to as the first response. It never bodes well for getting...

It doesn't protect DDL of physical objects. Meaning, as far as I've seen so far - it...