Can you give me an example of what you mean?

FWIW, although I only specifically checked whether emplid is null, it effectively is checking all the values that I joined on....

What your statement is doing here is saying if <single scalar value> not in (<List of stuff)...

The problem is (select emplid+applicationid+ProgramID from table1) can (and does) return more than one...

There are probably lots of schools of thought on this. IMHO, I try to avoid nesting procedure calls, primarily because it can be difficult to troubleshoot. I have fond memories...

The same principle applies for numeric columns. Again, just setting up some fake numeric data, you can do this:

--This is just setting up some fake source data

;with t (AAA, BBB,...

Depends on how exactly you want to combine the data, but would something like this work?

;with t

(

AAA,

BBB,

CCC

)

as

(

...

If you're concenred about the exact size of the index, it would behoove you to read through that article more thoroughly. That or you could build the index in a...

Three options come to mind (in my personal order of preference):

1) A delimited string of to and from values. This requires that you have a string split function built on...

While this doesn't necessarily mean it isn't true, I have not heard of case statements causing a degradation in performance. If anything, I would think a case statement would probably...

The first query is just a reiteration of what djj just posted. The idea is that you use the row_number window function to partition, or group, the data by name,...

It would just go in your list of select columns. So from your query, you'd do

SELECT c.cust_fullname AS Name,

...

Welcome to the forums romy. I would first suggest you look over this post on how to best ask questions on the forums. You'll find many people willing and able...

Use LinksUp code, just add the from clause that you supplied in your OP

select EffectiveDate, DATEADD(dd, -90, DATEADD(yy, -1, EffectiveDate))

from FL.CEFHistory

I'm still a little unsure on what it is you're trying to get at, but you may want to look research Quirky Updates.

A word of caution: please note that...

Here's what I'd do. Cast whatever your original float input is as a very large decimal (say (38,10)) then cast that to a string. It will retain all the points...

Thanks, Dwain. I'll look this solution over as well and see how it fits the data set I'm working with.

Fwiw (and this doesn't quite work in pure SQL), I did...