Viewing 15 posts - 181 through 195 (of 312 total)
T501 (frightening naming convention by the way).
I have no idea why we can't follow a proper guideline on how to name the table, but I usually keep my mouth shut:(
If...
June 30, 2014 at 1:46 pm
I Just became a SQL Server DBA about 8 months ago but don't have any other DBA in the company who I can talk to :ermm: Until last week, we...
June 30, 2014 at 11:20 am
I ended up adding a non-clustered index and it went from 11000 logical reads to 3 logical reads.
June 27, 2014 at 11:07 am
Resolved. 😀
Had some issues with the network. Network admin had to tweak something, but it is working fine and I am able to connect.
June 25, 2014 at 7:01 am
New Born DBA (6/17/2014)
This is a strange behavior. I don't know what I am missing? It is showing month+year for all the months except January: unsure:See attachment:
I see what the...
June 17, 2014 at 8:36 am
This is a strange behavior. I don't know what I am missing? It is showing month+year for all the months except January: unsure:
See attachment:
June 17, 2014 at 7:52 am
thomashohner (6/17/2014)
Try this in your SQL query then feed it into your report.
DATENAME(MONTH, Requested_Start_Date)+ ' ' + DATENAME(Year ,Requested_Start_Date) AS MonthYear
Can't try that in my query since I...
June 17, 2014 at 7:36 am
thomashohner (6/17/2014)
Try this in your SQL query then feed it into your report.
DATENAME(MONTH, Requested_Start_Date)+ ' ' + DATENAME(Year ,Requested_Start_Date) AS MonthYear
I don't know if I am supposed to...
June 17, 2014 at 7:25 am
pietlinden (6/16/2014)
Like this...=MonthName(Month(Fields!DueDate.Value)) & " " & Year(Fields!DueDate.Value)
just change DueDate to your field name.
Thank you so much. It worked.
June 17, 2014 at 7:03 am
Not being familiar with SSRS
Me Neither
it looks like you just need to concatenate a space and the YEAR value of Requested_Start_Date.
How would I do that. I mean what would...
June 16, 2014 at 12:18 pm
thomashohner (6/10/2014)
June 10, 2014 at 7:49 am
Luis Cazares (6/9/2014)
It's normal that you get an error if you're using distinct and ordering by a column that's not returned in the select.
You...
June 10, 2014 at 7:06 am
Luis Cazares (6/9/2014)
How do you get the parameter list? Is it a query where you could you simply add a DISTINCT?
When I run a query without DISTINCT, it works fine...
June 9, 2014 at 2:24 pm
Luis Cazares (6/9/2014)
How do you get the parameter list? Is it a query where you could you simply add a DISTINCT?
This is what I did. (see attachment)
June 9, 2014 at 2:14 pm
Viewing 15 posts - 181 through 195 (of 312 total)