also be careful; I know this is a common homework question in some SQL classes in India, and you don't want to grab someone elses solution.

you want to learn...

ok several dumb questions here:

why do you need to do work via SSMS as different users? why not have a superuser do all the work?

why cna you not simply use...

can you post the ACTUAL execution plan? there's gotta be a difference between estimated and actual to explain such a huge difference.

the estimated plan thinks it will return one row,...

I don't see any reason to use a cursor or lopp structure here;

you can do it all in a single pass.

since the proc definitions can be large, you'd want to...

Evil Kraig F (2/11/2014)

---

That is one LONG way around the pond, Lowell.

SSMS. Open database, click on tables. Go to Object Explorer Details window on right. If you...

good start Knives;

so here's my same query, with your updated data in it;

so if you run this and look at the data, does it produce the desired results?

code]

;WITH

TENS...

can you convert that into a CTE or insert statemetns, the way i did?

Knives85 (2/11/2014)

---

Lowell, JamesM said it, that's a brilliant solution, now that I've seen it, I don't know why I didn't think of it 😀 lol

The code you posted I...

took me a bit for this one; this seems to do the whole shebang

;WITH

TENS (N) AS (SELECT 0 UNION ALL SELECT 0 UNION ALL...

i slapped together a TSQL way to script out a table , so something like this might help; you'll run into issues if the generated scripts are not in foreign...

well i've only done one piece of it...adding the date;

i have a simple macro i use to dump typical copy/paste data and turn it into a CTE, so coming up...

I agree with Welsh Corgi; this sounds like a one time comparison, so there's no real need to add a linked server.

I would use the Import wizard, just has Welsh...

yep , a tally table, combined with a dateadd seems to be what you are after.

I just put together an example, but you'd use your own tally table, and...

don't get caught up staring at the percentages; they have to add up to 100, so just because something is 75% doesn't mean it's bad, it just means that's where...

no; since the leading edge of the first index has the same column, you don't need another index;

if there are WHERE statments on ColumnB only, then an idnex on just...