This sounds a lot like homework. As such you will find people here willing to help guide you but not many that will provide you with code. The reason is...

No worries. It is hard to put your thoughts on "paper" in such a way that others can understand it. It seems that perhaps you read the article I suggested....

Thanks. Now if we can just the OP to clarify the question we can knock this out in about 3-4 minutes. 😛

You can't execute a query against a variable like that.

select @execquery = N'Select * from dbo.' + quotename (@tablename)

EXECUTE sp_executesql @execquery

This is where I am stumped. After I execute the...

mick19790 (8/7/2012)

---

I have alot of data that has continuous outputs.

I just wanted to know how i go about permutating ever pair for classifcation.

Literally 200 000 cases.Too much to do...

alen teplitsky (8/7/2012)

---

select run_date, server_name, database_name, table_name, rows

from table_rows as a

where run_date > GETDATE() -1

order by server_name, database_name

i have a table where i import row count data for master and...

Duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1341531-391-1.aspx

mick19790 (8/7/2012)

---

Can anyone assist me on how i go about arranging data that i used as continous input,to data that goes through pair combos for binary output.ie

...

In my experience the DTA is pretty suspect about the suggestions it makes. Definitely use the suggestions with a grain of salt.

It sounds to me like you need to...

Just use DBCC Timewarp and you can the Harley today!!!

The funny thing is that your points show as 9,990 next to your icon but shows as 10,000 on the last...

You might also take a look at Gail's blog post about "catch all" queries. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

She does a great job of explaining some options and how best to code for scenarios...

SQLRNNR (8/7/2012)

---

Luis Cazares (8/7/2012)

---

SQLRNNR (8/7/2012)

---

mtassin (8/7/2012)

---

And what happened to Steve's statement of NO MORE IMAGES for queries?

Steve? Come on...

Not that it matters for this one... but it did...

Luis Cazares (8/7/2012)

---

SQLRNNR (8/7/2012)

---

mtassin (8/7/2012)

---

And what happened to Steve's statement of NO MORE IMAGES for queries?

Steve? Come on...

Not that it matters for this one... but it did look...

gerard-593414 (8/7/2012)

---

Hi Thanks for your reply

So, I gather then that ypu need to mention the Parameter twice ?

Once just after the Procure name

....ALTER PROCEDURE [dbo].[TestSPR]

... @P1 int

and again in the...

Because you didn't define your scalar inside your string.

The bad part of this is that you receive @p1 as a parameter and then you execute it. That is probably the...