Ed Wagner (5/30/2013)

---

I just type the CREATE VIEW statement (and all the other DDL statements) myself, so I admit I'm not too familiar with the wizards that may be available....

Here are a couple of other ways to get the same results. One uses a cte and the second instead uses a cross apply.

--CTE Version

with GrandTotal as

(

SELECT SUM(Amount) as GrandTotalDesired,...

Which they promptly did and then removed...

Great job posting ddl and sample data. I can understand GrandTotalDesired and Payments. However, what is the logic for GrandTotal Obtained? Can you explain what that column contains?

Below is one way to do this. Please take note of how I posted readily consumable sample data and ddl. This is something you should do when posting. Also, you...

Agreed. I used to do some consulting for a company that administered health insurance. At...

Not sure what you mean. Are you using a wizard or something to create...

m.rajesh.uk (5/30/2013)

---

I need a script to list all columns which is having not null constraint on it.

the script i have is..

USE [R]

GO

SELECT t.name AS table_name,

SCHEMA_NAME(schema_id) AS schema_name,

c.name AS column_name

FROM...

RedBirdOBX (5/30/2013)

---

OK. I have the most basic of queries and SSMS is barking at me. I created this as a View in SSMS.

SELECT ...

progers-677549 (5/29/2013)

---

I can understand what you are saying. My issue is, that I don't need the print statement at all and it truly isn't part of the actual code,...

I don't think that is going to work. There may be somebody out there that has...

progers-677549 (5/29/2013)

---

Thanks for the reply, I really appreciate it.

What I'm trying to say is that in the code snippet provided, the Update statement will not get executed unless I uncomment...

It is the answer.

prtk.raval (5/29/2013)

---

I can not post the code,because I am developing it from this http://www.sqlservercentral.com/articles/EDW/77100/ article.

in this article author has used tables from same database.

In my case, one table is under...

Hi and welcome to the forums. Unfortunately your description of things like "doesn't seem to work" does not really provide any kind of details. We can only see a portion...