Hi,

I would suggest using a Tally-table (numbers-table) for this:

-- table definition and data

declare @CallDetailReport table

(

CallStartDateTime datetime,

NodeTraversed nvarchar(MAX)

)

insert into @CallDetailReport (CallStartDateTime, NodeTraversed)

select '2014-09-22 03:44:33', 'Srinivas;vasu;lakshmi;srini;srini'

union all select '2014-09-20 09:42:00',...

fjchairul (9/12/2014)

---

Hi,

I need advise on how to create dummy data from sub table.

1. I have 2 table, 1 is Main Table and another one is Sub Table.

2. I have Full...

Scott In Sydney (7/15/2014)

---

Summary: I need to identify which records are violating a unique index to get the source file fixed.

Details: Apologies, I know this should be simple,...

agbondoc (8/19/2014)

---

Hi everyone,

I have been task to decode a very long Hex string to decimal for further analysis. The output I'm told should be two (2) columns between 2,000...

Not so much information about how you are doing things, it...

Hi,

This code will get the c11 that have the same "m"-attribute as the c10 with the value 19:

-- set up some testdata

declare @xml xml

set @xml = '<row id="10000000" xml:space="preserve">

<c1>Name 1</c1>

<c2>Name...

Hi,

It seems as if TEN.[tncy-sys-ref] is numeric or int?

If you want the result as a char, you probably have to adjust Gilas code by adding another CAST:

CAST(TEN.[tncy-sys-ref] AS CHAR(7 /*...

Thanks Chris,

I was too quick and missed the inner group by, which is the most likely to give the error...

/Markus

Hi Hoseam,

it seems as if the table PR_REB_TAX_RATE can have more than one entry for each EFF_DATE. And at least one of the selected rows in PR_FUND_REBATES has a REBATE_PAID_DATE...

Hi,

I'm not familiar with the XML syntax in SQL Server 2000, but I found this page that contained some information: http://msdn.microsoft.com/en-us/library/aa276847(v=SQL.80).aspx.

I tried a little and came to this (not finished)...

Hi Lance,

It sounds as you want to normalize the data while importing.

Here is an example on how this can be done:

-- Reference table

DECLARE @cities TABLE (

idintIDENTITY(1,1),

namevarchar(50)

)

INSERT INTO @cities (name) VALUES...

Hi hydbadros,

I'm not sure how you would like to calculate the growth from your table, but here is an example of how it can be done, where I have tried...

Hi,

you could do something like this:

DECLARE @Duplicates AS TABLE (idint)

/* Create a list of duplicate ID:s that are to be removed */

INSERT INTO @Duplicates

SELECT ID FROM MESSAGE

WHERE ID NOT IN...

Hi Chris,

I don't know why, but it seems as if the CTE first follow one branch to the top, before following the next, but then all by a sudden all...

Hi,

why don't you want to use DISTINCT or GROUP BY?

/Markus