Viewing 15 posts - 3,481 through 3,495 (of 11,678 total)
We should have more questions like this.
March 21, 2014 at 1:11 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...
March 14, 2014 at 6:33 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...
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...
March 12, 2014 at 3:09 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...
March 11, 2014 at 4:11 pm
You can design aggregations with XMLA, but I believe the designer will be more straight forward.
March 11, 2014 at 4:08 pm
Are you on a domain?
Did you turn off the firewall?
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...
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...
March 11, 2014 at 3:57 pm
Viewing 15 posts - 3,481 through 3,495 (of 11,678 total)