This query would be a heck of a lot simpler - and probably much faster - if all those repetitive correlated subqueries were replaced by derived tables:

SELECT No,nome, SUM(Saldo)...

C#

You'll be oblivious, Bob Hovious, that's...

Gaby Abed (3/16/2009)

---

"In...

Once you've noted the server & column collations, you can take care of your collation conflict by following this example:

DROP TABLE CollationTest1

CREATE TABLE [dbo].[CollationTest1](

[CT1ID] [int] IDENTITY(1,1) NOT NULL,

[CT1] [varchar](30) COLLATE...

A published article such as this will explain your problem far better than a single post in the forums section....

There's an excellent article by Steve Jones here[/url] which describes the cause and the solution to your problem. If you're still unsure after reading the article, then repost for additional...

Blimey - now ain't that a triumph of quantity over...

foxjazz (3/13/2009)

---

Why couldn't they write t-sql more like C# or have a flavored compiler for t-sql so that we could work it like c# or vb depending on how you...

This could be a different issue...

Not really - he's prone to letting his enthusiasm get the better of him, but he's willing to learn and accepts corrections from others...

Steve Jones - Editor (3/13/2009)

---

So do we teach people here? Or push them to get better? Or push them away and say you're not qualified" and you need to go...

Ninja's_RGR'us (3/13/2009)

---

When you post a reply, there's a button with a green round icon and a link chain. That button posts up a javascript window to input the url...

Here's a quick and dirty method for getting the content of a single sproc into a table, line by line:

IF OBJECT_ID('tempdb..#ProcedureLines') IS NOT NULL

DROP TABLE #ProcedureLines

CREATE TABLE #ProcedureLines (RowID INT...

Michael Valentine Jones (3/11/2009)

---

The code below is the standard way to get a date without the time in SQL Server.

Extensive testing (by me and many others) has shown that...