I found a way, but I'm having trouble getting it to work.

DECLARE @nvQueryRemote nvarchar(MAX)

DECLARE @nvQueryLocal nvarchar(MAX)

SET @nvQueryRemote = N'SET FMTONLY ON; EXEC iERP81GA_LIVE.vmfg.uspGetAllLocSalesOrder'

SET @nvQueryLocal = N'SELECT * FROM OPENROWSET(''SQLOLEDB'', ''SERVER=(local);Trusted_Connection=Yes'',

...

I'm glad I'm not the only one. Immediately after typing this email, I did it four times on the same field (a four-word heading). It just sucks that...

j_e_o: I don't think this is always the case. You might need to find a different job. I'm actually really happy with my work/life balance, and I've...

I actually do the same thing with my data warehouse, having seperate keys for N/A and Unknown. If there really wasn't a part sold on an order line, then...

It's as they say: no matter how good a thing is, there is always such a thing as too much of it.

There is always a time and place for NULLs. Think "Address Line 2" type fields. Chances are, the value in those type of fields are NULL more often...

I swear this worked at one point in time, but for some reason it doesn't now. I never used it directly, so it just ended up in code base...

Michael Valentine Jones (8/26/2010)

---

If you are really valuable to the organization, you should make a point of taking a long vacation every year so that people have to get along...

We really are in the business of "soft" benefits. It may be difficult to analyze the benefit of changes like you said, but we've generally got a good feeling...

Didn't you ask if it could be done in one SELECT statement? I agree that I would stay away for the WHILE statement if for no other reason than...

Alright. I use a script to drop/recreate that table every day anyways. I'll just modify it to the new filegroup, and let it do all the leg work...

Beautiful. Thanks.

One question. All the examples I'm finding online of "MOVE TO" assume that the PK and clustered index are one in the same. That's fine for...

I did this once for a 1-column report (long list of parts), which I actually displayed as 10 rows across. I did this by adding two fields to the...

The preferred way would be to use a tally table.

; WITH

t1 AS (SELECT 1 N UNION ALL SELECT 1 N), -- 4

t2 AS (SELECT 1 N FROM...

As a systems/business analyst, my job borders on accounting a little more than I like sometimes. Every aspect of my job is financial: my time has a very real...