Sql query to retreive data from database on daily basis if present data data not present return null

Question

1.00/5 (1 vote)

See more:

i want an sql query that retrurn data from tables if today data is present if not then return no data

What I have tried:

select table1.coulumn1, table1.coulmn2 from patientTable group by date

Posted 12-Nov-20 19:16pm

Member 14649324

Updated 12-Nov-20 22:37pm

Add a Solution

2 solutions

Solution 1

That's complicated: You can retrieve data based on date:

SQL

SELECT Column1, Column2, DateColumn
FROM MyTable
WHERE DateColumn = CAST(GETDATE() AS DATE)

But you can't GROUP it without a lot of complication: SQL GROUP By and the "Column 'name' is invalid in the select list because..." error[^]

[edit]
GETDATE added - somehow it got lost from the original...
[/edit]

Posted 12-Nov-20 19:57pm

OriginalGriff

Updated 12-Nov-20 21:36pm

v2

Comments

Member 14649324 13-Nov-20 2:55am

@Griff But this query is also not working syntax error is it complete

OriginalGriff 13-Nov-20 3:36am

Fixed: the GETDATE part got lost from my original, not sure how ...
Sorry about that.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2020-11-12T22:37:00

Your question is far from clear. Perhaps you're looking for the EXISTS clause?
EXISTS (Transact-SQL) - SQL Server | Microsoft Docs[^]

SQL

SELECT
    SomeColumns
FROM
    YourTable
WHERE
    Exists
    (
        SELECT 1
        FROM YourTable
        WHERE YourDateColumn = CONVERT (date, SYSDATETIME())
    )
;

Or, if the column contains the date and time:

SQL

...
WHERE YourDateTimeColumn >= CONVERT (date, SYSDATETIME())
And YourDateTimeColumn < DateAdd(day, 1, CONVERT (date, SYSDATETIME()))
...