riya_dave (4/18/2012)

---

declare @P1 nvarchar(32)

declare @mtd2 float

declare c1 CURSOR FOR

select account, MTD from #temp2

open c1

FETCH NEXT FROM c1

INTO @P1,@mtd2

WHILE @@FETCH_STATUS = 0

begin

if(@mtd2 IS NULL )

BEGIN

declare @IRR2 float

EXEC pdashboard

select...

polkadot (4/18/2012)

---

There's my attachment. Bingo. Thanks Carpal.

Lyn, I've already provided the DDL, which is what I think you're asking me to do. If I could create a query that...

ill also say that if the tables in the view have indexes specially designed for the view it can be very fast.

this should get you close

;WITH CTE(n) AS (SELECT 0 UNION ALL select TOP 500 ROW_NUMBER () OVER (ORDER BY (SELECT NULL)) FROM sys.objects a, sys.objects b)

SELECT B.N + 1, syst,...

Lynn Pettis (4/18/2012)

---

Have you setup database mail for SQL Server Agent? IIRC, this is a separate step from just setting up database mail. Sorry if I'm not sure,...

SQLKnowItAll (4/18/2012)

---

I don't like the open source idea... BTW, open source <> free.

I would design a solution with 1 or 2 reporting servers that get the data replicated to them...

ok you have your join backwards. if you have the tables set like so in your query: table1 view1. now a left join will give you...

man-boy-ish

Lynn Pettis (4/18/2012)

---

SQLRNNR (4/18/2012)

---

that kind of blatant hijacking needs to...

This will help you with the code http://remidian.com/mssql/t-sql/cursors-in-tsql.html however if you post the full code of your SP and the table definitions (DDL)...

Lynn Pettis (4/18/2012)

---

The Dixie Flatline (4/18/2012)

---

GilaMonster (4/17/2012)

---

The "Mr I don't have a clue" thread is starting to resemble a pile-on. Maybe better to just ignore him or at most one...

EDIT: nothing constructive said and thinking about it after the post its better not to post it

Sake

ON TOPIC: http://www.sqlservercentral.com/Forums/Topic1285488-392-1.aspx

The OP needs some help on weird date time conversions when trying to get DDL and Sample data together. Looks like a local setting on his SQL...

im not sure whats going on but i thank you for taking the time to read how to post to the forumn and working up the DDL and Sample data....