mcx5000 (4/22/2014)

---

with SampleData (PERSON, [DATE], [HOURS], [DOW]) as

(

SELECT 1234,'03/31/2014','8.00','Monday'

UNION ALL SELECT 1234,'04/01/2014','8.00','Tuesday'

UNION ALL SELECT 1234,'04/02/2014','9.00','Wednesday'

...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

You definitely don't need a loop for this. You can do this using a tally or a calendar table (not totally sure which one fits best). In order to...

If you use the looping method posted you could change the condition of the where to use some date math so it will stop running by 5pm as you requested.

while...

Yes you probably need to use a convert in your date portion of that case expression.

http://msdn.microsoft.com/en-us/library/ms187928.aspx

Honestly I think you should hire a consultant to help you design your system. There are items in your list that contradict each other and many that sound as though...

praveen_vejandla (4/21/2014)

---

Hi,

A stored procedure may have multiple lines of T-SQL code and one single line of SQL could be taking long time.

Is there any way to identify the starting time...

hardik.panchal (4/21/2014)

---

Try it out below query, You can add more conditions as per your requirement

;WITH Sales AS

(

SELECT CostsAllocated ,

CAST(MONTH(BillDate)AS VARCHAR) +'-' +CAST (YEAR(BillDate)AS VARCHAR) AS BillDate

FROM AcFeesHistory...

Glad that you found a solution. It would be nice to know what the actual issue was and what you did to solve it.

johnnycash (4/18/2014)

---

Hello to all SQL gurus here.

I have a contracts table with primary key and an Items table referencing the contract table. The Items table has a PK as well....

DDL, sample data and desired output would go a long way to getting you an answer. It is not at all clear what you mean by putting an outer apply...

Take a look at this article. http://www.sqlservercentral.com/articles/comma+separated+list/71700/%5B/url%5D

duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1563159-3077-1.aspx

DiabloZA (4/18/2014)

---

Hi Sean,

I know it's confusing, I will attempt to explain this as detailed as possible, so on daily basis up to 8 hours are going into REG hours bucket,...

mario17 (4/18/2014)

---

Hi, ALL

I Just checking a newly deisgned db at my new place, AND see there is NO FK contraints EXISTS FOR many tables, so

you can enter:

INSERT INTO tProdValues...