Browse by Tags

Problem: Find items from a date and date span that fall between two dates

I have a table that contains the following items: sDate - which is a date for the start of the record cList - which is the length of days the record applies to I want to find all items that fall between two other specified dates. groupID sDate cList 3 11/28/06 7 7 12/6/06 5 10 12/17/06 8 If I search...

Posted to MS SQL Server (Forum) by microsoft on 06-08-2009
Problem: Find date of first or second sunday of month

Hi Experts, I'd looking for the quickest way to find the date of the first or second sunday of a given month. Thanks

Posted to MS SQL Server (Forum) by microsoft on 06-05-2009
Problem: Query to find min/max date for when a list of items appeared in a table

Hello - I have a table with name and dates in a table. For each name I need to find the first and last date for which the name appears in the table. I dont want to run any loops but for some reason can't warp my head around the query. I'll be storing the data in a temp table so if it's two...

Posted to MS SQL Server (Forum) by microsoft on 06-01-2009
Problem: Create table error based on date data type

I'm attempting to do an exercise from Sam's Learn SQL in 24 hours with the following syntax. create table employee_pay_tbl (date_hire date); I'm getting this error and need help. IIt does not like the date data type? I'm a beginner... Server: Msg 2715, Level 16, State 7, Line 1 Column...

Posted to Queries (SQL) (Forum) by microsoft on 05-27-2009

Page 1 of 1 (4 items)

Browse by Tags

Problem: Find items from a date and date span that fall between two dates

Problem: Find date of first or second sunday of month

Problem: Query to find min/max date for when a list of items appeared in a table

Problem: Create table error based on date data type