1,126 reputation
110
bio website valthor.net
location Reykjavik, Iceland
age 36
visits member for 1 year, 9 months
seen 2 days ago

13 years of coding PL/SQL, T/SQL, and managing Oracle and MSSQL servers in enterprise environments. Mostly finance and telco


Dec
17
revised can I use many-to-many relation with weak entity
added 541 characters in body
Dec
17
answered can I use many-to-many relation with weak entity
Dec
4
comment How should I delete branch from adjacency list in SQL Server?
Just added another version of the proc, it goes by the parentNodeId. Should only iterate over the number of levels.
Dec
4
revised How should I delete branch from adjacency list in SQL Server?
added 945 characters in body
Dec
3
answered How should I delete branch from adjacency list in SQL Server?
Oct
14
answered index rebuild/reorganize frequency
Oct
6
answered How to I establish a 1 to 1 relationship
Oct
2
answered Populate one table with data from another one on selected cells
Oct
2
answered capture output of table-valued function
Oct
1
answered Storing file into oracle db
Sep
30
awarded  Explainer
Sep
24
awarded  Autobiographer
Sep
10
awarded  Revival
Jul
9
revised Null Or Multiple Parameters When Querying
added 208 characters in body
Jul
9
comment Null Or Multiple Parameters When Querying
Perhaps I misunderstood the requirements, I thought he was asking for a split function of some sort. But sure, my select statement didn't account for returning all rows for an empty string. I'll update that.
Jul
9
revised Null Or Multiple Parameters When Querying
deleted 32 characters in body
Jul
9
answered Null Or Multiple Parameters When Querying
Jun
17
comment How to reference a table from another schema inside a package?
It's little hard determining the problem based on this information. Perhaps you could post your code here ?
Jun
8
answered Shrink my database log file, make sense?
Jun
5
answered create a stored procedure if it doesnt exist using a ddl in db2