You guys are doing a great job looking at set based options, well done. As far as the core question of which is better, while loop or cursor, I'd be interested to hear more thoughts. It's easy to dismiss cursors as evil, but they have their place (Im not disagreeing with trying to stay set […]
2004-08-13
Assume the following scenario: a customer wants 10 units A and 20 units B. In stock are (Bad English, I know ) 8 units A and 15 units B, which happen to stem from 2 different lots. From lot 1 are 10 units assigend, from lot 2 5 units. Of course a very crude simplification...I […]
2004-08-10
2 reads
nothing like using a sledgehammer to kill a flea, but how this function which you pass the begin date, end date and what date part you want using 1 or 0 (year, month, weeks, days, hours, minutes) Function is: Alter FUNCTION ExtendedDateDiff(@BeginDate datetime, @EndDate DateTime, @iYear integer, @iMonth integer, @iWeek integer, @iDay integer, @iHour integer, […]
2004-07-13
I got rid of the apostrophes, but I'm a little confused at the connection name, Where do I find the connection name? I have a "Microsoft OLE DB Provider for SQL" and a "Text File (Destination)".What am I not looking at properly? I feel like such a goose.Thanks heaps in advance.
2004-07-12
The easiest thing to do would be to add an update_script column to the table. You can then just put the script that updated it in there. Triggers won't capture this level of detail.
2004-06-28
Try something likedeclare @Remarks varchar(1000) select @Remarks =IsNull(@Remarks,'') + Remarks from .. where ... select @RemarksRegardsZiyad_s@maktoob.com
2004-06-17
talk about covering the bases!!!http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=35674 and the main advice of "supply the real DDL, sample input and expected results".....applies as the best advice everywhere!!!
2004-06-01
Hi,My project manager instructed to develop me a solution: he say"Well Mhadi develop an application so that I can have list of available servers (at remote location), check my priveledge for bakup, give the backup file name and send that file to another city so that thay can backup it on it and have another copy on […]
2004-04-29
Cmartinz,Would you mind posting your revised code? I'm having the same problem and looking for some answers. Not exactly clear on how you formed the CASE statement as a workaround?Thanks. Denise White
2004-04-28
Comments posted to this topic are about the content posted at http://www.sqlservercentral.co
2004-04-26
15 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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