543 reputation
1311
bio website devworx.de
location Augsburg, Germany
age 49
visits member for 1 year, 11 months
seen 15 hours ago

Softwaredeveloper and shareholder of www.devworx.de.

Main interests component development (Delphi), SQL.

Hobbys: sports shooter, diver


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?
Dec
24
answered New login is created but 'sa' cant assign grant/deny permissions to user in SQL Server 2008 R2?