Since sp_msforeachdb and the good code posted by Erin both are cursors I figured I would take a shot at doing this without a cursor. This code should also work....

No problem Jim. Glad you figured it out. I will be happy to help you in the future. I can't speak for Chris but I am pretty sure he will...

ravi@sql (3/26/2013)

---

1) Declare @i int=0

select @i=id+1 from user;

select @i

/* here id is an identity column*/

2) select @i=max(id)+1 from user;

...

JimS-Indy (3/26/2013)

---

----------------------

I included the WOError table data above. In all cases, the VendorID in the WOError table matches a tblVendor. In all cases, the TimesheetID refers to a valid tblTimesheetMaster...

Then as Chris eluded to we are going to need ddl and sample data in addition to desired output as outlined by the article found at the first link in...

The script here should get you started.

http://stackoverflow.com/questions/1987190/scripting-sql-server-permissions

ByronOne (3/26/2013)

---

Sorry I should have said, I adapted the code a little but actually as you've indicated it didn't make sense to do so!

I'm going with the original (correct and...

What about order by clauses? Are there clustered indexes on these tables?

ByronOne (3/26/2013)

---

One problem.

I want to sum the PlannedSales then multiply by the factor increase. However I'm getting an error which says I can't have an aggregate in an update...

I...

I will help you but first you have to help me. Please take a few minutes and read the first article in my signature for best practices when posting questions....

The solution that MickyT posted looks like it will probably work for the short term. I can tell you from experience that if business is offering quantity discounts currently, they...

Kingston Dhasian (3/26/2013)

---

You can run the below mentioned query to get the list of comma-separated columns.

You can then copy the results and use them in your SELECT statement

SELECTCOLUMN_NAME + ','

FROMINFORMATION_SCHEMA.COLUMNS

WHERETABLE_NAME...

You really only need two queries for this. Your second and third queries can be easily combined into a single query like this.

SELECT

AcctNo

VirtualName,

Capbal,

VadareRate,

PilPlan,

LoadDate,

case

when LoadDate > getdate() then 'Active'

else 'Inactive'

end...

Can you use CLR? This type of heavy string manipulation is probably going to be a lot easier to work with in .NET instead of pure t-sql.