2016-12-15
1,341 reads
2016-12-15
1,341 reads
An inline table valued function (iTVF) that can be used to calculate age in years.
2016-04-27 (first published: 2016-04-06)
999 reads
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
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
please help ' log shipping restore alert out of sync'
2004-12-06
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-10-04
2004-07-15
1 reads
Good J..P..Sometimes I have implemented something like this:SELECT ServerName, Environment, ServerRole FROM V_ServerDetail WHERE ServerName = ISNULL( @ServerName, ServerName ) ORDER BY ServerNameBut your solution is better since it works for NULL columns /rockmoose
2004-07-15
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers