I don't know if this is the BEST practice, but you could have an update/insert trigger on the table and write the newid value to another table and have your stored proc read that other table. The other table would only have 1 field, the uniqueIdentifier, and it's value would be the last insert/update of […]
2004-07-12
Unfortunately, I don't think that is possible.The problem is the the SQL Server is requesting data from Oracle FROM SQL and SQL has no way of knowing or handling the Oracle indexes.OPENQUERY on the other hand says to Oracle run this and return the data I want... Good Luck
2004-07-08
I want to get the maximum of sum with one select statement. The database is NorhtWind and this is the query. select orderid, sum(quantity) from [order details] where orderid between 11000 and 11005 group by orderid order by 2 desc I know that i can use this statement: select Top 1 orderid, sum(quantity) from [order […]
2004-06-15
2 reads
Thank you so much!!!! what I was concerned with MOST was having 2 databases with the SAME logical Filenames - but I guess it doesn't matter as long as the actual Database name and the PHYSICAL file names are different ???
2004-06-11
Pre-summer Sale - Save hundreds of dollar$ now - 15%Pearl Knowledge Solutions, Inc. is having a Pre-Summer Sale! From now, through July 15, 2004, we are offering a 15% (fifteen percent) discount on SQLCentric server license kits, which will save you hundreds, even thousands, of dollars on the cost of monitoring your SQL Servers.For more details […]
2004-06-08
1 reads
I think the troubleshooting steps already given will help you isolate the problem.As a side note, SQL 2005 (Yukon) will have an SMTP based mail solution which will eliminate the need for Outlook on your SQL Server and the associated problems of MAPI running in the SQL address space.
2004-06-08
dumale,the problem is that to perform this action you need to be belong to windows administrators.
2004-05-27
Presumably you have an ordering sequence?Without details of your table structure the only way that I can think of doing it is by using a cursor, however I would tend to do running totals in a front end app, rather than within the stored procedure.
2004-05-20
Oh, one more thing! TEST, TEST and TEST all your backup/restore and disaster recovery plans!!!
2004-05-18
2004-05-11
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers