bitbucket-25253 (2/20/2012)

---

If I understand you correctly, that is take separate DBs supporting different customers. Combine those into one DB, using SCHEMAs to keep each individual customer's data separate. ...

You probably will not get much help here for this. Try posting this on an ASP.NET forum.

What is the time requirement for this data to be updated in DB2? Can you schedule a job to query the view and then hve that job do whatever...

For anyone interested... I made this a bit easier to copy and paste. Hope I didn't delete any characters (except the aliases where they were not referenced).

USE [Version500_Model]

GO

ALTER PROCEDURE...

you can't just remove the XML's. Let's start at understanding what the outcome is supposed to be. Can you give us an example? If I was your boss...

njdevils39 (2/20/2012)

---

GilaMonster (2/20/2012)

---

Then there is something seriously wrong with the XML generation code (which piece I can't tell), it's generated a piece of XML over 2GB in size. I think...

S. Kusen (2/20/2012)

---

Thanks guys! That join was where I had issues,and I really wanted to see where the computer names were different (where NULL that meant I had nothing...

njdevils39 (2/20/2012)

---

GilaMonster (2/20/2012)

---

You have this code towards the bottom

SELECT week_num, work_date, u.unit_description, s.shift_id, sh.shift_description

FROM #GET_ORG_SKED

WHERE work_date =...

AllanP999 (2/20/2012)

---

Perhaps I should have said that I'm trying to prevent sql insertions.

Is a stored procedure with parameters sufficient to prevent all sql insertions? In this instance, is sp_executesql...

Maybe you decided not to read the article posted in earlier posts because you like this forum better. So, here you go. Each user that is set up in...

Is it possible that you are looking for code to set a read only permission for a user or database?

AllanP999 (2/20/2012)

---

Many thanks, I've been looking at options for avoiding sql insert when inserting a new row to a table. I want to use sp_executesql with parameters and wasnt sure...

Matt Miller (#4) (2/20/2012)

---

SQLKnowItAll (2/20/2012)

---

EDIT:...

The question for me is "what benefit to you gain by combining all of these tables into 1 database?" Are they completely different tables and structures, or are they...

Sean Lange (2/20/2012)

---

This is relatively simple but without ddl (create table scripts) and some sample data (insert statements) it is not likely you will get much help. Please provide as...