Profile

Cover photo
ritesh kumar
Attended NIIT
Lives in bhubaneswar
2,601 followers|13,696,750 views
AboutPostsPhotosVideos+1's

Stream

ritesh kumar

Shared publicly  - 
 
Script to count total numbers of lines in a stored procedure in SQL Server
Below
script can be used to count total numbers of line inside a stored procedure in
SQL Server --Specific
Procedure DECLARE @ProcedureName AS SYSNAME = 'YourSpName' SELECT      Name ,      LEN ( OBJECT_DEFINITION ( [Object_id] ))   - LEN ( REPLACE ( OBJECT...
1
Add a comment...

ritesh kumar

Shared publicly  - 
 
Term extraction transformation SSIS example
This transformation extracts the noun and noun phrases from
text. Let's understand Term extraction transformation SSIS by simple example: Step 1:
Create a new table and populate with some data: CREATE TABLE tblDocument (      ntDocumentID BIGINT      , vcDo...
1
Add a comment...

ritesh kumar

Shared publicly  - 
 
How to save data of field in a file of given column path SSIS: Export column transform
Export columns transform is used to store text\image\binary
content as a file at given location in different column of a table. For
example: Step 1:
Create a new table and populate with some data: CREATE TABLE tblDocument (      ntDocumentID BIGINT      , v...
1
Add a comment...

ritesh kumar

Shared publicly  - 
 
Cache transform very simple example in SSIS | demo
What
is cache transform in SSIS? Or Explanation and use of cache transformation Cache transform is cached dataset
for lookup transformation. Let's assume we are loading user information but
user data keeps country id and we have to replace country id    by ...
1
Add a comment...

ritesh kumar

Shared publicly  - 
 
Understand execution Tree and configure | enable in SSIS
What
is execution Tree in SSIS? Execution tree is property of data
flow task.  It describes how many data buffers
need to be allocated to perform data flow task.  Execution tree is group of transformation
which start from source adapter or blocking\semi-blo...
1
Add a comment...

ritesh kumar

Shared publicly  - 
 
SSIS Aggregate very simple example | Demo
SSIS
Aggregate Transformation | Component by simple example for beginner step by
Step in BIDS Use: Aggregate Transformation is
used to get the aggregated value of given input. Let's assume a table named
tblUserMarks with below data: UserMarksID ntUserID vcS...
1
Add a comment...
Have him in circles
2,601 people
Kamlesh Joshi Joshi's profile photo
Gebremedhin Hadgu's profile photo
Tulasi Tht's profile photo
Pushya mitra's profile photo
FRANCISCO DE ASSIS FERREIRA's profile photo
TheArpitkoberoi's profile photo
ntindikihi massati's profile photo
Ram Isgoodboy's profile photo
Abebe Moges's profile photo

ritesh kumar

Shared publicly  - 
 
How to remove comment from SQL script \ procedures SQL server
Sometimes there is a need to remove
or delete comment part of SQL script from procedures, functions etc in SQL server.
We can do this using below SQL function: CREATE FUNCTION [dbo] . [RemoveComment] (      
@ScriptText AS VARCHAR ( MAX ) ) RETURNS VARCHAR ...
2
Ganesh Amirineni's profile photo
 
databse object no need
Add a comment...

ritesh kumar

Shared publicly  - 
 
Import column transformation example SSIS
Using import column transformation data can be loaded from file
system task (content of a file) to database or any other destination adapter.  For example: Let's
assume we have a table named document. We want to load content of file to
vcData column accordi...
1
Add a comment...

ritesh kumar

Shared publicly  - 
 
Character Map Transform very simple example in SSIS | Demo
Character Map Transform is used to
perform different operations on string data.  List of all character map transform: a. Byte reversal b. Full width c. Half width d. Hiragana e. Katakana f. Linguistic casing g. Lowercase h. Simplified Chinese i. Traditional...
1
Add a comment...

ritesh kumar

Shared publicly  - 
 
Audit Transformation SSIS simple example
What
is audit transformation in SSIS? Audit transformation is a component
of the data flow task.   It is used to keep the auditing information of
package in case of success or failure. This auditing information includes: a. Execution instance GUID b. Packag...
1
Add a comment...

ritesh kumar

Shared publicly  - 
 
Multiple output of aggregate transformation configuration SSIS
Aggregate
transformation or component can have only input but more than one \multiple
output. It means there is no need to create multiple data source or
multi cast transformation.   In this example we are going to illustrate how
to configure two output pip...
1
Add a comment...

ritesh kumar

Shared publicly  - 
 
Get all the indexes name used by a query or Stored procedure in sql server
This script helps you to know that a
query or stored procedure is utilizing the specific indexes created by you.   W hat indexes are no longer used etc? Script to
get list of all the indexes used by a given query SQL Server: --Replace with
your secript. If ...
2
Bilal Sultan Al-Samaee's profile photo
 
Please Please I want program in c to store any sentence and the convert the sentence in such way that 1st letter of every world is capital and remaining letters in lower case.
Add a comment...
People
Have him in circles
2,601 people
Kamlesh Joshi Joshi's profile photo
Gebremedhin Hadgu's profile photo
Tulasi Tht's profile photo
Pushya mitra's profile photo
FRANCISCO DE ASSIS FERREIRA's profile photo
TheArpitkoberoi's profile photo
ntindikihi massati's profile photo
Ram Isgoodboy's profile photo
Abebe Moges's profile photo
Education
  • NIIT
    MCA
Basic Information
Gender
Male
Work
Occupation
Engineer
Skills
Sql Server, SSIS,SSRS, SSAS
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
bhubaneswar
Previously
Jharkhand - Patna,Ranchi,Bhubaneswar
ritesh kumar's +1's are the things they like, agree with, or want to recommend.
Write a c program to find the roots of a quadratic equation
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

C Command line argument questions with solution
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

C questions and answers
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

C operator questions with answers
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

Data type questions in c
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

C PROGRAMMING INTERVIEW QUESTIONS AND ANSWER
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

Factorial of big numbers in c
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

C program to print different shapes using printf function
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

Write a c program to find out the sum of series 1 + 2 + …. + n.
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

C PROGRAM TO CALCULATE AREA OF A CIRCLE
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

C program to convert decimal to roman number
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

C program fractional binary conversion from decimal
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

C program for fractional decimal to binary fraction conversion
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

C online exam
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

C programming online test
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

C questions answers
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

What is Ellipsis or … in c ?
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr

How to pass parameters in the function in C
www.cquestions.com

C language tricky good pointers questions answers and explanation operators data types arrays structures questions functions recursion prepr