Date Range
Date Range
Date Range
Thursday, March 29, 2012. Failed to start jobs in sql agent after restart service. Encountered a problem which failed to start jobs in sql agent after restart. Mssql server and aql agent services. It failed with exception error in the. There is no error message in event viewer and we found an error aqlagent.
Thursday, March 29, 2012. I need to select a sub-set of a dataset.
Thursday, March 29, 2012. I am trying to edit this query i already have that is fully functional for another report in reporting services. The report has visits sales reps made to stores, broken down by period, week and then date. Now, i need to filter it out by Visits. They want the Sales Reps who had less then 6 visits a day.
Friday, March 30, 2012. Finding most recent date? Using query analyzer on a SQL 2000 server. Describing what I want here. Rank, claim number, posted transaction date. Left join pt policy on pt policy.
Thursday, March 29, 2012. Foreign Key and Nullable column. This seems simple but not to me. Now I want to create a new table that. Contains a column such as Product Id. I want to create a foreign key. Constraint on Product Id pointing to a Product table. Column, because that can make query complex and slow. So I like to use 0 to.