PatReplace8K
This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.
2017-03-24 (first published: 2015-05-16)
2,008 reads
Table Valued Function (TVF)
Calculate gregorian easter sunday using a table valued function
Calculate gregorian easter sunday using a table valued function.
2014-09-03 (first published: 2014-08-22)
669 reads
Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions
While perusing some of the threads on SQLServerCentral.com one of the questions that hit me was regarding the use of scalar functions in queries. In this particular case, in the column list of a SELECT statement. Did it make sense to encapsulate a routine...
2009-05-12
1,958 reads
UDF to return a multi column table of values from an input string
This UDF returns a multi column table of values from an input string of comma separated values
2008-06-11 (first published: 2008-04-29)
1,339 reads
Get Modified Objects As on Date
This table Valued Function return the Modified Objects (SP /Views) For the Date specified.
2011-10-07 (first published: 2007-11-23)
1,364 reads
Table-valued function FTParsedINT
This tabled valued function can be used to parse a comma seperated list of IDs so you can pass a parameter to use in a in clause without having to use dynamic SQL.
2007-11-22 (first published: 2007-10-04)
875 reads
RE: excluding fields in my SELECT from the GROUP BY clause
HelloReplie for Antares686 as requested : NdocNmdocCodigoQtPvValorValor_custoDescMargemComissão1Factura 20180ANB-1 12568,3510487,67787,20+0 25,74861Factura 20180ANB-2 24008,3520040148800+0 25,74861Factura 22520ANB-1 15008,25123758572,54950+0 30,72691Factura 22520ANB-2 15008,251237585800+0 30,66671Factura 24020ANB-1 25005125008581,85250+0 31,34521Factura 24020ANB-1 31005,51705010641,49710+0 37,58661Factura 24040ANB-1 13008104006290,67010+0 39,51281Factura 24040ANB-2 12008960061200+0 36,251Factura 24040ANB-3 860868804162,40+0 39,51Factura 24040ANB-4 150081200076500+0 36,251Factura 24520ANB01-04 310061860011791,07010+0 36,60721Factura 27640ANB-1 420625201377,60+0 45,33341Factura 27640ANB-2 1290677404231,20+0 45,33341Factura 27670ANB-1 32006192009123,92960+0 52,47961Factura 27670ANB-2 22006132007026,55140+0 46,76861Factura 27670ANB-2 24006144007665,32880+0 46,76861Factura 27730ANB-1 10805,4583231860+0 45,37041Factura 27730ANB-2 8205,4442824190+0 45,37041Factura PRV108-1 351072457018145,310040+0 26,14861Factura PRV108-2 48007,937920278880+0 26,45571Factura PRV108-3 70007,95530041006,8820+0 25,84664Nota de Crédito NSINDEMNIZ 112000-12000-0,652870+0 0-4804Nota de Crédito NSRAPPEL 141217,49-41217,4900+0 0-1648,69960 0000 0029 4693853362,79274200,11217126,3883 775,8179-2128,6996that is the result , but i need the result like this :for this Client i need only one line with the SUM of "Valor" ; "Valor_custo";"Comissões"and "Margem" , where "Valor" as Sails;"Valor_custo" as Cost; "comissões" as comissions and "margem" as benefits.I hope you understand better […]
2005-01-11
DROP on a culumn with constraint
The culumn from_core was created by a program that execute this code:ALTER TABLE WebRsLog ADD [from_core][bit] NOT NULL DEFAULT 1Now I need to drop this column. Using the code:ALTER TABLE WebRsLog DROP COLUMN [from_core]I get the error:The object 'DF__WebRsLog__from_c__7C86175C' is dependent on column 'from_core'.So, I need to drop the constraint first. A problem - the name […]
2004-10-11
3 reads
2004-09-28
2004-07-15
1 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