Viewing 15 posts - 4,426 through 4,440 (of 8,731 total)
An idea:
SELECT DATEDIFF(second,Information.[Start Time],Information.[End Time]) / 60.00 / 60.00,
CEILING( DATEDIFF(second,Information.[Start Time],Information.[End Time])*4 / 60.00 / 60.00) / 4 AS Rounded_Hours,
ROUND( DATEDIFF(second,Information.[Start Time],Information.[End...
August 12, 2015 at 8:25 am
Do you always want to round up? Or why isn't the first result 1.25?
August 12, 2015 at 8:20 am
You're welcome, feel free to ask any questions that you have.
I also created an initial version that lacked versatility and replaced only the first order number. It was like this:...
August 12, 2015 at 7:58 am
Then just follow the process described in here: http://www.sqlservercentral.com/articles/comma+separated+list/71700/
WITH cteOrders AS(
SELECT DISTINCT OrderID
FROM #Status
)
SELECT OrderID,
STUFF((SELECT ',' + Status
...
August 12, 2015 at 7:53 am
Are you missing information? Where do you get the persons that will be assigned? Are those the reviewers?
August 12, 2015 at 7:44 am
Why are you doing that? It will only make your querying more painful. You shouldn't store comma-delimited values in the db.
August 12, 2015 at 7:40 am
Here's a possible option. Be sure to test what it does and understand it.
It basically splits the strings to find the different digit portions by using the PatternSplitCM which can...
August 12, 2015 at 7:01 am
As you might have noticed, BEGIN and END won't define the begin and end of a stored procedure.
A stored procedure must be the only statement in the batch, so anything...
August 11, 2015 at 1:49 pm
A slightly different version of Eirikur's code. This is just to give you more ideas on the different possibilities to solve your problem.
DECLARE @sourcedata TABLE(STR_DATA VARCHAR(100) NOT NULL);
INSERT INTO @sourcedata(STR_DATA)
VALUES
...
August 11, 2015 at 12:25 pm
Sean Lange (8/11/2015)
Luis Cazares (8/11/2015)
WITH RowNums AS(
SELECT *, ROW_NUMBER() OVER(PARTITION BY account ORDER BY date DESC) rn
...
August 11, 2015 at 9:51 am
You can use a code like this:
WITH RowNums AS(
SELECT *, ROW_NUMBER() OVER(PARTITION BY account ORDER BY date DESC) rn
FROM SomeTable
)
SELECT *
FROM RowNums
WHERE...
August 11, 2015 at 9:47 am
Alvin Ramard (8/11/2015)
Ed Wagner (8/11/2015)
Sean Lange (8/11/2015)
Ed Wagner (8/11/2015)
Here's a quote I don't think I've every...
August 11, 2015 at 9:06 am
Normally, Grant's remark should be on point, but here you need to change the column. I added a few other improvements that you might want to implement. Avoid 3 part...
August 11, 2015 at 8:33 am
If this doesn't give a full solution, it might give an idea.
with base as (
select
*,
rn = row_number() over (partition by left(kms_quoteorder,charindex('/',kms_quoteorder +...
August 11, 2015 at 8:28 am
This article explains the FOR XML PATH approach.
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
August 11, 2015 at 7:15 am
Viewing 15 posts - 4,426 through 4,440 (of 8,731 total)