Viewing 15 posts - 5,236 through 5,250 (of 8,731 total)
Here's another option.
SELECT *
FROM #Machine m
JOIN #MachineBranch mb ON mb.MachineFk = m.MachinePk
WHERE m.MachinePk IN ( SELECT im.MachinePk
...
February 12, 2015 at 10:26 am
sonchoix (2/12/2015)
dwain.c (2/11/2015)
This looks to...
February 12, 2015 at 8:49 am
I haven't tried it, but you might be able to use Event Handlers to insert into "log" tables.
February 11, 2015 at 6:00 pm
below86 (2/11/2015)
Some day, when I get some freee time, Ha Ha, I will run some additional test on our servers.
Let me save you some time. 😉
As you'll see, both...
February 11, 2015 at 2:27 pm
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
...
February 11, 2015 at 1:57 pm
SELECT statements don't fire triggers.
You can use insert and update triggers to avoid empty values but that would only complicate validations.
February 11, 2015 at 1:52 pm
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
February 11, 2015 at 10:59 am
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...
February 11, 2015 at 10:37 am
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...
February 11, 2015 at 9:33 am
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...
February 11, 2015 at 9:22 am
below86 (2/10/2015)
I know when listing the fields in your joins in the same way the index...
February 10, 2015 at 4:05 pm
You're welcome.
It would be nice if you could share with us the reasons behind the restrictions.
February 10, 2015 at 12:06 pm
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...
February 10, 2015 at 11:03 am
dwain.c (2/9/2015)
Many countries don't call them states, they call them provinces.
And France is divided in regions, departments, arrondisements, cantons, communes and, in some cases, municipal arrondissements.
I'm sure that other countries...
February 9, 2015 at 5:36 pm
amar_kaur16 (2/9/2015)
The only problem is there can or cannot be a record for an applicant in the review table and I want to get all...
February 9, 2015 at 5:02 pm
Viewing 15 posts - 5,236 through 5,250 (of 8,731 total)