Search results for query: *

George once again, thank your help. This solution worked perfectly. I went with a regular CSV as it was fine for my need but Option 6 is very creative...I've bookmarked it for future reference.

Ah yes pwise solution is much better, I was too stuck into answering your question about the case to think about it. Use a left outer join if you need the ppID = 1 value of NULL.

[code] create table #tmp (pdYear int, pdid int, closeddt varchar(100)) insert into #tmp values (2008,1,'2007-4-18') insert into #tmp values(2008,2,'2007-07-18') insert into #tmp values (2008,3,'2007-10-24') insert into #tmp values(2008,4,'2008-1-28') select pdYear, pdID, case when pdID = 2...

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...

firtName? Both were caused by me..........., lol.

@bborissov , hehe I didn't even notice.

Hi George, Thanks for the reply! It does work with a case, but it evaluate the logical statement more than once. I wanted to group them together in one go and only have one condition to evaluate. Looks like that might not be an option...?

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...

Thank you so much, exactly what I was trying to achieve. It improved the speed quite a bit and also helped my understanding of sargeable.

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 johnerman, Thank you very much for the reply, from there I should be able to rework my model a bit I'll definitely go for 3NF first. I'll then de-normalize as needed for performance (I doubt that will be needed considering the small amount of data)

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...