|
|
-
|
|
I just learned that when you copy-paste a Table in Power Pivot it does not copy-paste the formula's. It just paste's the data in the target table. I just learned that when I was testing the Power Pivot model before emailing the client. ...
|
|
-
|
|
I just learned while trying to understand the client's requirement for a Power Pivot Model that when they say reports based on rolling six/twelve months, they mean reports for data that correspond to "past" six/twelve months. ...
|
|
-
|
|
Found another good reason to avoid using IN clause in your TSQL Queries. See the example below:
create table #temp
(
a int ,
)
create table #temp1
(
b int ,
)
INSERT #temp VALUES(1)
INSERT #temp VALUES(2)
INSERT #temp1 VA...
|
|
-
|
|
There are four schedule types.
1. One Time : It executes once as per the schedule
2. Recurring : It is recurring type and execute on specified interval on specified time till schedule end.
3. Start when CPU Idle : It executes when CPU is sufficient f...
|
|
-
|
|
I just learned that In Firefox there is a "Do not track" privacy feature. When you switch it on it sends a signal (via HTTP header) to websites that you do want to be tracked. Though, setting this option does not "Enforce" the website to not track you -...
|
|
-
|
|
It is not possible to create the VIEW in another database directly - unlike CREATE TABLE, CREATE VIEW statement doesn't have a "database_name" - part in its syntax. But you can do it by calling sp\_executesql stored procedure:
DECLARE @s nvarchar(1000...
|
|
-
|
|
If you want to create a row based checksum, you can use build-in functions CHECKSUM or BINARY\_CHECKSUM. Unfortunately, these functions are not precise enough - the chance to get the wrongly equal values is relatively high.
There is another function - H...
|
|
-
|
|
Hello friends today i check foreign key constraint can't support in bulk insert task.please take corrective action when you upload data.
Create table Tbl1
(
id int primary key,
varname varchar(50),
fk_ID int
)
Alter table T...
|
|
-
|
|
Copy And paste Query
Create table #temp1
(
id int ,
Name varchar(50),
City varchar(50)
)
Create table #Staging_temp2
(
id int,
Name varchar(50),
City varchar(50)
)
insert into #temp1
se...
|
|
-
14
Liked
| 10
Learned
| 3
Comments
|
|
Hello friends, one interviewer asked that suppose you have two tables
`Employee_Details`, `Employee_Details_History`
now I want to delete original table `Employee_details` and maintain it’s history to other table.
How can it’s possible with only sin...
|
|