|
|
-
|
|
I rarely use case statements in SQL where clause. But in SSRS reports, I find myself use it occasionally. It’s not hard to code it, it’s only the syntax that is tricky. I am very much against writing complex SQL code for any SSRS reports. A stored procedure will be a better solution for ......
|
|
-
|
|
Goal
Need to set up a SQL account for data source on the report server.
Solution
Select “Credential stored securely in the report server”. The credential EAM_ETL_Reader needs to be created first.
This should create a SQL account EAM_ETL_Reader.
CREATE USER [EAM_ETL_Reader]
FOR......
|
|
-
|
|
If you want to apply line break for labels in SSRS, you can use the "VbCrLf" function.
Here is an example.
......
|
|
-
|
|
Problem: when using a package template, or copying and pasting a package to clone a package in Solution Explorer, the newly created package has the same ID as its parent. This can be a problem in production environment where multiple packages having the same PackageID, logging into the same database......
|
|
-
|
|
Goal
Create an ETL audit table (tblETLAudit)
Use an Execute SQL Task to enter entries into the ETL audit table
Need to pass system and user variables to the Execute SQL Task
Issues
There are 4 system variables, and one user variable I want to pass to the Execute SQL Task. To accomplish this......
|
|
-
|
|
I have a folder under the Developers Projects. I need to create a few sub-folders, and also a Solution in VS to associate solutions items to those sub-folders.
Here is how I did it.
We first need to create a new project in Visual Studio. Highlight my folder, then go to menu File –> New &ndas......
|
|
-
|
|
Question:
What is a surrogate key and where do you use it?
Answer:
A surrogate key is a substitution for the natural primary key.
It is just a unique identifier or number for each row that can be used for the primary key to the table. The only requirement for a surrogate primary key is that it......
|
|
-
|
|
Majority of the operational databases are in 3NF (3rd Normalized Form). Data warehouse, on the other hand, uses dimensional models. What really is the key difference between 3NF and dimensional models?
As I understand it’s the degree of normalization. Remember both model types can be presente......
|
|
-
|
|
We just need to understand what a commercial software’s Last Id strategy is and how they implement it.
First of all, we understand that the Last Id is THE Last ID that covers all the SQL tables, and there is no Last Id for any specific SQL table.
After some help from their developers, a stor......
|
|
-
|
|
I am not talking about the security item filter that applies to a specific user (or a group of users) here. I want to create a data filter that applies to a specific entity(s) whenever that entity is used in a query, regardless of the userid.
Follow these steps.
Create a filter for the entity.
......
|
|