duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

http://www.sqlservercentral.com/Forums/Topic1360942-391-1.aspx

just to pile on the bad news; Excel 2010 is limited to a max of 16384 columns.

so you need a few more(10+?) worksheets or so.

I've tripped over this with some of our web services.

it has to do with a default limit in the expected string size; i guess MS expected most services return tiny...

is this more of a syntax question, or the wrong applicaiton, i wonder.

i use the command line version of 7zip, which is 7za.exe;

are you using the GUI version? I'm not...

granting access to a database...

i just tripped over this exact lack of planning by the database architect when switching from one insurance agency to another. From Geico to Progressive: I saved 30% or more...

two built in functions should get you what you are after:

SELECT YEAR(getdate())

in SQl 2000, it was certainly possible to leave a setting ON so that subsequent objects were created as system objects.

once an object is marked as a system object, you...

i think it's because of two things:

when you create a SQL user, that implicitly grants the CONNECT permissions; logins from the domain already exist, so it makes sense...

There is no DML Event Notifications;

there used to be a mistake in the documentation that seems to imply it, but if you look at the actual events available, they are...

that's because the old comma syntax didn't support left/right joins without that old =* or *= syntax (or the oracle the old styles pretty muich only inner joins without them

=columnname(+)...

yes it's true; there are two ways to cross join tables.

SQL server supports the old syntax of FROM TABLE1,TABLE2 as well as the more modern, explicit FROM TABLE1 CROSS JOIN...

here's the data as a readyly consumable CTE;

if i knew what the process was doing, we could add a lot more to this:

With MyTableExample ([Doc Number],[Document Date],[Rec Date],[Book],[Vol],[Page],[Doc Type],[# of...

oh yeah, i'm very familiar with the server side trace, but that only can capture the command text that was executed, for example.It cannot catch old versus new values, which...

CptCrusty1 (9/13/2012)

---

I thought I WAS using set-based processing. I"m definitley not using a cursor.....

Pray tell... more feedback on what you're refering to...

BTW... RBAR.......