OrientDeveloper's: July 2011

Friday, July 22, 2011

Thursday, July 14, 2011

Custom Paging Data Procedure

Custom Paging Data Procedure: "CREATE PROCEDURE procGetCustomPagingData
@PageIndex INT = 1
,@PageSize INT = 10
,@RecordCount INT OUTPUT
AS
BEGIN
SET NOCOUNT ON;
SELECT ROW_NUMBER() OVER
(
ORDER BY [ID] ASC
)AS RowNumber
,[Sales_Accounts]
,[Other_Income]
,[Total_Revenue_A]
,[NetProfit]
INTO #Results
FROM [tblmastertable]

SELECT @RecordCount = COUNT(*)
FROM #Results

SELECT * FROM #Results
WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1

DROP TABLE #Results
END

Calculate Execution Time of the Query

Calculate Execution Time of the Query: "Method 1:

DECLARE @StartTime datetime
,@EndTime datetime

SELECT @StartTime=GETDATE()

SELECT * FROM tblmastertable ORDER BY Insertion_time DESC

SELECT @EndTime=GETDATE()

SELECT DATEDIFF(ms,@StartTime,@EndTime) AS [Duration in millisecs]

Method 2:

SET STATISTICS TIME ON

SELECT * FROM tblmastertable ORDER BY Insertion_time DESC

SET STATISTICS TIME OFF

Friday, July 8, 2011

its coding time | Visual Studio 2010 Keyboard and Mouse Shortcuts

its coding time | Visual Studio 2010 Keyb

Publish Post

oard and Mouse Shortcuts

Sunday, July 3, 2011

Transparent Watch Inspired by Water

Transparent Watch Inspired by Water: "

To celebrate the 10th anniversary of the Issey Miyake watch project, Japanese designer Tokujin Yoshioka has created one strikingly beautiful timepiece. Simply called 'O' or pronounced eau (which means water), this transparent watch is suppose to look as if it's been sculpted of water or from a block of ice.

Tokujin Yoshioka's website

via [Design Boom]"

Not Cardboard Children: Tobago

Not Cardboard Children: Tobago: "

Bloody stoners.

Last week at least a couple of you complained that it’s been ages since our weekly Cardboard Children column covered a board game you could reasonably be expected to take home to meet your mother or non-gamer friends. Something that didn’t feature goblins anywhere at all. Not even in an expansion.

Have you all really bought Survive! already? Well, here’s another one anyway: Tobago. A game of archaeology, buried treasure and open betrayal.
(more…)

Natural Born Tattoos: 35 Fierce Nature Images In Ink

What better way to show off your harmony with nature than proudly displaying a tattoo with a gorgeous landscape, or fierce growling animal? Some nature tattoos are better than others, but the best are truly awesome.

(Images via tattoopatrol, tattoo-taboo, hatpit, bonsaitreecarecenter, flawkeyminve)

It’s pretty obvious that the first thing anyone thinks when the word “nature” is mentioned, is trees. Able to be both stark and foreboding, and lush and beautiful, trees are a fantastic way to decorate one’s body. There are so many variations that each tattoo can be radically different. It certainly seems like cherry blossoms are a fan favorite, judging by how many women have them tattooed across their side.

(Images via tattoos21, snake-tattoos, mdtattoos, reptile-forums, zimbio)

Snakes are gorgeous and deadly… frightening to most, but beautiful to some. These natural hunters are classic when used to adorn one’s body. Throw in an apple and the tattoo even has biblical significance!

(Images via tattoosurfink, radaris, tattoosbydesign)

Gorgeous landscapes and rushing, roiling, waves show off the power and majesty of nature. Looking at some of these tattoos makes one feel like they are on a walk through the rainforest, or faced with a secluded natural wonder.

(Images via flickriver, mogoel, 2tattoodesigns, offthemaptattoo)

Insects. Gross. Even the most ardent insect hater has to admit that their is something otherworldly about their appearance. Some tattoos try to bring out the beauty of the natural world by displaying the unique aspects of insects; others are content to use the alien aspects to terrify.

(Images via fash99, tattooconventionsnow, wantsupcandra, citattooz)

Koi tattoos are incredibly popular in Asian cultures and hold a very special cultural significance. American culture is a lot less sedate, and the tattoos here reflect that, with a much heavier emphasis on fishing than the beauty of the fish themselves.

(Images via offthemaptattoo, beaunetharo, mohedota, zimbio, bird-tattoos)

One doesn’t have to be a bird lover to appreciate their beauty. With large, colorful wings, and incredible variations from species to species, it’s no wonder that birds are one of the most popular tattoo subjects.

(Images via thetattooist, tatto-o.info, bushwarriors, kacewasli, tatoogallery)

It’s hard to deny the power that bears represent. As one of the largest and most fierce land animals (when they want to be), the bear makes for a great looking tattoo. Do not mess with anyone sporting a giant portrait of a growling bear. It can only lead to bad things.

(Images via offthemaptattoo, animal-tattoos, topoftattoo, cafernlistvi)

Wolves and lions live a world apart, but they both signify an independent spirit that is at the top of its class. These animals are considered noble by most, and powerful by all. Not a bad choice for a tattoo, then, huh?

Want More? Click for Great Related Content on WebUrbanist:

Robot Tattoos: Awesome Mechanical Body Art

We give life to our robot visions in the most permanent means at our disposal: ink. Here are some of the most creative and well done robot tattoos around:
2 Comments - Click Here to Read More »»

Kate Macdowell Porcelain: Explorations of Humans and Nature

Kate Macdowell creates stunning porcelain that is aesthetically beautiful, but also full of depth, as her pieces explore the interaction of humanity and nature.
1 Comment - Click Here to Read More
»»

Primates: Humans in Their Natural Form [NSFW]

We've come to think of humans as the masters of the planet, but individually we are still small and vulnerable. This lovely photo series captures our frailty.
Click Here to Read More »»

[ By Marc in Environment & Nature & Gadgets & Geek Art & Guerilla Action & Art. ]

[ WebUrbanist | Archives | Galleries | Privacy | TOS ]

Beautiful photography, isn’t it? Except these aren’t photos. Welcome to the wonderful world of hyper realist art, where artists use incredible techniques to make photo-realistic paintings so realistic that it seems impossible they were painted by hand.

Yigel Ozeri

(Images via mymodernmet, bitsofteeniness, artlistpro, afewreviews)

Yigel Ozeri is a New York-based artist who loves painting young women, and the only way to tell these aren’t true photographs is by checking out the background, which is just too out of focus for your typical photo.

Stephen Shub

(Images via discoveredartists, frontiernet, discoveredartists, discoveredartists)

Stephen Shub loves cars, and while his paintings concentrate mainly on America’s classic vehicles, he also showcases his skill with intricate paintings of what seems like impossible complexity.

Simon Hennessey

(Images via likecool, thecuriousbrain)

Simon Hennessey concentrates on human faces, one of the most difficult subjects for hyper realist masters to tackle. Humans are hardwired to pick up details of other’s faces, so it’s a testament to Simon’s skill that he’s able to bypass our subconscious and trick it into believing his paintings are real.

Raphaella Spence

(Images via designyoutrust, fineartamerica, recave, zupi)

These images are not postcards from famous locations, they’re hand painted studies by Raphaella Spence, a master painter whose still life subjects are quite larger than most.

Mikel Glass

(Images via 9to6, artisticthings)

Mikel Glass does not always concentrate on the hyper realist aspects of a painting, though some of his works display an ability that puts him in the top tier of this style of artist.

Deborah Rubin

(Images via deborahrubin, artistsnetwork, rmichelson, springfieldmuseums)

Part of the fascination Deborah Rubin’s fans have with her work has to do with the fact that her hyper realist paintings are done using watercolor – a medium not well suited for incredibly accurate paintings.

Davis Cone

(Images via 163, artnet, wfreese, wfreese)

Davis Cones loves to capture every detail of remnants of America’s past. The vintage movie house on main street will be preserved through his paintings long after it’s replaced by a generic pharmacy.

Ron Mueck

(Images via brooklynmuseum, eklektz, rustylime)

Ron Mueck is unique in that his hyper realism is exhibited in sculpture. Imaging walking into a gallery and facing down an oversized human, and being unable to tell (without touching) that they’re fake. It’s a blessing that Ron tends to exaggerate features, or it would be easy to overlook his sculptures as just another person strolling through the gallery.