Looking closer at your issue it seems you need a running total. Take a look at this article. http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D

It is a great article and a must read on the topic.

Hi and welcome to SSC. We are willing and able to help but first you have to provide enough information for somebody to be able to help. You need to...

That will work but it seems a lot easier to have the developers install SQL on their local. Then they can connect to the sql server from their own desktop....

Daxesh Patel (7/23/2012)

---

Sean Lange (7/22/2012)

---

That is a super easy way to find foreign keys...

pujain (7/23/2012)

---

thanks for your reply,

let me ask in a different way.

suppose all three express/standard/developer fits application requirment

and we developed a application which keeps/calculate salary records of all the employee...

What Anthony is saying that is that we can't really help you because what you posted is not a complete question. We need ddl (create table statement), sample data (insert...

pujain (7/23/2012)

---

we were using a tool called MAGIC for payroll, its a very old tool and the DB has become big now,

the vendore has now upgraded the tool so that...

What does the vendor requirements say? There is no chance anybody here can answer that question. We don't know what this 3rd party system you are buying does.

Maybe they like...

If you want/need a more detailed response you will need to provide a more detailed post. Take a look at the first link in my signature about best practices when...

deepzzzz (7/23/2012)

---

SELECT f.name AS ForeignKey,

SCHEMA_NAME(f.SCHEMA_ID) SchemaName,

OBJECT_NAME(f.parent_object_id) AS TableName,

COL_NAME(fc.parent_object_id,fc.parent_column_id) AS ColumnName,

SCHEMA_NAME(o.SCHEMA_ID) ReferenceSchemaName,

OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,

COL_NAME(fc.referenced_object_id,fc.referenced_column_id) AS ReferenceColumnName

FROM sys.foreign_keys AS f

INNER JOIN sys.foreign_key_columns AS fc ON f.OBJECT_ID = fc.constraint_object_id

INNER JOIN sys.objects AS...

That is a super easy way to find foreign keys defined on the current...

Or to provide you the answer with as much detail as you provided. this is actually quite simple.

Download the wsdl for the webservice you want to call.

Build the wrapper around...

You failed to actually ask a question that can be answered. You did not provide anywhere near enough information. The only possible responses are people wondering why you are asking...

Sure they do. Just like Bigfoot and the Loch Ness Monster. 😀