Very nice. It really is easy to do and now your code is much more flexible. No worries about learning sql, it is a daily learning experience for me as...

learning_sql (2/14/2013)

---

I will look at it, it will certainly make the solution more comprehensive.

The triggers I created update the tables perfectly considering they will only be executed by users selecting/deselecting...

I had to look it up myself. 😉

Your triggers assume there is ever only 1 row being updated. You need to change the logic here to be set based using the inserted and deleted tables.

Something like this:

CREATE...

I know I am missing something. Your cte is nothing more than a select from a table. Now you want to update the table to have the same value?

farooq.hbs (2/14/2013)

---

Thanks for the reply.

I used calendar month table, but it returning two or three rows for one name project because some 2 or 3 phase are present in the...

Change...

This is entirely too vague. Can you post ddl and sample data? I think you need to use a calendar table and then a cross tab but from what you...

The original thread is here. http://www.sqlservercentral.com/Forums/Topic1419969-392-1.aspx

Check out the links in my signature about cross tabs. It explores how to do this with a fixed number of columns and the second article explorers doing this with...

sqlbi.vvamsi (2/13/2013)

---

perhaps this might help:

declare @tbl table (id int,string varchar(512))

Insert into @tbl

SELECT 123,

...

Tara D (2/13/2013)

---

I have a table that has

ID Name

123 12345-abcd, 6789-efgh

456 R11223344-abc, 223366-rreett, A45566-ppooit

I...

dcyoung (2/13/2013)

---

I have contractors that write Stored Procedures and users that run them as part of applications. I don't want to grant either of the groups dbowner to the primary...

Part of the issue may be using ISNUMERIC. This function is barely passable as a validation or filtering tool. Take the fine example that Steve posted and add 1 more...

ahpitre (2/13/2013)

---

How do you use this function? Also, how can I pass an additional parameter, so it's always inserted into the new table? I have a column named Part. I...