Viewing 15 posts - 2,401 through 2,415 (of 5,111 total)
Have you tried running that SQL you provided? Can you provide some working DDL, Sample data, and SQL please?
Edit: just noticed that the table is called #SampleData in both...
December 13, 2017 at 7:29 am
What do you mean by "get the results into". What is your expected result set?
December 13, 2017 at 7:12 am
December 13, 2017 at 5:11 am
December 13, 2017 at 5:10 am
First day of previous month:=DateAdd("M", DateDiff("M", "01/01/2000", Today())-1, "01/01/2000")
Last day of previous month:=DateAdd("d", -1,DateAdd("M", DateDiff("M", "01/01/2000", Today()), "01/01/2000"))
December 13, 2017 at 5:00 am
December 13, 2017 at 4:56 am
If the value is NULL, then SSRS will display a NULL.
What is the expression in the textbox?
December 13, 2017 at 4:47 am
You say "This error means nothing". What is "this" error? 🙂
Also, don't forget, we can't run your SQL, we don't have access to you server or data, so...
December 13, 2017 at 4:06 am
They've release a Python based Command Line Tool now. Not sure we really needed another ones of those. I understood the need for MSOS (at least while no equivalent to...
December 13, 2017 at 2:03 am
iimohiuddin - Tuesday, December 12, 2017 12:11 PMwill it automatically shrink or do I have to run a command to shrink it?
You'll...
December 12, 2017 at 12:26 pm
Add an ORDER BY clause. Data inside SQL Server isn't stored in any specific order, it's all a "heap". When you use a TOP 1, without...
December 12, 2017 at 11:21 am
December 12, 2017 at 11:12 am
iimohiuddin - Tuesday, December 12, 2017 10:18 AMThe recovery model is Full
OK, if the recovery model is Full then you need to...
December 12, 2017 at 11:04 am
iimohiuddin - Tuesday, December 12, 2017 9:48 AMThanks
For..? Could you please post what recovery model you're using? We can't help you unless...
December 12, 2017 at 9:53 am
December 12, 2017 at 9:13 am
Viewing 15 posts - 2,401 through 2,415 (of 5,111 total)