Viewing 15 posts - 3,481 through 3,495 (of 11,676 total)
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 21, 2014 at 1:24 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 21, 2014 at 1:21 am
Thanks for the question.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 21, 2014 at 1:15 am
We should have more questions like this.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 21, 2014 at 1:11 am
Thanks for the question.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 21, 2014 at 1:05 am
Richard Warr (3/14/2014)
Stewart "Arturius" Campbell (3/14/2014)
Interesting question, thanks Steve.Misread the question, thought it meant the highest level that a single command can be used...
ah well...
Same here :doze:
+1
Didn't get the intent...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 14, 2014 at 6:33 am
Nice question, had me to do some research.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 13, 2014 at 8:01 am
Andy sql (3/13/2014)
I also had some fun, trying to install 64-bit ACE OLEDB (Access database engine) drivers on top of the 32-bit Office - which is not allowed 🙁
It...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 13, 2014 at 7:58 am
mario17 (3/11/2014)
IT works now,
I made a lot of changes.
1. FW alllow for specific range
2. TCP port 80 FW allow
3. Added user to Report Manager
4. Added user to my...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2014 at 3:09 am
Great question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2014 at 3:03 am
mario17 (3/11/2014)
that our setup, we all do local work, don't have any common SSRS server,
Biz users just want to get access to our SSRS server to validate reports.
We're on...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2014 at 4:11 pm
You can design aggregations with XMLA, but I believe the designer will be more straight forward.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2014 at 4:08 pm
Are you on a domain?
Did you turn off the firewall?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2014 at 4:05 pm
ISNULL(accepttime, '')
Here you implicitly convert the empty string to a datetime field (at least that's what I assume accepttime is. It's just guessing without the table DDL.)
According to MSDN...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2014 at 4:02 pm
One possible solution using windowing functions:
SELECT item_number,sku,Field_Name,Old_Value,New_Value,Change_Date
FROM
(
SELECT item_number,sku,Field_Name,Old_Value,New_Value,Change_Date
,RID = ROW_NUMBER() OVER (PARTITION BY sku ORDER BY Change_Date DESC)
FROM [dbo].[item_status]
) tmp
WHERE...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2014 at 3:57 pm
Viewing 15 posts - 3,481 through 3,495 (of 11,676 total)