Nilesh-788004 (4/26/2013)

---

I have 2 Stored Procedures Procedure A and Procedure B.

Both Procedures have @year as parameter and if no parameters passed take the current year as an input parameter.

Procedure B...

SQLCrazyCertified (4/26/2013)

---

Sean Lange (4/26/2013)

---

SQLCrazyCertified (4/26/2013)

---

I need to grant a user to select & exec permissions to SP, inline, scalar & table-values functions....but I need this done in every databases. ...

You should be able to add a constraint to WagesEntryNew so that any new data that will be inserted/updated will be subject to meeting the criteria of the constraint.

Something along...

SQLCrazyCertified (4/26/2013)

---

I need to grant a user to select & exec permissions to SP, inline, scalar & table-values functions....but I need this done in every databases. There are 50...

faheemahmad14 (4/26/2013)

---

Actually this issue was asked in an interview of mine and my answers were to use Row_Numbers, Cursors , functions etc . but they forced me to provide...

As you said normalization would be the best approach but you can accomplish with something like this:

create table CPU

(

chip1 int,

chip2 int,

chip3 int,

chip4 int

)

alter table CPU

add constraint CPU_DupeCheck CHECK

(

chip1 <>...

john.p.lantz (4/26/2013)

---

I've done a lot of reading on using WITH NOLOCK and understand the pitfalls. We have a situation where our nightly UPDATE process will get blocked by somebody....

jdbrown239 (4/26/2013)

---

Lynn

You guys were right about the 'Where' clause being the issue. I added a few indexes to the table to increase performance and went back to a suggested 'where'...

You're welcome. Glad that worked for you.

rayh 98086 (4/25/2013)

---

Hi,

I am trying to pull a return a single value from a stored procedure, but cannot seem to find the correct logic.

Can someone share with me help me...

abhas (4/26/2013)

---

Hi,

I want to search student information depending upon the passing either values of firstname,lastname,email. My requirement is even if I entered first 3 characters then the information of student...

jdbrown239 (4/25/2013)

---

Sean

I did read the article but the query involves joins on four tables along with converting XML data. Unfortunately I can't figure out an easy way to provide a...

carsten.crystaldive (4/25/2013)

---

Oh Bollocks, I entered the Break_ID 3 twice in my TestData - sorry ... after Removing the first one the statement returns 1 row only ... obviously with the...

You can do this with a tally table too.

declare @min-2 int = 1, @max-2 int = 100, @NumParts int = 5

select ((N * (@Max - @min-2) / @NumParts) + 1)...

Sorry it took me a bit to get back to this. I am trying to figure out the relationship between these tables and am a bit lost.

You didn't identify how...