Search results for query: *

Hi all, Sorry I know it's a long post but I wanted to give as much info as possible. CLIFF NOTE: Trying to get a table-valued function to return data based on different filters. This is somewhat of a follow to this thread: http://www.tek-tips.com/viewthread.cfm?qid=1514866&page=1 In my...

Hi everyone, I'm trying to write a Table-valued function that returns a different set of data for a person depending on a boolean parameter. I'm trying to achieve something like this...with an if statement to inverse the order of my coalesce depending on if I want primarly unicode values or...

Hi everyone, I'm fairly well versed with OOP concepts and am now trying as much as possible to apply it when I design web-apps. Problem I am facing though is scalability and performance. I don't know which way to go... Should I be making very simple, almost trivial object to perform basic...

Hi everyone, I recently read up on making query sargeable to improve performance. Up until now I really never considered this. I have the following query, nothing complex but it will be run against many rows. SELECT iRecordNumber, iRecordTypeID, COUNT(iRecordID) AS nbRecord FROM tblRecord...

Hi everyone, I'm currently building a "small" web-application ... it's small compared to what's out there, but would be my first project of this scale. I'm familiar with ER Diagrams and most of the lingo however I'm not sure if I have the right model at the moment. I have the following...