Database

Ashfield wrote: A bit of a sweeping staement there That's why I stated it as a personal view, and yes it must be driven by the business requirements every time. I generally work with batch processing and rarely need trans. Ashfield wrote: Dad records with no Child records I would assume that unless the business required the relationship - dad does imply it I must admit.

softdev_sup wrote: well man i am doing this for almost more then 7 years but still in search for better solution Then that maybe suggests that replication is the best solution - after all, thats what it was designed to do, keep databases syncronised. Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

Try a different cd/dvd unit - I had exactly the same problem over the weekend. Used an external USB dvd and no problems.

call dbo.aspnet_Users_DeleteUser to delete the user account. Hope this helps. :rose: Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

Locate a Training Center Near You[^] "My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering

I would have thought you would be better to do the calcs in the stored proc, thats generally what it is there for. We do almost no work at the report layer unless it involves report elements (layout and sum totally etc). While the report layer has functions etc I don't think you should be doing "a lot of calculations" using them. As for you second question, what features, what engine? Never underestimate the power of human stupidity RAH

I think you can't retrieve client IP's trying to connect to your DB.You could query net_address from sys.sysprocesses which is unique identifier for the network adapter on the workstation of each user ,but how to refer it to user IP I don't know.:confused:

No problem, glad to have helped Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

I just happened to need this today, in MySQL though. There the function exists and is called ifnull. Works great. Thanks. :) Luc Pattyn [Forum Guidelines] [My Articles] The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Try this SELECT cases, ID FROM TAbleB b Join TableA a on a.release = b.release and check your indices Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

Stop spamming and pay for your adverts for what is probably a crap product anyway Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

A bit messy, but select ltrim(right(convert(varchar,getdate(),0),7)) Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

Maybe This[^] article can help. Wout Louwers

brucedkyle wrote: There's new features that help you manage applications and multiple servers. Report Builder 3.0 includes support for geospatial visualization for you to include mapping, routing, custom shapes. [homer simpson voice]Oohhh...shiney objects in my reports...[/homer simpson voice] "My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering

_Damian S_ wrote: National Association of Dyslexics No. It is a pledge that I will Never Disrespect Alcohol. It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

No, that won't work because some fall seasons start in one year but end in a different year so the join won't work. Any other ideas? CodingYoshi Artificial Intelligence is no match for Human Stupidity.

I think Davids answer is excellent, except 20,000 rows in a SQL database is miniscule, we have systems with 20 million rows. The trick is not returning all 20k rows to the user, this is the UI design, only show them the minimum number of rows to meet their needs. Check out tuning and index design, get to know your database. As for using the MS tightly integrated adapters and strongly typed datasets I loathe these constructions, the developer (new) has no real understanding of what is happenning. A large number of post on these forums are cries for help from new devs who cannot customise their data because they are using a wizarded widget they learnt in the tutorials. By all means use the tutorials but remember they are only the FIRST step, you are going to need a deeper knowledge to become proficient. Never underestimate the power of human stupidity RAH

Use of special characters in datatable.select(sql): Encapsulate each of these special chars with "[" and "]". e.g [ will become [[] ] will become []] % will become [%] so "text [abc] test" should look like "text [[]abc[]] test" The simple use of string.replace will not help: .Replace("[","[[]").Replace("]","[]]") will produce: "text [[[]]abc[]] test" (not really what we expected). Esp. for brackets you will have to go through some special "escapes": .Replace("[","<ESCAPE FOR OPEN>").Replace("]","<ESCAPE FOR CLOSE>").Replace("<ESCAPE FOR OPEN>","[[]").Replace("<ESCAPE FOR CLOSE>","[]]") worked fine for me.

From SQL Configuration Manager, Just need to change the tcp/ip port number as anyone new number. Let it be useful to someone like me.