prashantmishrasblog.blogspot.com

Prashant Mishra

Thursday, June 12, 2014. How to get random dates in a range? DECLARE @D1 DATE = '20000101'. DECLARE @D2 DATE = '20141231'. WITH E00(N) AS (SELECT 1 UNION ALL SELECT 1),. E02(N) AS (SELECT 1 FROM E00 a, E00 b),. E04(N) AS (SELECT 1 FROM E02 a, E02 b),. E08(N) AS (SELECT 1 FROM E04 a, E04 b),. E16(N) AS (SELECT 1 FROM E08 a, E08 b),. E32(N) AS (SELECT 1 FROM E16 a, E16 b),. Cte(N) AS (SELECT ROW NUMBER() OVER (ORDER BY N) FROM E32). DATEADD(DAY,ABS(CHECKSUM(NEWID() ) % (1 DATEDIFF(DAY,@D1,@D2) ,@D1). Adven...

http://prashantmishrasblog.blogspot.com/

OVERVIEW OF prashantmishrasblog.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

7

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR PRASHANTMISHRASBLOG.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

August

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Thursday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.3 out of 5 with 15 reviews

5 star

8

4 star

4

3 star

3

2 star

0

1 star

0

Hey there! Start your review of prashantmishrasblog.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.6 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT PRASHANTMISHRASBLOG.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

7

SSL

EXTERNAL LINKS

0

SITE IP

172.217.11.33

LOAD TIME

0.563 sec

SCORE

6.2

PAGE TITLE

Prashant Mishra | prashantmishrasblog.blogspot.com Reviews

<META> DESCRIPTION

Thursday, June 12, 2014. How to get random dates in a range? DECLARE @D1 DATE = '20000101'. DECLARE @D2 DATE = '20141231'. WITH E00(N) AS (SELECT 1 UNION ALL SELECT 1),. E02(N) AS (SELECT 1 FROM E00 a, E00 b),. E04(N) AS (SELECT 1 FROM E02 a, E02 b),. E08(N) AS (SELECT 1 FROM E04 a, E04 b),. E16(N) AS (SELECT 1 FROM E08 a, E08 b),. E32(N) AS (SELECT 1 FROM E16 a, E16 b),. Cte(N) AS (SELECT ROW NUMBER() OVER (ORDER BY N) FROM E32). DATEADD(DAY,ABS(CHECKSUM(NEWID() ) % (1 DATEDIFF(DAY,@D1,@D2) ,@D1). Adven...

<META> KEYWORDS

1 prashant mishra

2 total pageviews

3 from cte

4 no comments

5 email this

6 blogthis

7 share to twitter

8 share to facebook

9 share to pinterest

10 use dbname;

CONTENT

Page content here

KEYWORDS ON PAGE

prashant mishra,total pageviews,from cte,no comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,use dbname;,alter database dbname,adventureworksdw2012 data file,create database,filename,attach rebuild log,where,having,select

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Prashant Mishra | prashantmishrasblog.blogspot.com Reviews

https://prashantmishrasblog.blogspot.com

Thursday, June 12, 2014. How to get random dates in a range? DECLARE @D1 DATE = '20000101'. DECLARE @D2 DATE = '20141231'. WITH E00(N) AS (SELECT 1 UNION ALL SELECT 1),. E02(N) AS (SELECT 1 FROM E00 a, E00 b),. E04(N) AS (SELECT 1 FROM E02 a, E02 b),. E08(N) AS (SELECT 1 FROM E04 a, E04 b),. E16(N) AS (SELECT 1 FROM E08 a, E08 b),. E32(N) AS (SELECT 1 FROM E16 a, E16 b),. Cte(N) AS (SELECT ROW NUMBER() OVER (ORDER BY N) FROM E32). DATEADD(DAY,ABS(CHECKSUM(NEWID() ) % (1 DATEDIFF(DAY,@D1,@D2) ,@D1). Adven...

INTERNAL PAGES

prashantmishrasblog.blogspot.com

1

Prashant Mishra: Report Deployment on Report Server

http://prashantmishrasblog.blogspot.com/2013/02/report-deployment-on-report-server.html

Sunday, February 24, 2013. Report Deployment on Report Server. Once the report has been made, next we need to deploy that on the report server. To do so, we need to know the report server name. From the Configuration Tools, we need to choose the Reporting Services Configuration Manager. The Reporting Services Configuration Manager window opens up as shown under. Click on the Connect button and we will be presented with the below screen. And the result is as under. After we click on the OK button , lets c...

2

Prashant Mishra: How to empty a SQL Server database transaction log file

http://prashantmishrasblog.blogspot.com/2014/03/how-to-empty-sql-server-database.html

Thursday, March 27, 2014. How to empty a SQL Server database transaction log file. Sometimes the log file size is more than the db size. In my case, i have 3GB database and 10 GB log files which was occupying all my C drive space and i was not able to run any query against that database. So finally got a script to to truncate the transaction log which saved all my time and effort and the new log file size was 1 MB. Amazing! Truncate the log by changing the database recovery model to SIMPLE. Data Profilin...

3

Prashant Mishra: Install Samples Database AdventureWorksDW2012 for SQL Server 2012

http://prashantmishrasblog.blogspot.com/2013/06/install-samples-database.html

Tuesday, June 25, 2013. Install Samples Database AdventureWorksDW2012 for SQL Server 2012. AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from CodePlex site. AdventureWorks has replaced Northwind and Pubs from the sample database in SQL Server 2005.The Microsoft team keeps updating the sample database as they release new versions. For SQL Server 2012 RTM Samples AdventureWorks Database is released:. E: AdventureWorksDW2012 Data.mdf'. Posted by Prashant Mishra. Adding...

4

Prashant Mishra: Difference between Stored Procedures and Functions

http://prashantmishrasblog.blogspot.com/2013/05/difference-between-stored-procedures.html

Monday, May 13, 2013. Difference between Stored Procedures and Functions. Procedure can return zero or n values whereas function can return one value which is mandatory. Procedures can have input/output parameters for it whereas functions can have only input parameters. Procedure allows select as well as DML statement in it whereas function allows only select statement in it. Functions can be called from procedure whereas procedures cannot be called from function. S with other tables. Common Table Expres...

5

Prashant Mishra: How to get random dates in a range?

http://prashantmishrasblog.blogspot.com/2014/06/how-to-get-random-dates-in-range.html

Thursday, June 12, 2014. How to get random dates in a range? DECLARE @D1 DATE = '20000101'. DECLARE @D2 DATE = '20141231'. WITH E00(N) AS (SELECT 1 UNION ALL SELECT 1),. E02(N) AS (SELECT 1 FROM E00 a, E00 b),. E04(N) AS (SELECT 1 FROM E02 a, E02 b),. E08(N) AS (SELECT 1 FROM E04 a, E04 b),. E16(N) AS (SELECT 1 FROM E08 a, E08 b),. E32(N) AS (SELECT 1 FROM E16 a, E16 b),. Cte(N) AS (SELECT ROW NUMBER() OVER (ORDER BY N) FROM E32). DATEADD(DAY,ABS(CHECKSUM(NEWID() ) % (1 DATEDIFF(DAY,@D1,@D2) ,@D1). Displ...

UPGRADE TO PREMIUM TO VIEW 2 MORE

TOTAL PAGES IN THIS WEBSITE

7

SOCIAL ENGAGEMENT

prashantmishradhanbad

OTHER SITES

prashantmasala.com

PrashantMasala

Dsfsdfsdfsdfsd Provides standard interfaces for integration components and protocols to plug into. JBI is based on JSR 208 (an extension of Java 2 Enterprise Edition (J2EE) and is specific for JBI Service Provider Interfaces (SPI) . 2) OpenESB It is an open-source implementation of JSR-208 (JBI). 3) WSO2 and Sevicemix (from apache) are also available.

prashantmaxsteel.blogspot.com

SBF - Voice of India

SBF - Voice of India. Enter your search terms. Uarr; Grab this Headline Animator. Monday, 20 July, 2009. This is a test post from. A fancy photo sharing thing. Envisaged by max steel. Tag Em Up: Photography. Wednesday, 20 May, 2009. A new venture - ambigrams. This is the new pastime. ambigrams. Though angels and Demon of Dan Brown formally introduced me to the concept, it was not before I visited the ambigram Flickr community and John Langdon's website that I decided to give it a try. Tag Em Up: ambigram.

prashantmendiratta.com

Random Walk | Down The Stock Market

Down The Stock Market. Views On Stock Market. Grief & Happiness : 2 sides of same coin. Is Your Brain Wired To Diversify. Subscribe to Prashant Mendiratta. Enter your email address to receive notifications of new posts by email. Join 3 other subscribers. Grief & Happiness : 2 sides of same coin. Happiness and grief are 2 sides of the coin. If some thing gives you grief then the opposite should get you equal amount of happiness. Let us try applying this principal in the stock market. May God be with you a...

prashantmishra.net

prashant mishra – i spy with my little eye, something beginning with…

I spy with my little eye, something beginning with. Disruptive Technologies and its effect on Society. Keynote Address at the Seminar on “Disruptive Technologies and The Impact on the Society” organized by Madras Institute of Technology, 16/02/2018] Thank you for the opportunity to speak. When I was asked to present the keynote address on this topic, the technical evangelist in me was overjoyed. Telling you all …. The hand that rocks the cradle. The futility of LinkedIn – Or is it just me? Learn to live ...

prashantmishra1.blogspot.com

Winds of Change- The memoirs of my NGO days!

Winds of Change- The memoirs of my NGO days! In this blog, I have tried to capture some of my experiences that I gathered as an NGO worker in PRADAN from April 2002 to June 2004. The objective is to share these with people who might be interested in such experiences at the grassroots. The views expressed in this blog are solely mine and they do not represent any institution or organization that I have worked in past or present. Sunday, July 19, 2015. Posted by Prashant Mishra. Wednesday, June 24, 2015.

prashantmishrasblog.blogspot.com

Prashant Mishra

Thursday, June 12, 2014. How to get random dates in a range? DECLARE @D1 DATE = '20000101'. DECLARE @D2 DATE = '20141231'. WITH E00(N) AS (SELECT 1 UNION ALL SELECT 1),. E02(N) AS (SELECT 1 FROM E00 a, E00 b),. E04(N) AS (SELECT 1 FROM E02 a, E02 b),. E08(N) AS (SELECT 1 FROM E04 a, E04 b),. E16(N) AS (SELECT 1 FROM E08 a, E08 b),. E32(N) AS (SELECT 1 FROM E16 a, E16 b),. Cte(N) AS (SELECT ROW NUMBER() OVER (ORDER BY N) FROM E32). DATEADD(DAY,ABS(CHECKSUM(NEWID() ) % (1 DATEDIFF(DAY,@D1,@D2) ,@D1). Adven...

prashantmjohn.com

prashantmjohn

prashantmodi.com

Prashant Modi, GEECL Managing Director

Prashant Modi signs CNG supply and retail agreement. Prashant Modi: Challenges for Energy Providers in India. Prashant Modi, GEECL Managing Director and CEO. Prashant Modi has been associated with the Company and its Promoter Group companies since 1996. At present, he is the Chief Executive Officer and Managing Director of Great Eastern Energy Corporation Limited (GEECL). Under his leadership, GEECL. Has witnessed progressive growth in revenue, production and profit over the years.

prashantmodi.info

Prashant Modi - Website on the Indian Businessman

GEECL’s First Natural Gas Pipeline commissioned in West Bengal. Great Eastern Energy Corporation Limited ( GEECL. Has successfully commissioned its first natural gas pipeline extending 11.8 km from its Gas Gathering Station to its Central Gathering Station in Asansol, West Bengal. It is slated to be its first CBM (Coal Bed Methane) gas pipeline and will be part of a vertically integrated network consisting of drilling, production, compression transportation and distribution services.

prashantmodi.net

Prashant Modi - The Businessman at Great Eastern Energy Corporation Ltd

Prashant Modi – The Businessman. Information featuring Prashant Modi and his business activities. Skip to primary content. Skip to secondary content. Prashant Modi – Videos. Prashant Modi led Great Eastern Energy features in Fox-Davies Newsflash. March 19, 2013. Original-Gas-In-Place (OGIP) increased 2% to 2.40 TCF (from 2.35 TCF as at May 2012). In May 2010 (3P numbers reported as at November 2009). Prashant Modi – Coal mining occurring in CBM blocks. November 7, 2012. One of the main issues which compa...

prashantmodi.org

Prashant Modi - CEO of Great Eastern Energy Corporation

CEO of Great Eastern Energy Corporation. Great Eastern Energy Corporation Limited (GEECL) appoints Prashant Modi as CEO and MD. Great Eastern Energy Corporation Limited (GEECL) appoints Prashant Modi as CEO and MD. On Monday, November 9, 2015. Prashant Modi – Chief Executive Officer and Managing Director of GEECL. Prashant Modi, CEO & MD of GEECL Plans 768 Million Investment on Unconventional Energy Sources. Theme by Scissor Themes. Proudly powered by WordPress.