Can't see your picture to know. I have seen it however be a problem with the video card drivers on machines but can't recall if that also translated to printing...

OK didn't realize Table1 could have a value in both Pmi and SMI that is non-null and non-zero so try this

declare @table1 table (PMI int, SMI int not null default...

Thank you. Don't think the functions take that much of a toll on what we have don in the past but weren't very large datasets either. Just posted as an...

"." as I recall implies localhost or 127.0.0.1 (the tcp-ip lookback address). Odds are the reason (local) failed however is becase named pipes are disabled on the server setup.

What DLL does is state is the error. I have seen this before when I reimaged my machine and opened a package with an Oracle connection in it. The issue...

Going to be something like this

'**********************************************************************

'  Visual Basic ActiveX Script

'************************************************************************

Option Explicit

Function Main()

 Dim oPkg, oConn, strPath, cntValue

 Set oPkg = DTSGlobalVariables.Parent

 cntValue = DTSGlobalVariables.[YourVariableYouStoredTheCounInHere]

 'Getting Excel object in use in DTS Package so I...

I need to understand more about what you have (the table strucutre aka the DDL)

There are many approaches for example here is a set based potential using Order Details...

Another alternative for the ON clause of the previous example

Coalesce(NullIf(t1.pmi,0),NullIf(t1.smi,0),-1) = Coalesce(NullIf(t2.pmi,0),NullIf(t2.smi,0),-2)

No sure here but I think it boils down to you need to output your value

EXEC sp_executesql @Sql_sri, @Paramlist,

                             @SearchQuery, @CategorieId, @First_Id OUTPUT

otherwise you only input and...

What tells me what Items go with what Invoice? Can you post the DDL for the tables involved and tell us how the relate to each other.

You state you are adding two columns, even thou these columns may b small adding columns will take a bit on VLDB as the engine has to add to each...

Please do not cross post. See responses here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=394053

Looking for my notes because it wasn't as straight forward as running this stuff but it involved

sp_dropsubscription  - You have to get the subscriptions removed before you can remove the...

Also be carefull of multi instance machines because some licenses allow you to have more than one instance without a new license and others do not.

Here is an interesting article on Stoed Procedures in RoR

http://wiki.rubyonrails.org/rails/pages/StoredProcedures

Which leads to

http://web.archive.org/web/20060418215514/http://www.loudthinking.com/arc/000516.html

which sets the tone for no SPs and whyDavid really did want. Basically all I can...