jvanderberg (4/21/2010)

---

It's also worth noting that I have never handed over a project that wasn't paid for. I accept a deposit, do the work, demo it from a development...

Steve Jones - Editor (4/21/2010)

---

I tend to agree with bitbucket. Hire a lawyer, decide what to do.

I might also spread the word to other consulting companies in the area that...

Micheal.

I don't know the whole story here, but I know that management changed hands at least 2 times in 15 months and that this is one of the reasons of...

Elliott W (4/21/2010)

---

First forcing a shutdown could be considered criminal, so be VERY careful with that.

I wouldn't provide one additional line of code or ANY support.

I would tell your boss...

Michael Valentine Jones (4/21/2010)

---

Tell them to pay your boss everything they owe him first and you want a $10,000 retainer before starting any work.

That should cut off any further discussion....

Or plan B if you'd rather not wait... just add this where you need to debug

SELECT * FROM #tmp from @table

I've seen slow reports because of he rendering... but I'm talking here about 30 000 rows being pivoted into a matrix with 3 levels of groupings on the columns and...

Same way you tune everything else. Find the most consuming queries and start with those.

You may also want to scan for the rendering time of the reports and also...

That could work but it's just a guess with the info you supplied.

LEFT(@Str, LEN(@Str) - 1)

Did I say prod?, I meant pre-prod :-P.

No seriously...

Thanks for the code. However it seems to be on the slower side of things. I takes about 47 secs to run with 20 while I have 1...

tony.turner (4/14/2010)

---

Is it possible to get the stored procedure name from a trigger when an update operation was performed? I need to know which stored procedure invoked the trigger on...

Yes Lowell I can contradict you.

Install sequence :

2008 enterprise trial

sql 7 client tools (windows xp... not compatible with vista)

2005 enterprise trial

I had both db engines with SSRS, SSIS and...

I tried with those values... and I got only 319 rows back... only 1M short of the correct answer

DECLARE @People TABLE (Person VARCHAR(50))

INSERT INTO @People VALUES ('0')

INSERT INTO @People VALUES...

eswar.l (4/16/2010)

---

No, it is not possible. Even if you install it would launch them as SqlExpres for 2005 and the sql server 2008 with the sql server. In Services.msc,...