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...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
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...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
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.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
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.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
June 25, 2014 at 7:01 am
:unsure:
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
June 17, 2014 at 8:36 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...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
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:
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
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...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/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...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
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.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
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...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
June 16, 2014 at 12:18 pm
thomashohner (6/10/2014)
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
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...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
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...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
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)
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
June 9, 2014 at 2:14 pm
Viewing 15 posts - 181 through 195 (of 312 total)