Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have many records with me for which I need to query the database. How can I write a query that can list down all the resultset at once using my large set of data?

The database that I used in SQL Server 2008

Let me know if you need more clarification.

share|improve this question

closed as unclear what you're asking by Max Vernon, Kin, Mark Storey-Smith, Paul White, Mat Sep 28 '13 at 9:33

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

Yes, I think you will need to clarify what you want to do. I can't really understand your question. –  ConcernedOfTunbridgeWells Apr 11 '12 at 10:22
Also, please work on your acceptance rate by accepting answer to your previous questions. –  Thomas Stringer Apr 11 '12 at 11:57
Do you mean that you have a set of data and you want to generate a query from that set of data to return something from that query? There are a couple of ways of doing this if that's what you mean. –  Grant Fritchey Apr 11 '12 at 12:26
SELECT col1, col2, col3 FROM SQLServer2008Database WHERE col1 IN (SELECT col1 FROM DatabaseWithManyRecords). We need clarificatoin :-) –  MarlonRibunal Apr 12 '12 at 0:25
Grant, Yes you got that right. Its something similar –  Romil N Apr 12 '12 at 8:34