Click here to Skip to main content

Articles by db_developer (Articles: 11, Tip/Tricks: 9)

Articles: 11, Tip/Tricks: 9

RSS Feed

Average article rating: 3.90

Grid & Data Controls
DataSets, DataGrids etc
Posted: 23 Sep 2009   Updated: 23 Sep 2009   Views: 25,637   Rating: 3.94/5    Votes: 6   Popularity: 2.96
Licence: The Code Project Open License (CPOL)      Bookmarked: 34   Downloaded: 2,321
An approach to create a master-details grid and to show the parent column in the child table.
Database
OLE DB
Posted: 17 Mar 2011   Updated: 17 Mar 2011   Views: 8,147   Rating: 1.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
OLE DB Provider pack all query to single line, thus all query text after comment clause will be truncated
SQL
Posted: 30 Sep 2010   Updated: 30 Sep 2010   Views: 15,931   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
This article describes how modern industrial RDBMSs solve hierarchy building task, by the way SyBASE ASE and Microsoft SQL Server SQL are compared
SQL Server
Posted: 11 Oct 2009   Updated: 11 Oct 2009   Views: 142,244   Rating: 4.83/5    Votes: 18   Popularity: 6.13
Licence: The Code Project Open License (CPOL)      Bookmarked: 112   Downloaded: 5,620
describes how to create SQL Wrapper for Regular Expressions using SQL Server CLR Integration
Utilities
Posted: 25 Dec 2009   Updated: 25 Dec 2009   Views: 7,122   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Establishing of an existent connection to SQL Server with a sample: XML/A script execution tracing.
SQL Reporting Services
General
Posted: 19 Nov 2009   Updated: 19 Nov 2009   Views: 9,698   Rating: 4.17/5    Votes: 3   Popularity: 1.99
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
MDX. Threshold sum. Approach to order by one thing and accumulate another.
Posted: 13 Nov 2009   Updated: 1 Dec 2009   Views: 17,711   Rating: 4.50/5    Votes: 4   Popularity: 2.53
Licence: The Code Project Open License (CPOL)      Bookmarked: 17   Downloaded: 1,240
MDX query for Get last valid value for measure before the date and then calculate all values that contribute to this value till given date. ADOMD.Net. MDX usage in C#.
C#
General
Posted: 31 Jan 2010   Updated: 31 Jan 2010   Views: 10,542   Rating: 3.63/5    Votes: 9   Popularity: 3.46
Licence: The Code Project Open License (CPOL)      Bookmarked: 14   Downloaded: 0
What is the difference between 'throw e' and just 'throw'
Macros and Add-ins
Add-ins/Plug-ins
Posted: 24 Dec 2009   Updated: 20 Jan 2010   Views: 18,604   Rating: 4.47/5    Votes: 7   Popularity: 3.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   Downloaded: 294
Visual Studio Integration Package Menu command. Find Item by using a Regular Expression in Solution Explorer window.
Usability
Design
Posted: 20 Feb 2010   Updated: 20 Feb 2010   Views: 8,638   Rating: 4.29/5    Votes: 5   Popularity: 3.03
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   Downloaded: 0
Guidelines that must be kept in mind while you are designing and implementing dialog boxes
Design and Architecture
Frameworks
Posted: 23 Sep 2009   Updated: 23 Sep 2009   Views: 11,897   Rating: 4.20/5    Votes: 3   Popularity: 2.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 19   Downloaded: 404
This article consists of a data layer and forms for database tables editing.
No blogs have been submitted.

Average tips rating: 4.28

Database
General
Posted: 6 Nov 2010   Updated: 13 Nov 2010   Views: 15,527   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Allows to set default mailing global profile with aid of T-SQL
Posted: 1 Sep 2011   Updated: 1 Sep 2011   Views: 1,090   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
----First Day of Current QuarterSELECT DATEADD(qq,DATEDIFF(qq,0,GETDATE()),0) 'First Day of Current Quarter'
Posted: 1 Sep 2011   Updated: 1 Sep 2011   Views: 1,507   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
IF OBJECT_ID (N'dbo.GetIntervalStartDate', N'FN') IS NOT NULL DROP FUNCTION dbo.GetIntervalStartDate;GO--gets first day of interval date belongs toCREATE FUNCTION dbo.GetIntervalStartDate (@Date datetime,@IntervalType int = 0--0 - DAY, 1 - WEEK (Mon to Sun), 2 - MONTH, 3 -...
Posted: 14 May 2010   Updated: 3 Jan 2014   Views: 20,384   Rating: 4.67/5    Votes: 10   Popularity: 4.71
Licence: The Code Project Open License (CPOL)      Bookmarked: 14   Downloaded: 0
Reminder.Sou...
SQL Reporting Services
General
Posted: 11 May 2010   Updated: 11 May 2010   Views: 4,389   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
There is no way to show hierarchy level in one dimension of one cube and to hide that hierarchy level in the same dimension (role-played dimension) of the same or other cube. Solution is to add additional hierarchy without levels to hide to this dimension.For example,There is dimension...
XML
General
Posted: 27 Nov 2009   Updated: 27 Nov 2009   Views: 12,258   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
xmlns is special attribute. It determines namespace of current element and its children all as well. You do not have to add it to XmlDocument (XmlElement) explicitly. Use method of XmlDocument:public virtual XmlElement CreateElement( string prefix, string localName, string...
Posted: 26 Nov 2009   Updated: 27 Nov 2009   Views: 11,521   Rating: 2.75/5    Votes: 3   Popularity: 1.31
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
I was thinking that it is a simple task "select nodes using XPath expression and then to delete them from XML Document", but after I spent a couple of hours ... My fault was I searched for something likes 'Remove current node', 'Delete active node', 'Detach node from tree', etc.Way to delete...
Programming Tips
General
Posted: 5 Jun 2010   Updated: 5 Jun 2010   Views: 9,371   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Split User Defined Function, MS SQL Server 2008
Posted: 17 Jan 2012   Updated: 17 Jan 2012   Views: 13,615   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
ISO Week
No reference articles have been posted.

db_developer
Database Developer Freelancer
Ukraine Ukraine
MS SQL Server Database Developer with 7+ years experience
 
Technologies/languages: Business Intelligence, SQL, MDX, VBA, SQL Server, Analysis Services (SSAS), Reporting services (SSRS), Integration Services (SSIS), DataWarehouse.
Also: economic background.
 
Feel free to contact me for rates and details.


Advertise | Privacy | Mobile
Web01 | 2.8.140926.1 | Last Updated 1 Oct 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid