sonchoix (2/12/2015)

---

dwain.c (2/11/2015)

---

In the TOP 2 or 3 or 4 you are listing (outside of the Others group), what do you want to do if there are ties?

This looks to...

I haven't tried it, but you might be able to use Event Handlers to insert into "log" tables.

Let me save you some time. 😉

As you'll see, both...

I don't believe you. You're doing something else as my code should work without problems.

SELECT CASE WHEN [TBL_whole_rock_geochem].au = 0

...

SELECT statements don't fire triggers.

You can use insert and update triggers to avoid empty values but that would only complicate validations.

It's a shame that this functionality got implemented until 2012 using REPLACENULL().

https://msdn.microsoft.com/en-us/library/hh479601(v=sql.110).aspx

The problem is that SQL server is trying to convert from varchar to float/int and you need to do it the other way (float to varchar).

Use this example:

SELECT CASE WHEN...

Those seem like interview questions and people here don't like to answer to them because it helps others to cheat in interviews. A good interviewer will know the difference between...

If you want to replace NULLs or empty strings with the string 'NODATA', one option would be to create views that use ISNULL() for nulls and NULLIF() for empty strings...

below86 (2/10/2015)

---

Well, OK then, I'm not sure why I thought it made a difference.

I know when listing the fields in your joins in the same way the index...

You're welcome.

It would be nice if you could share with us the reasons behind the restrictions.

Why can't you use CTE/temp tables/variables? That's nonsense, next they're going to tell you that you can't use update or select.:hehe:

The solution should be more like this:

SELECT CASE WHEN rn...

And France is divided in regions, departments, arrondisements, cantons, communes and, in some cases, municipal arrondissements.

I'm sure that other countries...

amar_kaur16 (2/9/2015)

---

Thank you for the response.

The only problem is there can or cannot be a record for an applicant in the review table and I want to get all...

Because datediff doesn't care about smaller time parts, it just indicates the number of jumps.

This is a common example:

SELECT StartDate

,EndDate

,Years = ...