Recent content by kermitforney

I believe the branch you would like to keep is titled "Management Tools".

If I have a user set up in SQL Server w/ Windows Authentication as both a login and a member of a group, do the groups rights and privileges supersede the login's or vice-versa?

RiverGuy, FTW!!!!!!! The partition by and rank functions just saved my ass. If I could give you 54,000 stars I would! Thank you sooooo much!!!

I should have given a more thorough example. Rank, Type, ItemDesc 1, 1, Basketballs 2, 1, Soccer balls 3, 1, Baseballs 4, 1, Volleyballs 1, 2, Hoop 2, 2, Goal 3, 2, Bat 4, 2, Net I need to select the bottom two from Type 1 followed by the top three in Type 2, but return them in the same...

Crud, I forgot to include that the amount of rows would be dynamic and based on a value in the table.

Not sure what this type of query would be called. I apologize if the title is confusing. Gist: I need to exclude the top count of rows from a query. The example below is to better illustrate this. Example: Table Data ID, Rank, ItemDesc 1, 1, Basketballs 2, 2, Soccer balls 3, 3, Baseballs...

Correction: This is how the query results would read. Ex. Store#, DaysServiced, ChangeDate 1, 7, '1/10/2010'

Forgot to add the Faux creation script: CREATE TABLE [dbo].[tblHistory] ( [lngServiceFreqHistoryID] [int] IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL ,[lngStoreID] [int] NOT NULL ,[tntServiceFreqDays] [tinyint] NOT NULL ,[datCreated]...

I have a basic audit/history table that I am querying. The table is pretty basic, the columns are as follows: ID, Store#, DaysServiced, ChangeDate A record is inserted every time a store's DaysServiced has been changed. Basically, what I need from this table is whether or not a store has...

Tested and works great! Select CONVERT(VARCHAR(5), GETDATE(), 101) Thanks again GM!!

Trying to take a DATETIME data type and CAST/CONVERT it to just display as month day or mm/dd 04/04 and leave off the year. Have not been able to find this anywhere. Thanks in Advance.

My issue is with dealing with "null" values. :/

Anyway to calculate an average across a row, without using a cursor? Ex. col1, col2, col3, avg of columns 1, 2, 1, 1.33 Thanks,

YEEEHAH!!! I ended up going with GM's suggestion, I have twelve dated sets to work with and an endless self join wouldn't be too efficient. Thanks, to the both of you and double thanks to GM for the solution, plus explanation!

How do I summarize this data to display like this: 1 Toy Balls A B C 1.09 2.09 3.09 ??? Thanks! lngItemID strDescription Date1RANK Date2RANK Date3RANK Date1PPP Date2PPP Date3PPP ----------- -------------- --------- ---------...