GA_SQL (6/21/2016)

---

i almost done ..created another SP called effreportday to calculate efficencyreport which will give the daywise efficiency of the employee like this empidd1 d2d3d4d5d6d7d8d9d10d11d12d13d14d15d16d17d18d19d20d21d22d23d24d25d26d27d28d29d30d31WorkingDaysTotalEfficiencyAverage

509700000000000000000008890000000000001780

i want...

USE [tempdb]

CREATE TABLE [dbo].[#Holidaymaster](

[Holiday_ID] [int] NULL,

[Holiday] [varchar](50) NULL,

[Date1] [datetime] NULL

) ON [PRIMARY]

GO

INSERT [dbo].[#Holidaymaster] ([Holiday_ID], [Holiday], [Date1]) VALUES (1, N'New Year', '2016-01-01' )

INSERT [dbo].[#Holidaymaster] ([Holiday_ID], [Holiday], [Date1]) VALUES (2, N'Pongal', '2016-01-16'...

show what code you tried (I cant see your screen :-)) and...

ganapathy.arvindan (6/20/2016)

---

Same way i also did, but including has column in this pivot is not working..WITH yourcalendar1 as (

SELECT DATEADD(dd, rn - 1, @sd) thedate, 'D' + CAST ((rn )...

as a start

SELECT COUNT(hdL)

FROM #temp

WHERE ...

rb76 (6/18/2016)

---

Hi,

thanks for the answers. But I think I didn't explain my question not good enough.

The table contains about 30000 lines. So I think I cannot make my query with...

ByronOne (6/17/2016)

---

Hi everyone

I have a table in SQL called dbo.ACTIVITIES which records the time it takes to complete a certain activity.

The time taken to perform the activity is recorded in...

did you manage to solve this successfully ?

suggest you research "MS SQL Integer division"

heres some code to play around with

CREATE TABLE #mytable(

cnt INTEGER NOT NULL

,total...

futhre to my previous post.....care to fully explain what you mean by this:

OUPUT:

lngOrderID, lngBillingStepID, lngBillingStepID, lngSubBillingStepID =1, lngSubBillingStepID =2, lngSubBillingStepID=3

I would like the lngSubBillingStepID to show their orginal value of...

maybe.....

SELECT id, cnt, total, cnt*1.0/total

FROM <yourtable>

what are the datatypes for columns "cnt" and "total"?

what are you expected results?

just a word to the wise...and I am sure you already know this....but before doing any calculations be sure you undestand what UOM (unit of measure) you are dealing with...

David92595 (6/15/2016)

---

Sorry, my spacing\formatting got removed...hope this is a little better.

CREATE TABLE [dbo].[tblOrderBillingSteps](

[OrderBillingStepID] [int] IDENTITY(1,1) NOT NULL,

[lngOrderID] [int] NULL,

[lngBillingStepID] [int] NULL,

[lngSubBillingStepID] [int] NULL,

CONSTRAINT [PK_OrderBillingSteps] PRIMARY KEY CLUSTERED

INSERT INTO...

CREATE TABLE #ATableLike(

ID INTEGER NOT NULL

,TS INTEGER NOT...