Construct a comma delimited list from table column with SQL(objectreference.net)

submitted by magz(80) 3 years, 4 months ago

How many times have you had to create a comma delimited list from a table column? Do you ever remember how to do it? I don’t. Here is a little snippet I find useful read more...

add a comment |category: Database |Views: 321

tags: Database another

RegEx Multiple Matches with Lookahead Assertion(objectreference.net)

submitted by Vort3X(1335) 3 years, 5 months ago

This is a quick article where I would like to show how to use regular expression to get all matches of a particular pattern from the string. read more...

add a comment |category: C# |Views: 236

tags: C# another

SQL Find last week date range(objectreference.net)

submitted by Vort3X(1335) 3 years, 6 months ago

The other day we needed to write a report on online sales for the last week. SQL doesn’t offer developers many predefined functions to work with date ranges unlike the C# programming language. Here is a little example how to query SQL for some data between the dates for the last week. read more...

add a comment |category: Database |Views: 445

tags: SQL Database another