blog.rathni.com

Kiran Rathni

Wednesday, September 19, 2007. Top n records by type/ category. The title says it all. DECLARE @tmp TABLE(ID INT, Type VARCHAR(10), Name VARCHAR(30), CreatedDate DATETIME). INSERT INTO @tmp(ID, Type, Name, CreatedDate). SELECT 1, 'Car', 'Honda', '1/1/2007'. SELECT 2, 'Car', 'Toyota', '1/2/2007'. SELECT 3, 'Car', 'BMW', '1/3/2007'. SELECT 4, 'Color', 'Red', '1/1/2007'. SELECT 5, 'Color', 'Black', '1/2/2007'. SELECT 6, 'Color', 'White', '1/3/2007'. SELECT 7, 'Model', 'Model1', '1/1/2007'. Type ASC, Name ASC.

http://blog.rathni.com/

OVERVIEW OF blog.rathni.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

12

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR BLOG.RATHNI.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Monday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.8 out of 5 with 4 reviews

5 star

3

4 star

1

3 star

0

2 star

0

1 star

0

Hey there! Start your review of blog.rathni.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.5 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT BLOG.RATHNI.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

12

SSL

EXTERNAL LINKS

0

SITE IP

104.28.18.27

LOAD TIME

0.516 sec

SCORE

6.2

PAGE TITLE

Kiran Rathni | blog.rathni.com Reviews

<META> DESCRIPTION

Wednesday, September 19, 2007. Top n records by type/ category. The title says it all. DECLARE @tmp TABLE(ID INT, Type VARCHAR(10), Name VARCHAR(30), CreatedDate DATETIME). INSERT INTO @tmp(ID, Type, Name, CreatedDate). SELECT 1, 'Car', 'Honda', '1/1/2007'. SELECT 2, 'Car', 'Toyota', '1/2/2007'. SELECT 3, 'Car', 'BMW', '1/3/2007'. SELECT 4, 'Color', 'Red', '1/1/2007'. SELECT 5, 'Color', 'Black', '1/2/2007'. SELECT 6, 'Color', 'White', '1/3/2007'. SELECT 7, 'Model', 'Model1', '1/1/2007'. Type ASC, Name ASC.

<META> KEYWORDS

1 kiran rathni

2 union all

3 where

4 order by

5 output

6 6 row s affected

7 posted by kiran

8 clr split udf

9 using system;

10 namespace sqlutilities

CONTENT

Page content here

KEYWORDS ON PAGE

kiran rathni,union all,where,order by,output,6 row s affected,posted by kiran,clr split udf,using system;,namespace sqlutilities,dictionary,strlength ;,return dic;,keyvaluepair,dic = keyvaluepair,row;,reconfigure,compiling the udf,deploying the udf,begin

SERVER

cloudflare

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Kiran Rathni | blog.rathni.com Reviews

https://blog.rathni.com

Wednesday, September 19, 2007. Top n records by type/ category. The title says it all. DECLARE @tmp TABLE(ID INT, Type VARCHAR(10), Name VARCHAR(30), CreatedDate DATETIME). INSERT INTO @tmp(ID, Type, Name, CreatedDate). SELECT 1, 'Car', 'Honda', '1/1/2007'. SELECT 2, 'Car', 'Toyota', '1/2/2007'. SELECT 3, 'Car', 'BMW', '1/3/2007'. SELECT 4, 'Color', 'Red', '1/1/2007'. SELECT 5, 'Color', 'Black', '1/2/2007'. SELECT 6, 'Color', 'White', '1/3/2007'. SELECT 7, 'Model', 'Model1', '1/1/2007'. Type ASC, Name ASC.

INTERNAL PAGES

blog.rathni.com

1

Kiran Rathni: November 2006

http://blog.rathni.com/2006_11_01_archive.html

Wednesday, November 22, 2006. Convert String/ Object to Enum using Generics. As a developer you might have come across a need to get the enum from a string/ object value. This code snippet uses reflection and returns the enum. The test method below, shows the usage. Using System.Reflection;. Public static T GetEnum. String.IsNullOrEmpty(Value.ToString() ). Type type = typeof(T);. FieldInfo[] fieldInfos = type.GetFields();. Foreach (FieldInfo fi in fieldInfos). Return default(T); / Get's the 1st enum field.

2

Kiran Rathni: Kill SQL server database processes

http://blog.rathni.com/2007/06/kill-sql-server-database-processes.html

Friday, June 22, 2007. Kill SQL server database processes. This little script can kill all the database processes silently. Run this script before restoring the database so that the restore process gets exclusive access to the database. SET @DBName = 'YOUR DATABASE NAME GOES HERE' - Set database name. SELECT @DatabaseID = DB ID(@DBName). SELECT @SessionID = MIN(spid) FROM master.sysprocesses WHERE dbid = @DatabaseID. WHILE(@SessionID IS NOT NULL). SELECT @Sql = 'KILL ' CONVERT(VARCHAR(30), @SessionID).

3

Kiran Rathni: June 2007

http://blog.rathni.com/2007_06_01_archive.html

Friday, June 22, 2007. Kill SQL server database processes. This little script can kill all the database processes silently. Run this script before restoring the database so that the restore process gets exclusive access to the database. SET @DBName = 'YOUR DATABASE NAME GOES HERE' - Set database name. SELECT @DatabaseID = DB ID(@DBName). SELECT @SessionID = MIN(spid) FROM master.sysprocesses WHERE dbid = @DatabaseID. WHILE(@SessionID IS NOT NULL). SELECT @Sql = 'KILL ' CONVERT(VARCHAR(30), @SessionID).

4

Kiran Rathni: Enable regedit

http://blog.rathni.com/2007/03/enable-regedit.html

Friday, March 9, 2007. Run this script to enable registry editing/ regedit. Save the content to a text file and call it EnableRegEdit.vbs. Double click on the file to run. On Error Resume Next. Set Shell = WScript.CreateObject("WScript.Shell"). Delete DisableRegistryTools registry values. ShellRegDelete "HKCU Software Microsoft Windows CurrentVersion Policies System DisableRegistryTools". ShellRegDelete "HKLM SOFTWARE Microsoft Windows CurrentVersion Policies System DisableRegistryTools".

5

Kiran Rathni: January 2007

http://blog.rathni.com/2007_01_01_archive.html

Sunday, January 7, 2007. Newbie guide: Linux/ Unix exploit removal. Your linux server got hacked, what next? The following are first few steps in finding and removing exploits and root kits on a Linux or BSD system. 1 Execute the following commands to prevent upload of exploits:. Chmod 0750 `which curl` 2 &-; chmod 0750 `which fetch` 2 &-; chmod 0750 `which wget` 2 &-. 2 Execute the following commands to detect possible existing exploits:. 3 Install and run rkhunter/ Rootkit Hunter. For help with rkhunte...

UPGRADE TO PREMIUM TO VIEW 7 MORE

TOTAL PAGES IN THIS WEBSITE

12

OTHER SITES

blog.rateyourmp.com

RateYourMP

Find, Rate, Compare and Share your MP's Performance. Our initial post-General Election update is now live. We’ve added in all the new MPs, along with those that have returned allowing you to rate them in this Parliament. We will begin to add in performance data for them as it becomes available. You can still find and view your MPs performance from the last Parliament. We’ve also added a link into them from the current MPs profile. You can see the full examination here. We have been able to calculate the ...

blog.ratgeber-geld.com

Geldanlage Ratgeber: Aktuelle Informationen zum Thema Geldanlage Tagesgeld, Festgeld, Aktien, Kredite, Konten. › Ratgeber-Geld.com Blog

Geldanlage Ratgeber: Aktuelle Informationen zum Thema Geldanlage Tagesgeld, Festgeld, Aktien, Kredite, Konten. Skip to primary content. Skip to secondary content. Kreditkarten im Alltag – ein Zahlungsmittel, das immer beliebter wird. Die Vorteile einer Kreditkarte. Kann man bei allen Banken in Deutschland Bargeld abheben, ohne jegliche Gebühren zu zahlen. Diesem Trend folgen nun auch viele Banken. Wie kam es zu dem Tagesgeld-Trend? Die Finanzmärkte sind als Folge der europäischen Wirtschaftskrisen. Der g...

blog.ratgeber-mikrokredite.de

MIKROKREDITE in DEUTSCHLAND - NEWS, WISSENSWERTES UND KRITISCHES ZUM THEMA MIKROFINANZIERUNGEN

Junge Genossenschaft durch GLS-DMI-Mikrofinanzierung stark geschädigt. Middot; Add Comment. Read Full Article →. Ethische Mikrofinanzierung in Deutschland. Middot; Add Comment. Und es gibt sie doch noch! Read Full Article →. Schlechte Zeiten für echte Mikrokredite ab 2014. Middot; Add Comment. Nachdem lange unklar war, ob und wie es denn nach dem 31.12.2013 mit dem Mikrokreditfonds Deutschland überhaupt weitergeht, meldet nun das Mikrofinanzinstitut (MFI) Bonsai-Kredit. Zwar eine Neuauflage des Programms...

blog.rathbun.com

Rathbun Blog

ISO 9001 : 2000 compliant (510) 661-0950. March 7th, 2013. Thermally Conductive Acrylic Interface Pad. This material is truly great. It is Halogen Free and does not produce harmful outgassing. It has been developed for 21. Century Technology in particular for miniature electronic devices and equipment. As evident by the ever changing technology creating smaller and smaller electronic devices, the demand for reliable and clean (green Technology) thermally conductive interface pad has increased. You NEED a...

blog.rathena.cn

RO研究手记

第 1 页/共 3 页. 自建 PhpStorm 2016.2 授权验证服务器. 我一直以来都使用 Atom 作为首选的代码编辑器，不过一年过去了，发现 Atom 对 PHP 始终没有很让我满意的插件套装出现也可能是我没仔细寻找。在各种类和函数之间进行跳转很多时候都需要自己 Ctrl F 去查找，没有办法很好的结合 XDebug 进行跟踪调试，这些点点滴滴的细节，让人感觉琐碎、低效。最终，还是萌生使用 IDE 来替换 Atom 的想法 ». 在 CentOS 中快速搭建 VPN 服务器(L2TP). 将 iPhone 的系统升级到 iOS10 之后，系统已经禁止使用 PPTP 类型的 VPN 了，为此我尝试自己搭建 L2TP 类型的 VPN 服务，虽然服务是搭设成功了，但在4G网络下还是会被运营商屏蔽。系统环境 CentOS 6.7 x64 系统镜像的提供商为 ». 绕过 RO 官方 Themida 壳的虚拟机检测. 昆仑由于需要反破解、保护封包混淆密钥，所以使用 Themida 为仙境传说的主程序 Ragexe.exe 进行了加壳处理，并且开启禁止在虚拟机运行的选项。第 1 页/共 3 页.

blog.rathni.com

Kiran Rathni

Wednesday, September 19, 2007. Top n records by type/ category. The title says it all. DECLARE @tmp TABLE(ID INT, Type VARCHAR(10), Name VARCHAR(30), CreatedDate DATETIME). INSERT INTO @tmp(ID, Type, Name, CreatedDate). SELECT 1, 'Car', 'Honda', '1/1/2007'. SELECT 2, 'Car', 'Toyota', '1/2/2007'. SELECT 3, 'Car', 'BMW', '1/3/2007'. SELECT 4, 'Color', 'Red', '1/1/2007'. SELECT 5, 'Color', 'Black', '1/2/2007'. SELECT 6, 'Color', 'White', '1/3/2007'. SELECT 7, 'Model', 'Model1', '1/1/2007'. Type ASC, Name ASC.

blog.rathpetersen.dk

Marina Baie Des Anges Villeneuve-Loubet

blog.rathstrong.com

Rath & Strong Blog

Rath and Strong Blog. Leading Business Process Improvement at Organizations Worldwide. Are Stretch Objectives Harming Your Lean Program? September 18th, 2012 Posted in Lean. There are three steps to engaging leaders in the daily work, whatever the industry:. Make it easy for management to see how the work is performing with visual controls: workplace organisation and performance displays that increase the visibility of problems. This helps you to accomplish the second step:. Establish a system for captur...

blog.ratingbook.de

Das Blog von Ratingbook.de rund um das Empfehlungs-Markting

Springen Sie zum Inhalt. Was ist Ratingbook.de? Laut einer aktuellen Nielsen-Studie vertrauen 65% der Deutschen auf Kundenbewertungen in Onlineportalen. Unternehmen können den Einfluss der digitalen Mundpropaganda nicht länger ignorieren. Wir suchen Referenzunternehmen aus vielen Branchen, um sie im Internet zum Thema Empfehlungsmarketing zu präsentieren. Haben Sie zufriedene Kunden, die bereit sind, sich für Ihr Unternehmen auszusprechen? Alle Informationen erhalten Sie unter www.ratingbook.de. Für klei...

blog.ratio.dk

blog.ratio.dk - Something about technology

Guide to Proper Fifa 10 PC Online Play. On January 10th, 2010 by thomasp – 5 Comments. I present here the problems I’ve run into, trying to get a proper online experience with Fifa 10 PC, as well as the solutions I’ve devised. Trouble connecting to other players. Errors like the other player has disconnected or similar that stops the game before it actually begins. The ports you need to forward are (taken from the manual page 17). UDP: 3658, 3659, 9570. Problem 2: Players quitting the game prematurely.

blog.ratio.net.br

Ratio Management Consulting

Gestão de Compliance em Soluções SAP ( ERP, CRM, SCM…). Dezembro 14th, 2011 Posted in Artigos. Dez, 14 2011. Controle de Acesso e SoD Segregação de Função. Sua empresa conhece o tamanho dos riscos que está sujeita por acessos indevidos no sistema SAP? Controle de acessos e gestão de riscos é cada vez mais importante e preocupação constante de gestores e auditores. Mas qual é a estrutura e o funcionamento das soluções SAP e o que é um sistema de controle interno eficaz e até que ponto os controles ger...