There are many ways to ETL the XML files, you can using c#(or any other language you’d like to) code parse it based on the schema and bulk insert into database, or import it into excel then load it into tables, or using SSIS, whatever you like and you feel you are comfortable with. And… Continue reading Bulk load and parse XML file into SQL database tables

This blog is from —http://www.ponjavic.com/wordpress/2014/09/16/setup-infor-syteline-8-03-customer-portal/#comments thanks M. Setup Infor SyteLine 8.03 Customer Portal mSeptember 16, 2014 Infor 1 Comment Below post outlines how to setup and configure Infor SyteLine 8.03.20 customer and vendor portals. SQL Account Configuration We’ll be setting up and configuring portals on a dedicated server running Microsoft Windows Server Standard 2008 R2.… Continue reading Setup Infor SyteLine 8.03 Customer Portal–By M. from “Technomancy for the masses”

There was an issue with cube processing with my current client, we have two cubes, one with 80 millions rows fact table, the other has 10 millions row fact table.before May everything was fine, the cube was processed twice a month, and in the weekends, both of them will take 18 hrs total, it’s very… Continue reading SSAS -Index tables and enhance the process speed

In SAS , when we import raw data, a blank space is usually to determine a value end and the next begins. Then what if we want to input one value for an objective as one variable? The ampersand format modifier & solve the problem. But to really make things work, the next input variable… Continue reading SAS input data format (date and blank space embedded)

This practice is aiming to help the very beginners to get an idea how to import file without using wizard. I use SAS Enterprise Guide onDemand for academics, it´s free and you can download it through the official website: http://www.sas.com/en_us/industry/higher-education/on-demand-for-academics.html Okay, if you want to import file through code, you need either a local server(while it’s… Continue reading SAS Practice import File

Last night I came across a question posted on Experts Exchange website. The user was asking which performance would be better, case when or union. It is a very interesting question, and a lot professionals give their opinions. (well without elaborating or explain it) and the verified so called “best” answer, that developer very firmly announced… Continue reading SQL Query Performance of union & case

  Add days/months/years to a given datetime Add days to a given days: SELECT DATEADD(DAY, -1, ‘2015-11-30’) SELECT DATEADD(DAY, 1, GETDATE()) Same logic for add years or month MONTH: SELECT DATEADD(MONTH, 1, GETDATE()) YEAR:  SELECT DATEADD(YEAR, 1, GETDATE()) 2.Displaying date in different formats. default: SELECT CONVERT(char(20),GETDATE(),0) USA mm/dd/yyyy: SELECT CONVERT(char(20),GETDATE(),101)   SELECT CONVERT(char(20),GETDATE(),1) mm-dd-yyyy :  SELECT… Continue reading SQL DATE/TIME FUNCTION QUERIES:

 I have several reports which already deployed, and I want to execute the reports without subscribe the report in report manager. Here I used batch file to call an rss file to execute a report with parameter.  my report name is TEST PARAMETER , I have two parameters in this report, one is ACCNT_CODE is… Continue reading SSRS -render report by bat call RSS file and passing parameters to report

When export report into txt file, column names are missing, it’s because column names will come as headers in the file.To make the columns name display in the file, simply make one small change go to directory: C:\Program Files\Microsoft SQL Server\MSRS{YourSQLServerVersion}.MSSQLSERVER\Reporting Services\ReportServer open the rsreporterver.config, and change it to <NoHeader>false<NoHeader>  

I received a query from my supervisor today, she need me to create a report, and what I need to do is just create parameters in SSRS and map them with the variables in the query,  it would be a snap report. I start to check the query. In the beginning of the query, a temp… Continue reading Index in temp table–yes or no?