This is what worked for me, but any rooms for improvement or suggestions is gratefully appreciated:

SELECT account, name, street, due_date

FROM my_table

WHERE

CAST(CONVERT(VARCHAR,due_date,102) AS DATETIME) = (

case when CONVERT(VARCHAR,due_date,102) = CONVERT(VARCHAR,GETDATE() ,102)

then...

Maybe using case isn't the right approach for this.

Hi there,

There are a few that will have ccc_ and a name after instead of just numbers like the others.

Thanks!

Hi, they are not, I  have one table called master, the others are named like acc_ and some numbers and letters after that. All I am trying to do is...

Hi the idea is good, but running into some issues with your query;

WTIH t_data AS

(SELECT DISTINCT id as id, account_number as acc

FROM t_02

UNION

SELECT DISTINCT id as id2, account_number as acc2

FROM...

Hi there!

I know my question was some how abstract but trying to simplifying it:

a) What do you expect as the result of this query?

I have one table, lets called it...

No, this is what it should...

This is what I get:

  
account_id
event_time
sign
1
2251
28.03.2017 19:00:04
YES
2
2251
28.03.2017 19:00:04
YES
3
2251
28.03.2017 19:00:04
YES
4
2250
28.03.2017 15:45:11
NO 
5
2250
28.03.2017 15:45:11
NO 
6
2250
28.03.2017 15:45:11
NO 
7
2250
28.03.2017 01:01:45
NO 
8
2250
28.03.2017 01:01:45
NO 
9
2250
28.03.2017 01:01:45
NO 

To answer my own question, this worked:

SELECT name,

address,

email,

CASE

...

It gives:

"Error: [SQL0171] Argument 1 of function CASE not valid."

Hi,

Thanks for your replay, but it still returns empty values for all results even when I have data in the "date" ( the column name "date" I...