You will need to create your SP wit the max number of parameters allowed and then design the logic around them based on their values. if you are using those...

If you resut set:

1) is just for reporting purposes

2) will be no more than 65K lines

just use the excel functionality to connect to the SQL DB and crosstab the data.

Else...

You are right about declaring a local variable inside the SP, however, you can declare it as an INPUT parameter and never pass a value, in other words, pass a...

I have seen it before.

Right click on My Computer icon, select manage, Open the Event Viewer Tree, Select Application and check there for the time of the error to see...

what you want is to group by column1 and 2 and count column2 then PIVOT the results

Will this HELP?

declare

@Table1 as table (

IDENTITY_KEY

int

,PARENT_CODE int

Sorry I cannot offer additional help. I took the programmer approach..."puched the car up the hill and puched back down". I did not have any more issues after the re-install. And...

Try this using the same logic as above:

SELECT

*,(select count(value) as

To find out the "schema", which in this case I think will be the database in ORACLE go to the Object Explorer expand the Linked Servers branch to the Tables...

Try this to see what happens

update linkedoracleserver..ORACLETABLE

set fieldname = 'TT'

Open a new query window switch to the DB in question and run: select * from

David you are not alone. Same happened to me a couple of months ago. I posted the message here, even sent to a MS contact and got no answers. All...

Your issue rings a bell, but cannot remember exactly the solution. Check your SQL Server Configuration Manager \ Network configuration and there the "VIA Properties" Virtual Interface Adapter protocol. I think...

I will assume your TempDB is on the C drive under the SQL directory and it is filling up your drive space which is causing problems.

So, go ahead and move the...