551 reputation
1411
bio website devworx-software.de
location Augsburg, Germany
age 49
visits member for 2 years, 1 month
seen 5 hours ago

Softwaredeveloper and shareholder of http://www.devworx-software.de/

Main interests component development (Delphi), SQL.

Hobbys: sports shooter, diver

proud father of 4 wonderful children

origin Brotkasten C64 Basic PDS assembler Foxpro Delphi 1 - XE3 MS SQL Server, Access

main field of work , developing of customer-specific solutions


Feb
25
awarded  Fanatic
Feb
21
revised How can FLOOR(3) equal 2?
added 316 characters in body
Feb
21
answered How can FLOOR(3) equal 2?
Feb
15
comment LIKE character length limitation
@ dezso sqlfiddle.com/#!6/d41d8/2586, -- commented select will give 1, last select will give 0
Feb
15
comment LIKE character length limitation
to fit the conditions t2 would have to have a productlist with at least the exact same "text" as t1. Similar in order, spacing, content ...
Feb
7
answered how to return table on sql function
Feb
5
answered Can SQL Server Management Studio Express be installed standalone?
Jan
31
answered Total of Same Customer ID from a Single DB Table
Jan
28
comment Could not find stored procedure
sqlserverlearner.com/2011/…
Jan
28
comment Could not find stored procedure
[ACT] is the correct database?
Jan
22
comment How to select row and column name where field is null?
@msi77 sorry, of course, usually you are right Declare @a Varchar(10) Declare @b Varchar(10) Select @a ='Test' SET CONCAT_NULL_YIELDS_NULL OFF Select @a+@b SET CONCAT_NULL_YIELDS_NULL ON Select @a+@b
Jan
21
answered How to select row and column name where field is null?
Jan
18
comment SQL Subquery , One to Multiple rows
Sorry :-( ... I did an edit...
Jan
18
revised SQL Subquery , One to Multiple rows
deleted 3 characters in body
Jan
18
answered SQL Subquery , One to Multiple rows
Jan
16
comment How to select row and column name where field is null?
@msi77 this would be AND not OR
Jan
16
answered How to select row and column name where field is null?
Jan
7
comment How to determine SQL server version install history? I.E. When it was updated last
social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/…
Jan
7
comment Update many-to-many relationship table
What about never deleting and using a structure like: taskmembers (task_ID id, member_id id, active_Since DateTime, active_until DateTime) active members would be (active_until IS NULL) or active_until>GetDate())
Jan
6
awarded  Critic