This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 25%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Whenever I am executing SQL query it says "Query executed successfully" but rows count is "0"
I have checked in Query options and "SET PARSEONLY" is not selected.
If I right click on same table and click on "Select Top 1000 rows" then I am able to see Top 1000 rows results but only this query is not returning any rows or results.
Can you please suggest solution on this issue.
Hi,
Why do you convert DATETIME into string for the compare?!?
By doing so you (assuming you have index) you probably lose the option to use index seek and you reduce the performance of the query. If this column is datetime or any type of date/time then you probably better compare it directly
Not sure what is wrong with my WHERE clause because 1 week back it was working fine.
Presumably, one week ago you had data for the date that was the current date then. But if the data set has not been refreshed since then, you don't have any data for today.
Also, that filtering only filters out old rows, but you can still get multiple rows for the same user. Maybe you are looking for the most recent row for each user, no matter the date?
@Erland Sommarskog Thanks Erland...!!! yes, your right...!!! Dataset is not refreshed and hence there are no records in dataset for current date hence query is not returning result.
I will check on dataset refresh issue and revert back on this topic.
What happens if you comment out that WHERE condition? I don't know anything about your data or tables, but the most likely explanation to me is that there are no rows that fulfil the condition in the WHERE clause.
@Erland Sommarskog Thanks for the hint.
I am using WHERE clause to get unique records for current date, after removing WHERE clause I am getting output result from query but its giving multiple records for each UserID. I want to get only unique record for each user for current date.
Not sure what stopped my WHERE clause to work because 1 week back it was working fine.
WHERE CONVERT(VARCHAR(10), [Eventdate], 102) = CONVERT(VARCHAR(10), GETDATE(), 102)
remove the where clause from Source Table CTE and try.
or
can you query select top 100 EDDateTime, * from PowerBI_Data and paste screenshot of result here.
@Laxmikant I am using WHERE clause to get unique records for current date, after removing WHERE clause I am getting output result from query but its giving multiple records for each UserID. I want to get only unique record for each user for current date.
Also I tried select top 100 EDateTime, * from PowerBI_Data and its giving below output result as expected.
Not sure what is wrong with my WHERE clause because 1 week back it was working fine.
