space between 2 rows
Currently I am working on tabular report. I want to provide space between every 2 rows. as below:
| 1 | 3070 | 01/02/2012 | ARS | 10-R213 | Cost Item Debit | 1202020 | 8271.52 | 8271.52 | 307003010V | AR0001 | Depreciation | 2201 | |||||||
| 1 | 3070 | 01/02/2012 | ARS | 10-R213 | Cost Item Credit | 5030000 | 8271.52 | 8271.52 | 307003010V | AR0001 | Depreciation | 2201 | |||||||
| 2 | 3070 | 01/02/2012 | ARS | 10-R213 | Cost Item Debit | 1202020 | 63938.99 | 63938.99 | 307003010V | AR0001 | Fixed | 2201 | |||||||
| 2 | 3070 | 01/02/2012 | ARS | 10-R213 | Cost Item Credit | 5030000 | 63938.99 | 63938.99 | 307003010V | AR0001 | Fixed | 2201 | |||||||
how can I do this??
kmp
Reply:
Hi One Possible solution could be you can write sql script which will bring null rows after every two rows... it may be possible using row number functionality or like that....
I will try it out and come with possible solution..
Hope this helps!!!
thanks
------------------------------------
TLS / SSL Patch for Windows 2008 Server
Need a patch as recomended by Venability Assesment for below
1. The remote service encrypts traffic using TLS / SSL and permits
clients to renegotiate connections. The computational requirements
for renegotiating a connection are asymmetrical between the client and
the server, with the server performing several times more work. Since
the remote host does not appear to limit the number of renegotiations
for a single TLS / SSL connection, this permits a client to open
several simultaneous connections and repeatedly renegotiate them,
possibly leading to a denial of service condition.
2. The remote service encrypts traffic using TLS / SSL but allows a
client to insecurely renegotiate the connection after the initial
handshake. An unauthenticated, remote attacker may be able to leverage
this issue to inject an arbitrary amount of plaintext into the
beginning of the application protocol stream, which could facilitate
man-in-the-middle attacks if the service assumes that the sessions
before and after renegotiation are from the same 'client' and merges
them at the application layer.
Please help !
- Changed type Bruce-Liu Tuesday, November 29, 2011 3:51 PM
Reply:
------------------------------------
Reply:
------------------------------------
FAST Search for SharePoint indexing XML Content
Hi All,
I'm sure there has to be a way to do this with FS4SP but can't seem to find it yet :).
I have an XML document with multiple nodes a.k.a multple documents. Using the File traverser it was easy enough to index and FAST was able to make documents with a single XML file. Example below should be two seperate documents in the index. Can't seem to find a way to do this with FS4SP, meaning the below will combine the two documents into one indexed document.
The command I run is: docpush -c sp C:\Content\Small.xml
<Documents>
<Document>
<Title>Document 1</Title>
<Date>2011-01-01T08:00:00Z</Date>
<Size>128</Size>
<Body>This is the first test document. alpha bravo charlie delta echo foxtrot golf hotel.</Body>
<Text4>alpha bravo charlie delta</Text4>
</Document>
<Document>
<Title>Document 2</Title>
<Date>2011-01-01T08:00:00Z</Date>
<Size>128</Size>
<Body>This is the second test document. alpha bravo charlie delta echo foxtrot golf hotel.</Body>
<Text4>alpha bravo charlie delta</Text4>
</Document>
</Documents>
Any thoughts to this?
Reply:
Take a look at this one:
I have not used it myself yet, but it does say:
>>Indexes XML files that contain multiple XML elements that should be indexed as separate items or documents. >>Note: This is unlike the method described in Custom XML Item Processing, in which each XML element must be >>stored in an XML file.
Igor Veytskin
------------------------------------
Reply:
Thanks Igor,
I'll look into this one. I tried it and get a "No Custom Connectors Registered". The steps are pretty simple though.
Smitty.
------------------------------------
64-bit Edition of Data Mining Add-ins for Excel available from Download Center
An updated version of the Data Mining Add-ins for Excel has been released as a part of the SQL Server 2012 Feature Pack.
Feature Pack page
http://www.microsoft.com/download/en/details.aspx?id=29065
Add-ins download page
http://www.microsoft.com/download/en/details.aspx?id=29061
This update provides support for 64-bit editions of Office.
This release of the add-ins does not require installation of SQL Server 2012. In other words, you can use these add-ins if you want to use the 64-bit edition of Office but connect to 2008 R2 instances of Analysis Services.
If you have an existing older version of the add-ins, the installer will offer to upgrade.
SQL Server UE, Data Mining
- Changed type Jeannine TakakiEditor Monday, March 12, 2012 6:35 PM wrong type
- Changed type Jeannine TakakiEditor Monday, March 12, 2012 6:35 PM wrong type
Reply:
Hi Jeannine,
Thanks for sharing the update with us here. Your post seemed to only sharing information without any question. If so, please change the thread type to General Discussion.
Thanks,
Jerry
------------------------------------
Reply:
Thanks Jerry!
And thanks to all those who contacted me privately to let me know about the typos in the download page.
I've let the release manager know about the errors so hope to see it fixed soon.
SQL Server UE, Data Mining
------------------------------------
Server Error,The status code returned from the server was: 500
Error Message: 'Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500'
This error is thrown if the page execution(i.e, a process in database and page is waiting till the result) takes more than 2 mins. If it takes less than 2 mins its working fine.
Application working fine with local server. But problem arises with live server. Is the Problem due to any kind of 'Time Out' settings.
Please tell me possible cause of problem, or way to find the cause of the problem.
- Moved by Karel ZikmundMicrosoft employee Tuesday, March 13, 2012 4:40 AM Please use http://forums.asp.net (From:Building Development and Diagnostic Tools for .Net)
Reply:
Hi Firos,
your question is Regarding asp.net Forum. So Please post your question in Asp.net forum for best answer
Regards
Kayden
------------------------------------
Amazing Boot Times
My last 2 bot times were 37964ms then, after disabling WLM & Skype from running @ start-up, 36380ms!!
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
Reply:
*LOL* 38s fast? *LOL* my Vista boots in 18s completely (15.7s to desktop and 18.9s to boot completely and this is no SSD, it's a traditional HDD).
<timing bootDoneViaExplorer="15761" bootDoneViaPostBoot="28961" osLoaderDuration="1096" postBootRequiredIdleTime="10000" postBootDisturbance="3200"
Your brown nosing sucks. We know that you love everything MS does.
"A programmer is just a tool which converts caffeine into code"
------------------------------------
Reply:
Simply was a comment or observation to jibe w/ material written & or testing data suggesting to expect faster boot times in Win8 and that mine were strikingly much better than, my Win7 values.
& certainly, those Vista boot times you're getting are very good.
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
------------------------------------
Reply:
Andy may or may have brown nose.
But MS has moved into Clouds and lot are paranoid. I don't care about boot times. We dont boot/reboot unless required and yes troubleshooting is pain in ***** with every OS. First impression of Windows 8 looks good, still playing with it.
------------------------------------
Reply:
Boot times are indeed impressive.
I think also we are moving away from the idea these days of cold booting a PC at 9am, then fully shutting it down at 5pm when we leave the office.
For starters, I use a netbook, and rarely shut down at all.
People are expecting phone device-like instant on behaviour nowadays from their computing devices, so I hope we are starting to see that with Win8 too.
------------------------------------
Reply:
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
------------------------------------
Reply:
Start up (not restart) - 39.5 secs.
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
------------------------------------
How to retrieve managed metadata using Client Object Model of Sharepoint 2010?
I would like to know about the client object model and most precisely the retrieval mechanism...How to retrieve the managed metadata fields of listitem/documents using Client object model of SharePoint 2010?Could you please provide me any code snippets regarding this retrieval?
Any help would be appreciated..Thanks in advance!
Regards;
Reply:
Here is an MSDN blog article which can help lead you in the right direction for accessing the Managed Metadata using the Client Object Model
Chris
Chris
------------------------------------
Some Remaining Challenges for Microsoft Word in the Publishing Industry
I'm not writing to obtain help as much as I'm writing to offer what I hope will be received as helpful information. As a technical communicator, I've used Microsoft Word for over 16 years to write large and small documents. I've used mail merge, If-Then-Else fields, IncludeText fields, document properties and Building Block Organizers to create a single-sourcing strategy that matches anything that Adobe FrameMaker can do with conditional text. I've also used Microsoft Word with SharePoint to create an effective enterprise content management approach that is based on solid industry practices.
Nevertheless, I continue to come across people who refuse to use Microsoft Word, because they perceive it as an inferior tool. Here is a list of the top five complaints I hear:
- It's not made for large documents (may be true, but I've created documents with several hundred pages in Word)
- The autonumbering issue still hasn't been resolved (a legitimate complaint)
- Conversions to HTML and XML contain proprietary, Microsoft code (also a legitimate complaint, though misunderstood)
- It doesn't support Darwin Information Typing Architecture (also true)
- Microsoft Word is volatile (still true, but less so today)
I will continue to use Microsoft Word, because most of the business world uses it, and clients come first. On the other hand, I'd like to see these issues addressed in Office 15. As far as the publishing industry is concerned, these changes are long overdue. I can respect the desire to the Word interface extremely intuitive for the majority of the user base. I applaud that initiative, but Microsoft must attend to its power users as well. This is where I'd like to offer some suggestions.
The first one is for Microsoft Word to support a comprehensive approach to enterprise content management, which includes structured authoring in HTML, HTML5, XML and DITA. Investigate tools such as AuthorIt, Adobe Technical Communication Suite, Madcap Flare. Now that we are well into the 21st Century, Microsoft Word should become a one-stop publishing shop for a variety of paper-based, pdf, web and mobile content. It will have to do that if Microsoft wants it to remain competitive. To this end, it may be useful to consider grafting some of the functionality in SharePoint Designer into Microsoft Word. It would also be nice to have a choice between generating Microsoft HTML and XML and open-source code for each medium.
Microsoft Word should also improve the stability of autonumbered headings and numbered lists. Captions for figures and tables work without a hitch, but headings and numbered lists are another story. Writers should not have to deal with the nagging issue going back and correcting autonumbered lists that restart or continue from previous lists in a file. They shouldn't have to abandon autonumbering and return to manual numbering. Autonumbered headings and lists still don't work, and they need repair.
Other volatility issues should also be cleaned up, but I think the last few versions have been significantly less prone to blowing up and corrupting files. Moreover, the cryptic codes that appear in the accompanying error messages do not help users to understand whether they're asking for too much from their computers or something is wrong with their installation of Word.
What I envision for Microsoft Word is a platform that will publish directly to the web with mobile content, podcasts, video casts and other multimedia presentations. One possible strategy is to improve the integration between Microsoft Word and PowerPoint. As of now, PowerPoint lacks Track Changes and rich-text editing capabilities for the notes. For team efforts, this lack of functionality creates problems. Instead of being able to review automarked changes to a PowerPoint, you are at the mercy of notes left by the last person who changed the presentation. Has Microsoft thought of merging PowerPoint with Microsoft Word? It may be time.
It is my sincere hope that Office 15 will include these and other changes. I have others, but the ones I've listed are enough for now. I'd like to be able to tell those Adobe people that FrameMaker is no better than Microsoft Word, but it sure costs a lot more.
- Changed type David Wolters Tuesday, March 13, 2012 3:30 PM OP is not looking for help
- Edited by BillGraham61 Thursday, December 14, 2017 8:34 PM
How to have Outlook 2003 automatically resize images to 1024 x 768 px
Hello. I have advised staff numerous times regarding sending large jpeg/png attachments to use the "attachments options" toolbar to resize to "Large" unless the file is for rinting but I am still having staff forget to use the toolbar and they are saturating the internet connection.
When the attachment options toolbar pops up, the default is "Don't resize, send originals".
Is there any way to have that combo box default to "Large", that way, all images will be resized automatically and they would have to manually change the box to "Don't resize, send originals" only when they needed to (which is about 1% of the time).
Thank you!
Reply:
This is more of an Outlook request, I'd post on the Outlook forum, -
http://social.technet.microsoft.com/Forums/en-US/outlook/threads
I'd also look into GPO/ADM template for Office/Outlook. The above forum would not more about this.
Sukh
------------------------------------
Reply:
I have asked the question in the clients section, apologies.
Thank you, please close this thread. I would mark as answer but for some reason I cannot see where to do so.
------------------------------------
Exch 2010 Spam filter rejecting MANY messages this morning (Friday 3/9)
Reply:
Nothing reported by customer I manage.
Check to see if they are genuine or not?
Sukh
------------------------------------
Reply:
Question regarding your setup -- is forefront your only level of email level spam filtering or are you using an additional level of protection for emails to be filtered before reaching your domain?
Jamal M. Saleh
Lynn, MA
- Edited by JS-1980 Monday, March 12, 2012 4:00 PM
------------------------------------
Time tracking in project server
- Changed type Joe Ferrara, PMP Friday, March 9, 2012 2:53 PM reach more people
- Edited by Joe Ferrara, PMP Friday, March 9, 2012 5:43 PM
Reply:
Hi Joe,
Most of the time when I hear this type of complaints, the source of the problem is that the planned work for the resources is not well planned for the current time period. I think the PM should "prepare" (plan or re-plan) the resources' work! If remaining work is remains in the past, or if planned work is not leveled (manually or automatically) for the visible time period, the resources will get buried under tasks. As such, the timesheet interface in PWA is not user friendly enough. So the clue is to "prepare" the planned work for the current time period in a realistic way!
However, dependent on the kind of resources which have to report time, the timesheet interface of PWA is not simple and robust enough. In this cases, I think it would be better to enter the actuals via another person (other Default assignment Owner). If this is not possible, I would consider developing a custom interface...
Regards
Wim
------------------------------------
Failover Cluster
Hi Everyone
Recently an interviewer asked a question when (in which situation) we can do the manual fail-over.
I gave few answer but he was not satisfied.Can any give me the answer of the same.
Regards
Vijay
- Changed type Vincent Hu Tuesday, March 13, 2012 7:17 AM
Reply:
Without the context of the question, it is hard to formulate an answer. Was the interviewer asking about technical barriers to moving groups or was he wanting to learn what you know about Enterprise operations management? The answers are different for the same question depending on what context the question happened in.
Geoff N. Hiten Principal Consultant Microsoft SQL Server MVP
------------------------------------
When XP Pro (sp3) system is joined to domain, System Restore TAB is missing
By default, the System Restore feature in created when XP Pro is installed, right?
Even after the system is completely patched beyond sp3, the System Restore TAB is present under any local admin account created.
This is verified by RIGHT click on My Computer, left click on Properties, see and click on System Restore TAB.
After the system is joined to the 2008 domain and restarted, and one logs into a local admin account OR the domain account (with Administrators Group privileges), the System Restore TAB is not present.
The 2008 Group policy (for System Restore) has not been edited. It has been left at the default setting which is 'not configured'
I have tested this with freshly formatted system and the results are the same.
Joining the system to the domain seems to affect whether the SR will be present. When I place the system back into a WORKGROUP (ie. "un-join" it from the domain), the SR is now present.
I have tried everything listed on the google search page results of "System Restore Tab Missing in XP-Pro!"
Any fresh ideas as to why this is happening (with proof, not speculation) ??
THX.
-WG
Reply:
If it only occurs when you join to the domain, then it has to be some policy that is taking effect. Have you tried combing through a gpresult log using the verbose settings?
- Edited by Chris-Jones Tuesday, March 6, 2012 2:50 AM
------------------------------------
Reply:
Yes, it was a group policy, but not one that you would expect.
Gpresults did not help.
Without the SR and trying to access it, I received the error message "You do not have sufficient security privileges to restore your system". (Others reported this error message as well.)
When I attempted to check the properties of the security event logs, I would frequently, but not always, receive an access denied or security log corrupt message.
I was looking for something unusual in the policies now.
Under the User Rights Assignment policy, I found a security setting that listed several top IT staff members instead of the default setting.
The policy with the explanation was:
"Manage auditing and security log
This security setting determines which users can specify object access auditing options for individual resources, such as files, Active Directory objects, and registry keys.
This security setting does not allow a user to enable file and object access auditing in general. For such auditing to be enabled, the Audit object access setting in Computer Configuration\Windows Settings\Security Settings\Local Policies\Audit Policies must be configured.
You can view audited events in the security log of the Event Viewer. A user with this privilege can also view and clear the security log.
Default: Administrators."
We changed it to the Default: Administrators and the System Restore returned after a few reboots or running gpupdate at the command line.
Who would have thought that this policy would effect the System Restore in any way?
I didn't nor did anybody else make the exact connection.
-WG
------------------------------------
Exchange 2010 Hub/Cas memory
IS there any recommendations on how much memory to run in a hub/cas (split role on one server). The operating system is 2008 r2 standard so is limited to 32Gb on that side but will Exchange cope ok with that amount of RAM or is it a case of too much RAM isn't always the best?
Thanks
Reply:
Take a look at:
Understanding Client Access and Hub Transport Combined Role Configurations in Capacity Planning
8-16GB depending on your load should be enough in most cases.
------------------------------------
Reply:
Sukh
------------------------------------
Troubleshooting: Not able to create enabled Active Directory accounts
Troubleshooting: Not able to create enabled Active Directory accounts: http://social.technet.microsoft.com/wiki/contents/articles/8111.troubleshooting-not-able-to-create-enabled-active-directory-accounts.aspx
Timothy P Macaulay, MCSD, MCSD.NET, MCAD, MCP
How can Tape management be improved?
If you got suggestions for tape management improvements please share them. I will submit your ideas to the DPM product group regarding how DPM can be more developed regarding tape management.
No suggestions are a bad suggestion! Share them please.
Please email me your suggestions to robert.hedblom@gmail.com
Thank you in advanced
Best Regards
Robert Hedblom
MVP DPM
Check out my DPM blog @ http://robertanddpm.blogspot.com
Reply:
Hello,
first of all many thanks for the possibility to add some suggestions.
My problem(s) start with the complete missiong of any GUI for the Tape Management. I mean where can i see (exept in the SQL MgmT Studio in a Tbl View) how many tapes DPM is using or wich tapes have ever been used from DPM by name and or expire Date.
So what is missing is a GUI for the Tape Management : What Tapes does DPM know and the expire Date of the Tapes
Then a complete import and or export of the Tape Libary would be neccessary in order to migrate the DPM Server to another . For example if one of my DPM Server crashed (the database is not usable any more after several inicdents) i want to export the tape information in order to be still able to do a restore from tape the next years. This information is totally gone . . .
That's the first 2 things that came up directly if you ask me for any improvement . .
Cheers and all the Best
Jan
------------------------------------
What works, what doesn't
The following virtualization products have been tested and verified to install and function in basic scenarios with the Windows 8 Consumer Preview. Note that in some cases, special options need to be selected while loading Windows 8 Consumer Preview in the virtualization product.
Functional:
• Hyper-V in Windows 8 Developer Preview
• Hyper-V in Windows Server 2008 R2
• VMware Workstation 8.0.2 for Windows
· Note Do not use the "Easy Install" option when setting up the Windows 8 virtual environment using VMWare Workstation. Use the new virtual machine wizard, and select the option for "Windows 7".
• VirtualBox 4.1.8 for Windows
· Note Use the VirtualBox config manager to "enable PAE/NX" when setting up the Windows 8 virtual environment.
• Parallels Workstation 6 for Windows
• Parallels Desktop 4 for Windows
• XenDesktop 5.5
Non-functional:
• Microsoft Virtual PC (all versions)
• Microsoft Virtual Server (all versions)
• Windows 7 XP Mode
• VMWare Workstation 7.x or older
- Edited by rseiler Wednesday, February 29, 2012 5:37 PM
- Changed type Miya YaoModerator Wednesday, February 29, 2012 5:41 PM
Reply:
Functional:good point. Thanks :)• VMware Workstation 8.0.2 for Windows
· Note Do not use the "Easy Install" option when setting up the Windows 8 virtual environment using VMWare Workstation. Use the new virtual machine wizard, and select the option for "Windows 7".
"A programmer is just a tool which converts caffeine into code"
------------------------------------
Reply:
- Edited by sarcolan Thursday, March 1, 2012 1:23 AM
------------------------------------
Reply:
------------------------------------
Reply:
VMware Workstation 8.0.2 for Windows:
Finally got it working using the following settings:
Guest operating system: Other
Version: Other 64-bit (obviously I'm installing Windows 8 CP x64)
------------------------------------
Reply:
Can't get x64 to work, but did get x32 with these settings. NIC drivers not working though...obviously VMware Workstation 8.0.2 for Windows does not support W8.VMware Workstation 8.0.2 for Windows:
Finally got it working using the following settings:
Guest operating system: Other
Version: Other 64-bit (obviously I'm installing Windows 8 CP x64)
------------------------------------
Reply:
Not having much success with VirtualBox and x32;
Robin
------------------------------------
Reply:
------------------------------------
Reply:
Thanks rs, I'll follow up on that link. In the meantime, I used another desktop and got the win8 desktop and server VM's up and running. Although I was requested to provide a product key for the desktop, WTF?
Robin
Got desktop going with key from "x-64 product key thread". Still following up up ZD thread for intial install problem on other computer.
- Edited by robinz Friday, March 2, 2012 5:54 PM update:
------------------------------------
Reply:
I updated VMWare Workstation to version 8.0.2, and I made sure to select Windows 7 when going through the install process, but I received the following error message regarding the product key. What should I check and/or do in order to get this to work?
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
"I updated VMWare Workstation to version 8.0.2, and I made sure to select Windows 7 when going through the install process, but I received the following error message regarding the product key. What should I check and/or do in order to get this to work?"
I had the same problem and found a resolution from another forum:
Remove the floppy drive device (Which on my VM was installed by default).
After I did that the VM started up with no problems at all..
- Edited by Arjen_MarkMicrosoft employee Monday, March 12, 2012 2:52 PM
------------------------------------
how to loop through multiple sheets in Excel work book Using SSIS
Reply:
Following is the appropriate forum for your question:
SQL Server Integration Services
Article: Looping Through Excel Files And Sheets in SSIS
Kalman Toth SQL SERVER & BI TRAINING
------------------------------------
Reply:
Hi,
Check these
http://www.sqlservercentral.com/Forums/Topic637794-148-1.aspx
I hope this is helpful.
Elmozamil Elamir
Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
http://elmozamil.blogspot.com
------------------------------------
microsot outlook contact
i am create a new mail and type the address but not show the address in alphabet
Reply:
What's your question?
You can upload a screenshot if you feel hard to explain.
Max Meng
TechNet Community Support
- Edited by Max Meng Monday, March 12, 2012 2:13 PM
------------------------------------
Report server issue
We have a Windows 2008 R2 SQL server running as a virtual server and it also runs the report server. There is also a virtual server running our external Web Server. Although both web servers are both on the same domain, the web server has restricted acces to the SQL Server. The problem we have just come accross during development is , Any Internal user can access the 'https://DomianName/ReportServer2005.aspx without a problem, however when the web server calls for a report we get a The request failed with HTTP status 401: Unauthorized.
Response URI: https://DomainName/ReportServer/ReportExecution2005.asmx
Both the external website and internal sites are using forms authentication, although i have made no amendments to any report server config files. In the report manager I have added domainName\MachineName$ for the web server in the site security.
Can anyone give me any guidance on this. The webserver will only be calling reports in one directory and with one user name and password
Dont ask me .. i dont know
No comments:
Post a Comment