sqldba20 (11/16/2012)

---

Let's say somebody adds a new record in the Details table (#tblSDetails) with new Sub-Folder

insert into #tblSDetails values ('Invoice_Archive','CSS','Location','Action','Read')

OR

Updates the Access column from Read to Modify where FolderName =...

As previously stated the type of splitter you have is very slow and if at all possible replace that denormalized table with something easier to work with. You can parse...

sqldba20 (11/16/2012)

---

Mismatch meaning sometimes it is possible that in the Details table (#tblSDetails) the Subfolder might not exists or it maybe also possible that the data under Access column for...

No offense but that link is horrible. The script there is strangely complex and doesn't actually return correct results. It is not too far off but it is wrong. The...

Great job posting ddl and sample data!!! Unfortunately your question is very unclear. What does a mismatch mean? Is it possible to normalize this stuff and add something that can...

SQLTestUser (11/16/2012)

---

i have a view that references three tables and i want to update the table when someone updates the value in the view is that even possible

tables as

Location

Customer

Books

the view...

Of course I didn't actually test it but since the issue was with a deprecated type I made the assumption....which certainly made one out of me. 😉

It does appear to...

That is an interesting script. The easiest way to avoid the collision is to stop using the deprecated text datatype. Use (n)varchar(max) instead.

Jerome,

I borrowed heavily from the article Lynn Pettis wrote on dates. http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D Read...

Yes the alternative is what I showed you. You should be able...

Reading your post again it sounds like you want to make copies of a survey? You could use the same logic I posted above but it would all be within...

Assuming my understanding posted above is correct here is an example of doing this type of thing without using a cursor. What you have to do is add a column...

Jeff Moden (11/15/2012)

---

I guess I don't get this. Why would the ParentID of question 1 be "7" when it looks like question 7 is the identical question with no...

This doesn't sound too bad but there is really nothing anybody can do to help based on the limited details you have posted. Are you looking for specific query assistance...

A while loop is no better than a cursor for performance....