There may be somebody else with knowledge of some tool that can do this but it seems pretty tough. It is kind of like asking "what data is missing from...

Wow that is nasty!!! I can give you some general direction but beyond that the details are going to be blood sweat and tears. I would approach this as multi...

That seems like a totally impossible (or at least inaccurate) task. How would you be able to locate processes or services that might be logging in using a given account?...

Pham Tuan Phat (9/14/2011)

---

Please tell me how to get a field value in the After Update trigger?

Suppose I have a trigger:

CREATE TRIGGER myTrigger ON myTable

AFTER UPDATE

AS

BEGIN

If UPDATE(column1)

begin

-- Here I want...

Unless your data actually contains the single quotes. Here is sample data to see if this can help fit your needs.

create table #Temp

(

grp_key int,

grp_name varchar(25),

Client_List varchar (80)

)

insert #Temp (grp_key, grp_name,...

select column from table where Client_List like '9%'

Not really, most of the time the order will...

You can't do that quite like that. You have a couple of choices. You can either live with the location of the column, which as far as sql is concerned...

todinhkhoi (9/9/2011)

---

From the query below, I wanted to pull out just two attributes of the students (sgrsatt_atts_code) - NMS and NMF. And I also wanted to just choose the...

Nice job setting up the ddl and sample data. You have to use a recursive cte for this.

declare @IntroducerID int = 2

;with cte as (

select ID, IntroducerID from #temp...

gmrose (9/12/2011)

---

I don't claim to be an expert in either SQL or Excel but I tested the method shown above with the original data values given and that method does...

Here is a quick and dirty proof.

CREATE TABLE PS_TestForOnline

(

number int identity,

);

INSERT INTO PS_TestForOnline default values

go 100

select * from PS_TestForOnline

select MAX(number) from

(

select top 95 percent number from PS_TestForOnline order by number

)...

Well then....

select MAX(number) from

(

select top 95 percent number from PS_TestForOnline order by number

) MyAlias

You probably want a bit more sample data to prove this but it should be what you...

OK so how did you come up with 754.25 from your sample data? It would seem that with your data 95% of them are no greater than 20. If you...

Evil Kraig F (9/12/2011)

---

I'm not sure of how your calculation would work. Can you help explain what the '95th' percentile is? I can't seem to easily grok the...