Search results for query: *

I added an AFTER INSERT trigger to a table. Unfortunately, some application code is using @@IDENTITY to get back the value of the identity column from that table. The trigger does an insert into another table, so @@IDENTITY returns the identity value from that second table and breaks the app...

In all examples of the Decorator pattern I've seen, for example : http://www.dofactory.com/Patterns/PatternDecorator.aspx, the functionality being extended is on a method with a void return type. So it's easy to see how one could add additional functionality before or after passing the...

Hi, warning -the logic here may be flawed (I'm tired...) I'm trying to create a sp to search a catalog database. The view I'm querying has columns like item-name, size, color, description, etc. I want the user to be able to submit a search string like 'small red shoe' and return only...

I found a couple articles that support my feelings on "Context Switching" - that is, having to stop what you're doing to do something else (even for five minutes) costs you orders of magnitude more than five minutes of time wasted. The first, from Joel...

What are the reasons why a table with an Int Identity column would be missing records of certain sequences (aside from someone actually deleting)? The obvious answer is if a record was inserted during a transaction but the transaction was rolled back. But is there some other condition that...

I have a class that needs to implement IComparable. I want to do a multi-field sort, such as a SQL "order by" clause (select * from person order by name, age). So say my class Person has a Name string and an Age int, what would the CompareTo method look like? Public Function CompareTo(ByVal...

Hi, I need to delete about 86,000 records based on the value of a non-key column. After running for about 30 minutes without completing, I cancelled the query. I ran the index tuning wizard on the delete query and it recommended creating a non-clustered index on that column. So I did that...

Could someone please recommend a decent poll control available for asp.net? Need all the features, (reports, customizations, caching, etc) - willing to pay any reasonable price. Thanks! _______________________________________ Business Logic:"AND when tweetle beetles battle with paddles in a...

That's sort of an oxymoron, isn't it? If you're focused on something, naturally you block out all the other stuff. But we need to multi-task. I don't mean multi-tasking as in "walk and chew gum", but in a wider sense like "develop enterprise application A, work on website B, manage servers...

I need a pretty large list of English words (csv, or whatever). Anyone know where there is one available?

This book is from 1996, but it appears to be exactly what I need: how to model a typical financial accounting system. Can anyone recommend this book or another that deals with this domain? Thanks

I've started dabbling in writing some procedures in managed code. My first attempt is a simple function that takes a url, makes a web-request, and saves the response stream as a file to disk. This works good so far! Next step, since the files I'm downloading are JPEGS, is to make a function...

When I look at the script generated for making a change to a table there are some thing I don't understand about transactions. Why are there multiple BEGIN TRANSCATION and COMMIT statements? for instance BEGIN TRANSACTION SET QUOTED_IDENTIFIER ON SET ARITHABORT ON SET NUMERIC_ROUNDABORT OFF...

thread678-1055700 Did you end up reading it? Is is relevant to .NET Remoting?

Continuting on the topic in thread678-1014576 We are going to have a Customer business object, and a serializable CustomerDTO data-transfer-object. A CustomerService class with a method like ListCustomers that returns a list of CustomerDTOs to the presentation layer. How exactly does a...

Hi - I run an ad-serving application that renders flash banner ads to pages. My app supplies the swfs with their "clickTAG" variable (see thread250-926508 ). This has been working fine, but I have run into an ad that is not cooperating. I have not yet seen the code (the .fla) file, so I...

I have a .NET 2.0 winforms app that is having problems on a Windows 98 computer. The app attempts to connect to Active Directory for authentication. I try to create a new DirectoryEntry and get the following exception from this constructor: new DirectoryEntry(string path, string username...

Hello again my friends, I am building a data-processing engine that basically takes a number, performs calculations, and returns a result. Pretty simple. There are going to be multiple processing methods, though, which can be used together in any possible combination selected by the user...

Can someone explain the difference (if there is one) between the following two queries: SELECT c.CusID, SUM(ISNULL(p.Amount, 0)) AS Payments FROM Customer c LEFT OUTER JOIN Payment p ON p.CusID = c.CusID GROUP BY c.CusID SELECT c.CusID, ISNULL(SUM(p.Amount), 0) AS Payments FROM Customer c...

I just installed sql server 2005 on a windows 2003 server. I chose the option to install but do not configure. After restarting, I used the Reporting SErvices Configuration Manager and it all looks ok. When I browse to //localhost/reports I get a rs page with the message of: The request...