Ok... fair trade... I give you a solution... you tell me what you're using to format you code for the code entries on this forum... (please :))

--=====================================================================================================================

-- ...

You are correct... BCP can write anywhere that the server can "see". The SQL Server SERVICE must have a Windows Server login that can "see" the UNC path that...

marcelo (8/8/2008)

---

OK. Per example:

first matrix

|jun |jul |aug |total

aaa | 10 | 20 | 15 | 45

bbb | 5 | 7 | 10 | 22

-----+----+----+----+-----

total| 15 |...

Buzz (8/8/2008)

---

Thanks Jeff, good article. My solution definitely fits into that category and would probably only work for a very limited number of rows...not a good solution.

With that said,...

Two way street, here... would you mind posting your solution? Thanks. 🙂

Heh... oh boy... some folks are really gonna hate me...

Absolutely the dumbest code I've ever seen is....

SELECT sometestformula from DUAL; :P:P:P:P;)

You mean to tell me that LDAP queries can't change the format of the date?

Sum of all individual items plus their sub-totals is always twice as large as the subtotals themselves. Sum everything and divide by 2.

Grant Fritchey (8/7/2008)

---

Thanks for all the responses.

I got one yesterday, I think it was maybe the third one I've received over the years (I'm hardly one of the "go-to" guys)....

Yes... you need "BulkAdmin" privs...

Ankur,

Please see the following link for the answer to that question and, I'm sure, more that you...

Lori Fortner (8/7/2008)

---

Statement_num Fees_Due Initials Fees_Billed Credit_Amt

1007 ...

Two way street here... if...

giontech (8/7/2008)

---

Is there a way to do sum distinct in reporting services?

I have a matrix with two column groupings and subtotals for each of them, but I can't find a...

Angel Miranda Nieto (8/7/2008)

---

Hello to everyone, I try to explain my problem, i need with BCP utility put a file in remote machine, I writed this script exec master..xp_cmdshell 'bcp...