TSQL query

[JimFL]

Hi,

Is there a quicker way using tsql to perform this operation in a single query.

select count(tID)as f into #t from X group by tID
select count(f) from #t

Would appreciate anybodies thoughts on this.

Many thanks in advance.

 

[LNBruno]

Unless you just have to put the count into a temp table:

select count(tID)[s]as f into #t[/s] from X [s]group by tID[/s]

< M!ke >
Acupuncture Development: a jab well done.

 

[JimFL]

Thanks for your help however my table x looks like this and your query doesnt produce my required results.


TABLE x

xID tID
1 1
2 1
3 2
4 2
5 3

So I would be looking to get back just the a count of the different values of tID - in this case 3.

Does that help my scenario?

 

[gmmastros]

select count(Distinct tID) as f from X

Select Count(f)
From   (
       select count(tID)as f 
       from   X 
       group by tID
       ) As A

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[LNBruno]

Jim - yes, that would have been helpful info.

And thanks for picking up my slack (again!), George!

< M!ke >
Acupuncture Development: a jab well done.

 

[gmmastros]

Slacker!

Seriously though, if JimFL had posted some sample data, I have no doubt you would have gotten it right the first time.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[LNBruno]

Thanks, George! I just copied and pasted your comment into my resume! ;-)

< M!ke >
Acupuncture Development: a jab well done.

 

[SQLDenis]

>>I just copied and pasted your comment into my resume!

Slacker you should haved typed it

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[SQLDenis]

>>haved

haved what is that?

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[ESquared]

I think Jim gave plenty of information. His desired results are implicit in the transformations occurring in his sample queries.

[COLOR=#aa88aa black]Cum catapultae proscriptae erunt tum soli proscript catapultas habebunt.[/color]

 

[LNBruno]

Um, no:

http://www.tek-tips.com/faqs.cfm?fid=874

Specifically:

13. If you are asking a question related to a SQL statement, please post the SQL statement and include relevant table layouts, relational information and sample data.

14. Provide sample result (or desired result) of your SQL statement.


It's a lot easier to understand the question when someone's already solved the problem.

< M!ke >
Acupuncture Development: a jab well done.

 

[JimFL]

Many thanks for your help on this problem. The solution above from gmmastros has resolved my issue.

Apologies for the lack of information first time round, I will make sure that I am clearer in the future.

Thanks all