Can you post ddl and sample data for your table? Then a clear definition of what you want for results. Take a look at the first link in my signature...

Another debugging tip, select your sql before you execute it so you can tell what it is you are going to run.

SELECT @sql

Well the cursor is the problem. 😛

You don't have a fetch_next inside the body of your cursor so it is an endless loop.

Depending on what your proc "pdashboard" does you...

In reference to your upgrade you describer it perfectly. It might be the word you are looking for is "broken"? We often say something is broken when referencing a portion...

You can create your own logins if you are using sql authentication (ie. the database connection will provide a username/password).

Lynn Pettis (4/18/2012)

---

The Dixie Flatline (4/18/2012)

---

Lynn,

My wife is a special education teacher with a lot of training and experience in behavior modification. She has taught me...

jonathanalvestad (4/18/2012)

---

Hi, I have some questions regarding setting up a database.

How do I set up a database so that Clients visiting the web page AND someone from a stand...

Your original query created a cross join because you used a comma separated list of tables and did not add the join condition in the where clause. This is one...

I am kinda swamped this morning but I did take a quick look. I would HIGHLY recommend you take a look at the link in my signature about a string...

Just curious which method suggested...

Thanks for the ddl and sample data. Can you explain what you are trying to do? What does the commented stuff about @plant_code do? What you have posted will just...

Lynn Pettis (4/17/2012)

---

ScottPletcher (4/17/2012)

---

Is that really necessary?

Won't SQL treat computations on a declared variable as a constant, so...

andrew gothard (4/17/2012)

---

Sean Lange (4/16/2012)

---

hbtkp (4/16/2012)

---

i dont know what is cumulative formula.

but this is how i am getting my final data in report.

so based on how they calculate , i...

Select count(*) from TimesAskedForDDL_AndSampleData where UserName = 'hbtkp'

Msg 8115, Level...

Here is an example with some data.

--these are your parameters

declare @date1 datetime = convert(datetime, '20120201')

declare @date2 datetime = convert(datetime, '20120406')

select @date1, @date2

--now we want a variable to hold these calculated...