Jeff Moden (10/16/2012)

---

vamsi056 (10/16/2012)

---

Thank you @SSC Rookie i appriciate your explanation..

And rest of you friends give some information which can make discussion to go on to improve knowledge

Thank...

A link to a wiki page to help explain what a crore and a lak is. There are many of us that have...

I have to agree with Rich. I almost got this one wrong because of the wording of the question. When I think of the Seed value, I am...

Duplicate post. Please post any responses here.

ib.naji (10/8/2012)

---

bruce-347665 (10/8/2012)

---

Can I use in a test environment the SQL Developer edition?

To the test development will have access me (the developer) and some users for testing of application...

I haven't been able to quite figure out what it is you want in the end, but the following code traverses your data in the proper order starting at the...

roryp 96873 (10/8/2012)

---

SQLDCH (10/4/2012)

---

Thursday night game, get your lineups in.

This week's match ups:

SSC Steelers (4-0) vs British Bulldogs (1-3) - can the Stillers remain unbeaten?

Select * (2-2) vs Way0utWest (2-2)...

Try running the script using sqlcmd. I have had this same issue with a few rather large scripts. Wouldn't run in SSMS but ran fine when I ran...

Have you checked for any blocking?

Not much we can do with this. Please read the...

Something like this perhaps?

--DDL and some data:

create table Dates (

UserID int not null,

InDate date not null,

Weeks int not null);

insert into Dates (UserID,InDate, Weeks)

select 1,'8/31/2012',5 union

select 2,'9/14/2012',2;

--Expected results:

--UserID,OutDates

--1,9/7/2012

--1,9/14/2012

--1,9/21/2012

--1,9/28/2012

--1,10/5/2012

--2,9/21/2012

--2,9/28/2012

with cteTally(n) as (

select...

Make it easier for others:

https://connect.microsoft.com/SQLServer/feedback/details/764820/support-group-concat-aggregation-function

You will also find a clr string splitter in the discussion thread of Jeff's article linked above in a previous post. IIRC it is based on Adam Machanic's work.

ard5karthick (9/26/2012)

---

Hi Sivaji,

The below procedure must solve your problem...

Use SSISTest

GO

-- Exec SplitStringInsert '1-2,2-3,3-5,4-4,14-14,10-9684'

Alter Procedure SplitStringInsert (@String Varchar(8000))

AS

Begin

Declare @BeginingPosition int;

Declare @TrunPosition int;

Declare @Length int

--Set @String = '1-2,2-3,3-5,4-4,14-14,10-9684'

Set @BeginingPosition = 0

Set @Length...

I'd say you need to expand the size of one or more of your varchar columns. Not sure which but that's where I'd start. My google-fu isn't very...