Parsing INTERNAL REPRESENTATION OF OVERPUNCH SIGNS
Some times you need to parse over punch values at the while running a query.
Here is an utility function to help with that task.
2018-11-07 (first published: 2018-10-31)
369 reads
Parsing
URI Parser: A set of 20 CLR functions for URI parsing
A set of 20 functions for URI and URL parsing, using .NET's native System.Uri parser
2011-07-21
1,395 reads
Using XML to pass and return values to procs
Tips on parsing and sculpting XML from within a SQL 2005 stored procedure
2009-10-19
10,258 reads
RE: More Visas
Fred, Do you mean to tell me that out of 296,035,593 Americans corporations cannot find a handful of suited IT professions? I agree with you on point, I have met and worked with many foreign IT workers who have amazing programming skills. However, you wouldn't replace your son, little Jimmy, in a track competition with the […]
2005-05-04
RE: Table variable stored procedure output
Now that I have tried to use a UDF that returns a table variable, I hit this wall: "Only functions and extended stored procedures can be executed from within a function." Inside of this what was originally to be a stored procedure, I dynamically need to execute DML's inside using sp_executesql <String variable>. Well this […]
2003-08-08
RE: 4 hour plus query
First off based on quote: UserDate (userId, latestDate) should this line quote: join UserDate D on D.userId = A.userId and D.date = A.date actually be join UserDate D on D.userId = A.userId and D.latestDate = A.date and if so then why not just do SELECT I.* FROM UserActivity A INNER JOIN UserImpression I ON A.userId= […]
2003-06-25
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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