Something like this?

SELECT cod_rep_fiscal,

COUNT(CASE WHEN cod_met_tributario = 'tp1' THEN cod_met_tributario END) AS tp1,

COUNT(CASE WHEN cod_met_tributario =...

This is specific to XML, it's using the column name as part of the results. There's no data type conversion going on.

You need to provide a name for the column

SELECT ' '+ item AS item FROM #tbl FOR XML PATH('')

This should work for you

CREATE TYPE dbo.HierTVP AS TABLE

(

id int,

childname nvarchar(max),

parentid int,

parentname nvarchar(max)

)

GO

CREATE FUNCTION dbo.GetHier(@parentid INT, @HierTVP dbo.HierTVP READONLY)

RETURNS XML

WITH RETURNS NULL ON NULL INPUT

BEGIN RETURN

(SELECT childname AS...

This may be possible with table valued parameters, can you post a bit more information on what you have.

You'll need a function for this

CREATE FUNCTION dbo.GetHier(@parentid INT)

RETURNS XML

WITH RETURNS NULL ON NULL INPUT

BEGIN RETURN

(SELECT childname AS "@name",

dbo.GetHier(id)

...

Jeff Moden (2/21/2015)

CELKO (2/20/2015)

Here is the formula...

Done a bit of digging here, using a SQLCLR equivalent to the OPs script (source below)

using System;

using System.Data.SqlTypes;

using System.Text;

using System.Security.Cryptography; // Will need a reference to System.Security

public partial class UserDefinedFunctions

{

...

What error are you getting now?

What's your query now?

Change CONVERT to CAST

This should work for you

with cte as (

select ID,STATO,DATEANDTIME,

row_number() over (partition by ID ORDER BY DATEANDTIME) -

row_number() over (partition by ID, STATO ORDER BY DATEANDTIME) as grp

from MYTABLE)

select ID,STATO,DATEANDTIME,

row_number() over...

I posted a QotD about this a while ago

http://www.sqlservercentral.com/questions/T-SQL/74721/

Untested, but may be as simple as changing

group by Product

to

group by LEFT(Product, charindex(' ', Product) - 1)

Try this

AND B.MasterAccount NOT LIKE '%[^0]%'