Ramesh (1/16/2009)

---

Though the solution provided will give the correct results, but will not perform very well on large amount of rows. You should be careful while using CROSS JOIN...

Santhosh (1/16/2009)

---

Abhijit More (1/16/2009)

---

Hi Abhijith, thank you for the reply

This worked fine without the SUM function

SELECT tmp.PojID, tmp.Cat,

------------------SUM removed

(Case when tmp.PojID = tmpPoj.PojID AND tmpPoj.Cat = tmp.Cat THEN Total...

Try this:

GROUP BY Period, SumCol4, SumCol5, SumCol6, SumCol7 WITH ROLLUP

Hope it will work!

Also I asked this question... and don't forget that now we have available the SQL Server 2008! ...vs Oracle 11g!

As I search in the Internet both technologies are very nice...

Hehe for a long time I have this information my friend, everyday I'm using...

Ok Jeff there is the simple code from me...so your code is in advanced level 😛

SELECT

SUBSTRING(Y,3,1) AS Y -- this retrieve allways the second value...

Nothing at all...for...

I don't know what is your experience with MS Access...but if you...

Once again the famous Jeff's table Tally table working wonderfull!

:w00t::cool::w00t:

Super solution Jeff!

I didn't read in deep for the Resource DB, I just was wondering why the other Sys DBs are available for BCK and RDB is not ! Anyway thnx my...

Till we are discussing for the System DBs, also the Master DB is very important and I'm sure that it is much...

Jack Corbett (1/10/2009)

---

I second everything that Jerry said. Anytime you are making changes to your SQL Server you should backup everything. Don't forget the resource database as well....

...finally try this where you can find more info!

SQL Server Migration Assistant for Oracle (SSMA for Oracle)

Version 4.0

http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx

😉

Sure that you can do it with SSIS, but if you have new versions like Oracle 9i or 10g or 11g yes you can do ti without anyproblem! Anyway with...

Michael Earl (1/9/2009)

---

Sure, but try this:

[font="Courier New"]CREATE TABLE MyTable (ID INT)

GO

CREATE CLUSTERED INDEX idxMyTable_CL_ID ON MyTable(ID)

GO

CREATE NONCLUSTERED INDEX idxMyTable_ID ON MyTable(ID)

GO

SELECT c.name, b.name

FROM sys.tables b

INNER JOIN sys.schemas c...