Forum Replies Created
Viewing 15 posts - 1,696 through 1,710 (of 2,171 total)
-
RE: Conversion from string to integer error
Ahhh! You put numeric data in the BETWEEN? Then SQL Server tries to convert the base data to the datatype in the BETWEENS.
I use Developer Edition of SQL Server 2005...
N 56°04'39.16"
E 12°55'05.25" -
RE: Conversion from string to integer error
How can this error occur?
I don't do any type of conversion here!
The only reason for this, is that you don't post the full query. You must use this and put...
N 56°04'39.16"
E 12°55'05.25" -
RE: Conversion from string to integer error
SELECT
*
FROM qSoldier
WHERE regNo NOT LIKE '%[^0-9]%'
AND regNo...
N 56°04'39.16"
E 12°55'05.25" -
RE: How to handle Currency Rate Exceptions
I think some sample data and expected output would be nice.
N 56°04'39.16"
E 12°55'05.25" -
RE: union sum
You're bad Jeff, bad...
N 56°04'39.16"
E 12°55'05.25" -
RE: Stored Procedure working fine but problem for the last two months
Yes, the last part posted above
SELECT
s.EmpID,
s.ManagerID
FROM @Sample AS
N 56°04'39.16"
E 12°55'05.25" -
RE: Stored Procedure working fine but problem for the last two months
Try something like this!
-- Prepare sample data
DECLARE @Sample TABLE (EmpID VARCHAR(4
N 56°04'39.16"
E 12°55'05.25" -
RE: Stored Procedure working fine but problem for the last two months
You also need to check, for example
Employee A reports to Employee B.
Employee B reports to Employee A.
or
Employee A reports to Employee B.
Employee B reports to Employee C.
Employee C reports to Employee...
N 56°04'39.16"
E 12°55'05.25" -
RE: Stored Procedure working fine but problem for the last two months
Check for CIRCULAR REFERENCE!!!
Either an employee who has herself/himself as manager, or a larger chain fo managers that creates a "circle".
N 56°04'39.16"
E 12°55'05.25" -
RE: union sum
???
Where is the difference, Jeff?
"Employe" or "Employee"?
N 56°04'39.16"
E 12°55'05.25" -
RE: Problem with Subtraction of Dates
Asked and answered here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81761
N 56°04'39.16"
E 12°55'05.25" -
RE: Sort breaks
Jason, either is equally good for now.
But... If original poster (OP) wants to extend the query to include sum of total order amount for each line, my query is easier...
N 56°04'39.16"
E 12°55'05.25" -
RE: Sort breaks
The derived table y you must replace with the aggregation for you OrderHead table.
N 56°04'39.16"
E 12°55'05.25" -
RE: Ranking rows in a group (SQL 2000)
As long as you understand what the query do, it's fine.
Thanks. And good luck!
N 56°04'39.16"
E 12°55'05.25" -
RE: Sort breaks
Try this approach
SELECT Txt, Cnt FROM ( SELECT c.Txt, COUNT(*) AS Cnt, c.Sort FROM ( SELECT '$0-$10' AS Txt, -1 AS LowLimit, 10 AS HighLimit, 0 AS Sort...
N 56°04'39.16"
E 12°55'05.25"
Viewing 15 posts - 1,696 through 1,710 (of 2,171 total)