| Recent Answers from David Vaughn |
 |
2008-10-21 SQL 2000 query to get time difference between adjacent rows: I need some questions answered first. 1-Your question text says "SQL 2005", but your subject says "SQL 2000". Which is it? 2-Is there NO other column(s) in the table by which the rows can be uniquely...
|
2008-10-20 Retrieve the parameters form a stored procedure: For SQL 2000, try this (substituting your proc name for "XXXXXXXXXXX", and removing the "and ssp.name=N'dbo'" or changing "dbo" to the appropriate owner as necessary) SELECT param.name AS [Name]...
|
2008-10-07 And what if ...: If you don't have appropriate permissions to the other database (either directly or via Active Directory groups, local groups, and/or Database Roles), then you cannot see the data there. That is the purpose...
|
2008-10-07 About Dates: What do you mean by "Week"? Do you mean "Week of the month"? If so, what are you using to determine that. Also, since 9/28 is the 5th week (of September) 10/1 is the 1st week (of October) and those...
|
2008-10-02 Select one record every ten, hundred records: If I understand correctly, you have a table that gets a new row inserted each minute. And for a give time period (say, 1 day), you want to select a sample of those 1440 rows (24 hours * 60 minutes) such...
|
| More Answers for "MS SQL Server" |