Posted
by Louise
on Stack Overflow
See other posts from Stack Overflow
or by Louise
Published on 2010-04-15T17:58:04Z
Indexed on
2010/04/15
18:03 UTC
Read the original article
Hit count: 421
Is there anyway I can build a Select statement that uses the Contains function? Like this:
Select commentStr
Case commentStr.Contains("10")
Case commentStr.Contains("15")
© Stack Overflow or respective owner
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi I am trying to use a HTML select box with 'multiple' select options and size to 1 as below
`
<SELECT NAME="toppings" MULTIPLE SIZE=5>
<OPTION VALUE="mushrooms">mushrooms
<OPTION VALUE="greenpeppers">green peppers
</SELECT>
When the size is set to 1 small scrollbar appears…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I noticed something strange while executing a select from 2 tables:
SELECT * FROM table_1 WHERE id IN (
SELECT id_element FROM table_2 WHERE column_2=3103);
This query took approximatively 242 seconds.
But when I executed the subquery
SELECT id_element FROM table_2 WHERE column_2=3103
it…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
Few days ago I wrote article about SQL SERVER – Stored Procedure Optimization Tips – Best Practices. I received lots of comments on particular blog article. In fact, almost all the comments are very interesting. If you have not read all the comments, I strongly suggest to read them. Click here to…
>>> More
as seen on Programmers
- Search for 'Programmers'
var numbers = new int[] { 1, 2, 3, 4, 5 };
var contacts = from c in context.Contacts
where c.ContactID == numbers.Max() | c.ContactID == numbers.FirstOrDefault()
select c;
foreach (var item in contacts) Console.WriteLine(item.ContactID);
Linq-to-Entities…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
As the title suggests, I get an error running Play 2.0.1 Tests using a FakeApplication w/ H2 in memory.
I set up a basic unit test:
public class ModelTest {
@Test
public void checkThatIndustriesExist() {
running(fakeApplication(inMemoryDatabase()), new Runnable() {
public…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
i wrote the following section below.
when debugging, i see that i enter the first Case okay.
my problem is with the second Case - it does not enter it and goes to the error messege.
what do i do wrong?
Select Case Data_Rate
Case "1", "2", "5.5", "11", "6", "9", "12", "18", "24", "36", "48", "54"
…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
In my excel file, I have a table setup with formulas.
with Cells from Range("B2:B12"), Range ("D2:D12"), and etc every other row containing the answers to these formulas.
for these cells (with the formula answers), I need to apply conditional formatting, but I have 7 conditions, so I've been using…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I just started using C# and I've got a couple of issues.
Is there any way to code the C# equivalent of the VB.NET Select statement like the following?
Select Object.Name.ToString()
Case "Name1"
'Do something
Case "Name2"
'Do something else
Case Else
'Do the default…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I just started using C# and I've got a couple of issues.
I hook several controls to one event handler as in the following and I want to perform a slightly different action for each control:
Private Sub Button_Click(sender as Object, e as EventArgs) _
Handles button1.Click, Button2.Click
'do…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I want to do a select that do a cast only for a specific ID but it doesn't seems to work.
Example :
SELECT
CASE
WHEN(@ID <> 1) THEN Code
WHEN(@ID = 1) THEN Cast(Code AS int)
END Code FROM ....
Any Idea ?
>>> More
