RE: what is the best way to search between tow date fd
but like your explains i can not search evry day between Getdate() '16:00' and Getdate()+1 '16:00' and in tow different field thnks ilan
2003-07-14
Loop
2003-07-10
1 reads
RE: the best way to transfer data from indexed tables
You'll have the least amount of problems using DTS import/export wizard. Select the source server/database and the destination server/database and choose to Copy Objects and Database between SQL Server databases. Check all uncheck "create destination objects..." depending on your circumstances. If creating new objects at the target, I recommend including dependent objects too. Obviously choose […]
2003-06-14
1 reads
RE: DELETE DUPLICATE ROWS
Jay, i am using SQL server 7.0 Here's the query and the error results: DELETE FROM WTRDET INNER JOIN ( SELECT Order_NBR ,Line_NBR, MAX(Ship_Date) as MaxShipDate FROM WTRDET GROUP BY Order_NBR ,Line_NBR ) AS dt ON WTRDET.Order_NBR = dt.Order_NBR AND WTRDET.Line_NBR = dt.Line_NBR AND WTRDET.Ship_Date < dt.MaxShipDate Error result: Server: Msg 156, Level 15, State […]
2003-06-05
RE: DELETE DUPLICATE ROWS
satish, the AS is technically optional, so you can remove it if you want. Other than that, my colleague and I can't see anything wrong with it. However, to make the query more efficient, I suppose the last line doesn't need to be: AND Orders.Ship_Date <> dt.MaxShipDate. It could be better written: AND Orders.Ship_Date < […]
2003-06-05
RE: SELECT Sum() on big tables
Hi dani_17 quote: I have made I site in asp.net of used cars in the dominican republic. The site is quite successfull and in the 3rd month I have about 1,500 visitors per day and at least I cover expenses 😛 Congratulations! quote: id(int) - id of the car. hits(decimal)- the number of visits the […]
2003-06-05
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers