dwain.c (8/6/2012)

---

SomewhereSomehow (8/3/2012)

---

When you asking about alternate solution you, do mean funtctional equivalent? you may use case+group by instead of pivot, and cross apply instead of unpivot. You may also...

Using Pivot/unpivot could be more than just a matter of choice. You can definitely avoid the Pivot with Case+Group but then you come across situations where you can't use Case+Group....

How about this Cadavre???.....

Declare @num bigint

Set @num = 12345678

Select @num As Number, Stuff((select Left(Right(Cast(@num As Varchar(10)), n), 1) From Tally

Where n <= Len(Cast(@num As Varchar(10))) For XML Path('')), 1,...

GilaMonster (7/30/2012)

---

vinu512 (7/30/2012)

---

GilaMonster (7/30/2012)

---

Try adding this as a column, and see if it orders 'correctly'. If so, try select into and see if it's still ordered 'correctly'

ROW_NUMBER() OVER (ORDER BY...

GilaMonster (7/30/2012)

---

Try adding this as a column, and see if it orders 'correctly'. If so, try select into and see if it's still ordered 'correctly'

ROW_NUMBER() OVER (ORDER BY (SELECT 1))...

danielfountain (7/30/2012)

---

Now here is the problem - i need to have a row_number added to this query, so i can transfer this order to a new table (i am going...

Jeff Moden (7/25/2012)

---

Look at the execution plan for that, Vinu. There are 9 rows in one table and 4 in the other....

I think this is the simplest way.

You're Welcome Micheal.

I'm glad it worked for you. 🙂

This should work for you:

Select b.* From #Version As a JOIN #TransactionDetail As b ON a.VersionName = b.VersionID And IsActive = 1

Where (PARSENAME(b.PERIOD, 1) >= PARSENAME(a.StartMonth, 1) )

And (PARSENAME(b.PERIOD, 1)...

So...how if every restore will cause this problem then how can this be handled....like is there a hint or something which can be specified with the restore statement to avoid...

There...that would do it...Clayman beat me to it again. 🙂

You need to Group the data. You need to change the Dynamic Pivot Query as follows:

DECLARE @info-2 nvarchar(max)

DECLARE @sql nvarchar(max)

--Added Variable

DECLARE @Info1 nvarchar(max)

select @info-2 = STUFF(

( select ','+TempSymbol from #TempSymbolList...

Stuff is good. 🙂

This is just another alternative:

Declare @string varchar(10) = 'B9876543'

Select (LEFT(@string, 3) + '.' + RIGHT(@string, (Len(@String) - 3)))

You can avoid the CTE and use a Derived table as well as follows:

Select branch, Sum(Case When rn <= 1 Then 1 Else 0 End) As Count From

(Select *, (Case...