Thai Chilli Rice Crackers plus Mountain Dew for me

methexis (11/25/2011)

---

Okay I hope I followed the rules on this!

So the result should look something like this

1234 CompanyX US 0.5

1234 CompanyX EU 0.5

4321 ...

methexis (11/25/2011)

---

That didnt do it...damn it!

The error I am guessing is here

SUM (a.Pass/(COUNT (ACCGRPNUM))) as RATE

using the ACCGRPNUM to get the total number of locations by Region kicks...

rktn_odin (11/24/2011)

---

LutzM (11/24/2011)

---

SELECT Date2 AS DateOutput FROM YourTable ??

It's most probably not the code you're looking for, but it's a valid solution based on your sample data... You might want...

Ninja's_RGR'us (11/23/2011)

---

The most prolific poster post because it's the RIGHT thing to do. Not to get anything of any kind...

SameerKKhan (11/25/2011)

---

hello again,

i have one more query.Can i get the Date and Hour using a Query.

I want to Insert the Date along with the hour part in the Table.Like...

SameerKKhan (11/25/2011)

---

hello again,

i have one more query.Can i get the Date and Hour using a Query.

I want to Insert the Date along with the hour part in the Table.Like...

Off the bat it looks like you're missing a GROUP BY (formatted you code below)

USE DQ_RefData

-- Calculate %--

SELECT ACCGRPNUM, ACCGRPNAME, REGION,

SUM(a.Pass / (COUNT(ACCGRPNUM))) AS RATE

-- LOCATIONS THAT MEET CRITERIA--

FROM...

Something like this?

DECLARE @TABLE AS TABLE (string VARCHAR(50))

INSERT...

SameerKKhan (11/25/2011)

---

Cant i use the Date filter with (yyyy/MM/dd) format only.Just to check the year,Month,Day and bring the time part in the picture.

cant i use the- convert(varchar(10),getDate,111) to...

BEGIN TRAN

CREATE TABLE companies (id INT)

INSERT INTO companies

SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3

SELECT CAST('<img href="http://google.com/' + CAST(id AS VARCHAR(50)) + '_thumb.jpg" />' AS XML) AS

FROM...

SameerKKhan (11/25/2011)

---

hi thank u so much for the reply,

i want to add another filter to the Query i.e the Date.There is a Date column in Attendance.

I want to get...

You're using "your" proc incorrectly.

DECLARE @MyPeriod INT

SET @MyPeriod = CONVERT(INT, '201103')

SET @MyPeriod = CASE WHEN @MyPeriod BETWEEN 175301 AND 999912 AND @MyPeriod % 100 BETWEEN 1 AND 12

...

rootfixxxer (11/24/2011)

---

Hello

I was testing here some data with dates, but then i realize that sql server rounds the seconds, when converting from a string to a datetime/smalldatetime.

What's the "problem"/logic behind...

SameerKKhan (11/24/2011)

---

I have three Tables.One is

EmployeeMaster(EmpCode,EmpName,MobileNo)

Sample Date EmployeeMaster(1,SameerKhan,4512541321)

ClassMaster(ClassId,ClassName,EmpCode)

Sample Data ClassMaster(1,ClassA,1)

Here EmployeeCode in ClassMaster is the EmpCode from EmployeeMaster.

Attendance(StudentID,Class,Status)

sample data Attendance(445,ClassA,Absent)

Here Class will come from ClassMaster

Now suppose...