2013-01-14
8,004 reads
Process synchronization
RE: Compare Text Fields
WHERE ISNULL(SUBSTRING(a.TexrCol,DATALENGTH(a.TextCol)),'~~Null~~') = ISNULL(SUBSTRING(b.TextCol,DATALENGTH(b.TextCol)),'~~Null~~')
2004-01-06
1 reads
Join Help
Hi,I've seen something like this here before and have been unable to dig it up.I need to be able to do the following to cull down duplicates in F1 to a single row that has the minimum value of F2. F1 and F2 are varcharsF1,F2A,AA,BA,CB,1B,2B,3Result needs to look likeF1,F2A,AB,1This site has been a great help!-Mike
2004-01-06
2 reads
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