Is this a blog post or a request for help?

Your splitter is not the most optimal. Take a look at the link in my signature for splitting strings.

That aside...

Not sure about Lynn but my crystal ball is still broken. We can't see your screen, we have no idea how you want to map these columns, we still don't...

Duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1333964-150-1.aspx

Is there a question here?

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...