Steve,

and may I add Technet and MSDN.

A question for you Steve. ...

Having submitted and had published 7 QODs myself I can only say to those of us (myself included) who rant about how misleading a question can be, l It is...

First of all let me state that I am not sure of what you want to do, but if it is to create 5 views each with a different default...

david.c.holley (12/14/2008)

---

If I could write the T-SQL then I'd post it. I am presented the data as it exists in the tables and as I need it displayed. Either help...

Not having that much experience as a developer and even less as a DBA I have followed the recommendation

Because the SQL Server query optimizer typically selects the best execution...

One approach is to create a parmaterized query, using the parameter to pass the user input (be sure to trim trailing blank characters from the user's input) to a dynamic...

Read this article, follow its sample T-SQL code, be sure to scroll down to the explanation for "NTile" and I believe a value of 4 will provide you what you...

If my statistics courses did not leave me .... this is about it

first quartile (designated Q1) = lower quartile = cuts off lowest 25% of data = 25th percentile

second...

For a reasonable short course, but complete with sample code

Part 1

http://www.databasejournal.com/features/mssql/article.php/3773091/SqlCredit--Part-19-Exploring-SQL-2005s-Ranking-Functions--RANK-and-DENSERANK.htm

Part 2

http://www.databasejournal.com/features/mssql/article.php/3780311/Exploring-SQL-2005s-Ranking-Functions--NTILE-and-ROWNUMBER.htm

These articles will definitely get you started.

"If Windows Authentication mode is selected during installation, the sa login is disabled. If you later change authentication mode to SQL Server and Windows Authentication mode, the sa login remains...

This is a cross posting with the General Discussion forum. The posting separated by just one minute .....

Start by reading:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/b0d8769c-7598-4f97-8162-ace5f182b5bc.htm

and then:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/996f2f14-51dd-4e92-a422-d5ab417f2d39.htm

Hope this helps. But note that Microsoft has stated that

ntext, text, and image data types will be removed in a future version of Microsoft SQL Server....

As long as it is NOT more than 3 triggers you can. These 2 links will help you do that

[urlhttp://www.sqlservercentral.com/articles/SQL+Puzzles/triggerstoexecuteinpredefinedorder/2337/][/url]

also:

http://msdn2.microsoft.com:80/en-us/library/ms186762.aspx

Asssumed this was just a posting error.

Using this and creating the view in the AdventureWorks db - it works O.K. returning 52 rows

CREATE VIEW HumanResources.vEmployeesTime

AS

...

Have you looked at the Having clause as used in Group By statements? If not read in BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/463c5e18-f274-474f-9861-1010fe3757b8.htm