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: 26,046   Rating: 3.94/5    Votes: 6   Popularity: 2.96
Licence: The Code Project Open License (CPOL)      Bookmarked: 34   Downloaded: 2,382
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,255   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: 16,066   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: 145,042   Rating: 4.83/5    Votes: 18   Popularity: 6.13
Licence: The Code Project Open License (CPOL)      Bookmarked: 114   Downloaded: 5,714
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,173   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,794   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,835   Rating: 4.50/5    Votes: 4   Popularity: 2.53
Licence: The Code Project Open License (CPOL)      Bookmarked: 18   Downloaded: 1,241
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,611   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,794   Rating: 4.47/5    Votes: 7   Popularity: 3.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   Downloaded: 298
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,728   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,966   Rating: 4.20/5    Votes: 3   Popularity: 2.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 19   Downloaded: 408
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,797   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,114   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,565   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,676   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,442   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,422   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,716   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,541   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,794   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
Web04 | 2.8.141022.2 | Last Updated 24 Oct 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid