543 reputation
1411
bio website devworx-software.de
location Augsburg, Germany
age 49
visits member for 2 years
seen Nov 20 at 9:36

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


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
Dec
29
answered Max connections SQL Server Express could have?
Dec
29
comment Max connections SQL Server Express could have?
Last edition with limitation in concurrent users was Server 2000 msdn.microsoft.com/en-us/library/ms165672%28SQL.90%29.aspx
Dec
28
comment How much do foreign keys affect performance?
stackoverflow.com/questions/507179/…
Dec
27
answered How to login in database if we have lost password?
Dec
25
awarded  Commentator
Dec
25
comment Pivot a table to repeat the first column for each following column
You can find examples here ewbi.blogs.com/develops/2005/01/access_sql_tran.html msdn.microsoft.com/en-us/library/office/… but if I got you right you are searching for the opposite.
Dec
25
answered Pivot a table to repeat the first column for each following column
Dec
24
comment Sql server update query locking stages?
@ThomasStringer why didn't you post this as answer?