The stored-procedure tag has no wiki summary.
3
votes
2answers
99 views
Determining if an entity exists in a database via a stored procedure
Here is a short and simple Ajax method that returns "True" or "False" if an entity exists in a database via a stored procedure ...
17
votes
2answers
2k views
Tired of FizzBuzz yet?
There have been many FizzBuzz questions lately, and here is one more! Granted, it is pretty straightforward to do FizzBuzz with SQL using calculations.
So instead, I'm going to do a FizzBuzz which ...
5
votes
1answer
48 views
Dynamically filtering, sorting, and paging using a stored procedure
Is there a better way (I'm pretty sure there is) to create a stored procedure to do dynamic paging, filtering and sorting than the following code?
...
2
votes
1answer
45 views
3
votes
2answers
270 views
Implementing repository pattern and DAL with stored procedures
Using .net 3.5, implementation of the repository pattern along with enterprise library 5 and stored procedures. Did not use EF, stored procedures already available and VS2008 is limited to EF 3/4.
...
1
vote
1answer
141 views
Stored Procedure calculating employee earnings
I have following stored procedure in a C# win forms application which calculates employee earnings based on attendance as follows.
Note that a shift is 12 hours and employees mark attendance for in ...
2
votes
1answer
43 views
Execute edit in a stored procedure based on database value
I have code below which is set to check the date of DateToComplete, and if the date is 2 weeks or more ago, change the status of Complete from 3 to 2.
Is this the ...
5
votes
2answers
53 views
Update column based on input variable in stored procedure
The purpose of the below code is to update a column based on the name of the field name sent from the .NET code. This allows one piece of code to handle multiple rows when a user is only ...
