Understand, you don't need to index the computed column if you follow the example...

sivag (7/24/2012)

---

no

Lynn Pettis plz dont think like that i just given all the table u asked about mapping and i...

sivag (7/24/2012)

---

i just solved that function problem any way thanks a lot

ALTER FUNCTION [dbo].[Split1](

@delimited VARCHAR(MAX),

...

Here is something to start working with to solve your problem.

Read this article, http://www.sqlservercentral.com/articles/T-SQL/71550/, for more insight in to what is happening.

declare @Range table(

[StartRange] int,

...

Looks like I got beat to this, but I'll post what I did any ways.

declare @Dates table(

[Row] int NOT NULL,

[OrgID] varchar(50) NOT...

sivag,

Okay, you aren't getting the answers you want here so you start another thread basically looking for the same thing?

You wouldn't need to do this if you would just provide...

Yes, you can create an index on a computed column. In addition, if you are selecting a specific year you can also use the the following on the specific...

leon2486 (7/23/2012)

---

Hi there,

My name is Leo, i am a junior DBA in my company. Nice to meet you all in this forum. 🙂

i have a problem with SQL Server mirroring...

I would install the service pack before setting up the mirror.

Okay, now modify the rCTE to run against this dataset. It will contain 1,000,000 rows of data and potentially 10,000 unique cID's, not 1 (cID = 123) as in...

If you mean something like this:

DECLARE @tblInput TABLE

( table_id INT,

field_id INT,

sequence_id INT,

value CHAR(1) );

/* STEP 1: Populate the Input table */

INSERT INTO @tblInput

( table_id, field_id,...

Okay, sorry....

adams.squared (7/23/2012)

---

The below script returns this data set.

RowOrgID StartDateEndDate

11219042/4/20086/1/2008

21219048/21/20081/1/2010

31219048/14/20096/30/2010

41219046/30/20106/30/2011

51219048/10/20119/1/2012

61219049/21/20119/21/2012

What I am trying to do is merge the rows where the dates are continuous....

Yes, you will need to install the most recent service pack, or in this case, you would install service pack 4.

We have been telling you what we need. we the DDL (the CREATE TABLE statements) for you source...