Viewing 15 posts - 4,636 through 4,650 (of 5,504 total)
amitabhssinha (12/31/2009)
This is part of my query:(CASE
WHEN (DATEDIFF(second,Actual.ActualDepartTime,Schedule.SchdDepartTime)/60) >=60
THEN Convert(nvarchar(10),(DATEDIFF(second,Actual.ActualDepartTime,Schedule.SchdDepartTime)/60)/60)+' '+'hr'
Else (DATEDIFF(second,Actual.ActualDepartTime,Schedule.SchdDepartTime)/60) +' '+'min.'
END) AS DeptEarly
Yep, you're "trapped" by SQL Servers concept to define the...
December 31, 2009 at 3:54 am
I know a company that runs the following concept:
During weekend and Holiday there will be a three level support system:
Level 1: On Call
You have to be reachable by phone for...
December 31, 2009 at 3:28 am
amitabhssinha (12/31/2009)
"Syntax error converting the nvarchar value '95 hr' to a column of data type int."
Anyone can please show...
December 31, 2009 at 3:09 am
.. or just stay around here, look through the forums and read some articles.
The money you saved could be spent on some good books for deeper insight on subjects you...
December 30, 2009 at 3:49 pm
What have you tried so far?
Also, please read and follow the recommendation in the first link in my signature on how to post sample data.
What would you insert into the...
December 30, 2009 at 3:10 pm
Nice one, Chris!!
Another overcomplicated effort from the peanut gallery.
I wouldn't take it that serious... if the requirement would have been to always have a group of 6, then there would...
December 30, 2009 at 3:04 pm
Can you call the proc directly, using the required input values?
Completely different direction:
Are you sure the proc you're calling is used by the 3rd party application at all? Maybe it's...
December 30, 2009 at 2:35 pm
How about this to assign a group number to each set regardless of the number of rows?
;with cte1 AS
(
SELECT id,
row_number() OVER (order BY id) AS row
FROM @school...
December 30, 2009 at 1:35 pm
Let me quote my question/recommendation from above:
lmu92 (12/23/2009)
...What would happen if you'd store the data "as is" into a SQL Server staging table and go from there?
I don't think it's...
December 30, 2009 at 12:48 pm
AndrewSQLDBA (12/30/2009)
I fired some guy for prefixing all the table names that way. That is very poor naming convention.Andrew SQLDBA
I'd rather fire the guy who'd be responsible for the rules...
December 30, 2009 at 12:19 pm
Actually, you do have a direct reference to sysobjects.object_id:
Example:
SELECT * FROM sysobjects WHERE object_id
is equal to
SELECT * FROM sysobjects WHERE sysobjects.object_id
The original statement just left out the table qualifier.
December 30, 2009 at 11:08 am
What exactly is your question?
You're "throwing" almost 250 lines of code at us and didn't even tell us what to do with it...
December 30, 2009 at 10:42 am
bigclick (12/23/2009)
December 23, 2009 at 4:08 pm
Attached please find an example of how I would do it.
Please note that I didn't completely populate MSH, EVN, PID, and PV1 rows. But it basically would follow the concept...
December 23, 2009 at 4:02 pm
Would something along those lines work?
DECLARE @date datetime
SET @date ='20091226'
SELECT
CASE
WHEN day(@date) % 7 = 5 THEN 'run'
ELSE...
December 23, 2009 at 12:17 pm
Viewing 15 posts - 4,636 through 4,650 (of 5,504 total)