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...

Lynn Pettis (8/7/2012)

---

On a lighter note; with the help of my oldest daughter, my middle daughter is going to be attending Embry Riddle Aeronautical University in Prescott, AZ starting this...

morepainot (8/7/2012)

---

Ok, so I am pretty much through my script. I am getting 2 errors througout the script and of course I dont know why. I think its because I...

Sounds like an interview or a homework question to me. 😀

Something like this is what Dwain is talking about.

create table #Something

(

ChildID int,

ChildName varchar(20),

ParentID int,

PID int

)

insert #Something

select 100, 'Bingo', 200, 1 union all

select 101, 'Pingo', 201, 1 union all

select 102, 'Zingo',...