2018-11-19
2,669 reads
Recursive CTE
Work time calculation
One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time
2016-09-29 (first published: 2016-09-08)
527 reads
Using a Recursive CTE to Generate a List
Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.
2015-06-26 (first published: 2013-07-09)
28,397 reads
Identify Bad Characters in a Table Column
An interesting recursive CTE to list out the non-alphanumeric characters in a column of a table.
2012-05-08 (first published: 2012-04-12)
2,685 reads
Get month names ordered using recursion
Learn how to pull the month names in a report drop down using a recursive common table expression (CTE).
2012-03-13
10,379 reads
RE: DTS disconnected edit: The system cannot find the file specified
Disconnected edit will check the connections in the package before the dialog opens. You probably have a connection that references a file that can't be found. Maybe a UDL file or something?Why do you need to use disconnected edit? The "Properties" and "Workflow Properties" dialogs for the ActiveXScript task should give you all you need.
2005-05-02
DateTime Conversion
I currently, have a field in a table that is a numeric field = 20030104 - I need to convert this to a date field = 01/04/2003 - what is the proper syntax for use in a select statement?Note that I am creating a table and I tried to change the field type to datetime, […]
2004-11-12
2 reads
RE: SQL getting slower and slower
I second Allen's questions. And yes, the hyperthreading is the reason for the 4 cpu's in task manager.When I first took this job I had a server do the same thing. They were restarting it to get it going again. You probably have a bottleneck somewhere. It could be caused by hitting the knee in […]
2004-02-24
RE: Spilt string into seperate fields
Phill,Some inline views may help simplify it:select Account, Address1 = substring(address, 1, delimpos1-1), Address2 = substring(address, delimpos1+1, delimpos2-delimpos1-1), Address3 = substring(address, delimpos2+1, delimpos3-delimpos2-1), Address4 = substring(address, delimpos3+1, delimpos4-delimpos3-1), Address5 = substring(address, delimpos4+1, address_len-delimpos4) from ( select *, delimpos4=charindex(';', address, delimpos3+1) from ( select *, delimpos3=charindex(';', address, […]
2004-02-23
RE: Syntax problems
Hi Lars,Below is the corrected syntax.declare @UnitWeight as Real,@fVal as Realset @UnitWeight = 1set @fVal=0SELECT @fVal=SUM(isnull(FVALUE,0)) from ITEMSET @UnitWeight = @fVal Pls check it out.Nitin
2004-02-09
Blogs
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers