On Mon, 30 Apr 2007 10:06:00 -0700, RFrechette wrote:
Hi Hari,
I'm sorry I didn't explain myself very well.
What I was trying to do was get all files that are 7 days older than today.
Hi Rachel,
SELECT oss_tran,acctno, oss_tran.[date]
FROM oss_tran
WHERE oss_tran.[date] >= DATEADD(day, -7, CURRENT_TIMESTAMP);
* Note that I used DATEADD instead of the non-standard method of
substracting a number from a datetime, and that I used CURRENT_TIMESTAMP
instead of the undocumented GETDATE().
Re: SQL Humor ...Hugo Kornelis wrote: ...SQL Server will often produce the same execution for both versions. ... the big questions for the RM, *for me* seem to include view updatability which has to do with the operators of the algebra as well as whether a relational engine can implement customary features such as concurrency control and presentation coherence without being written in a language that eschews the relational operators.... (comp.databases.theory)
Re: Help with missing data in query ... I did go to that site But I couldn't figure out how to upload anything. ... GROUP BY m.MonthName WITH ROLLUP...Hugo Kornelis, SQL Server MVP... (microsoft.public.sqlserver.mseq)
Re: How to Gnerate a Random ID Number ... formula with a seed as input to get at a pseudo-random value?) ... that definitely rules out newid() as a "good" pseudo random number ... this on SQL Server 2005, and the seed does not seem to be reset (or at ...Hugo Kornelis, SQL Server MVP ... (comp.databases.ms-sqlserver)
Re: Not passing back values on an if statement ...Hugo Kornelis wrote: ...SQL Server has to check not only that a row ... > column Application doesn't allow NULLs,... This email account is my spam trap so I ... (microsoft.public.sqlserver.programming)
Re: mssql: insert into syntax ...Hugo Kornelis writes: ... > Your mention of preserving order when rows are deleted makes me think ... INSERT tbl... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... (comp.databases.ms-sqlserver)
