Lowyat.NET: Latest topics by HAS

[WTS]Intel i7 9700k + Z390 Auros Elite + DDR4 32GB

HAS — Thu, 16 Nov 2023 11:09:16 +0800

Item(s): Intel i7 9700k + Z390 Auros Elite + G.Skill Sniper X DDR4 8GBx4

Package includes: cpu + mobo + ram

Price: 1800

Warranty: 1 week

Dealing method: cod

Location: selangor/kl/pj

Contact method/details: whatapp/pm tepi
---

Item(s) conditions: Used

Picture: upon request

Reason for sale: Upgrade

[WTR] Menara Alpha Kondominium, Setapak

HAS — Fri, 14 Jan 2022 20:12:15 +0800

NO LONGER AVAILABLE
Menara Alpha Condominium

Refrigerator \ Ceiling fan \ washing machine \ Water heater \ Car park
\ Window curtains \ Television

dinning table and sofa included

Shopping Mall & Leisure :
- Wangsa Walk Mall
- Setapak Central (formerly known as KL Festival)
- Melawati Mall
- AEON Jusco
- GIANT

UNIQUE FEATURE
- Near LRT Wangsa Maju
- TAR College & UTAR
- Downstair was shop
- Connected to MRR2, KESAS, Duke, AKLEH, Jln Genting Klang
- Public transportation
- TARC Bus
- Close to TARC
- Built by reputable developer
- Closer to city
- Great potential for investment

available 12/1/2021

WTB>Buying 2080 ti

HAS — Fri, 13 Nov 2020 10:37:13 +0800

WTB : Nvidia RTX 2080 ti Founder edition used mint condition
Budget : RM2.5-3k

3rd party option : Asus rog strix , MSI trio gaming x or EVGA or any model
( RTX 2080 ti only )
budget : RM2k-2.5k

Interested serious seller , please pm. Tq
COD location : KL area , PJ

WTB > used desktop i7 8700k

HAS — Tue, 27 Nov 2018 18:38:32 +0800

spec and offer me please thank you. buying desktop with i7 8700k without gc only

[WTB] 1080ti Gaming Desktop (new/used)

HAS — Thu, 06 Sep 2018 12:39:14 +0800

Item(s):Gaming desktop with at least 1080ti

[b]Package includes:

CPU: preferable i7 latest gen but you can propose
GPU: gtx 1080 ti (non mining pls)

[b]Price: offer me pls

Warranty: tell me

Dealing method: COD only

Location: KL/SELANGOR

Contact method/details: PM only
---

Item(s) conditions: used

Picture: please provide me some

Reason for buy: i want to play game!

[WTB]buying APPLE IPAD AIR 2 64gb/128gb

HAS — Wed, 14 Dec 2016 18:46:20 +0800

Item(s): Want to buy APPLE IPAD AIR 2 64gb/128gb

Package includes:

Price: offer me.

Warranty:

Dealing method: COD

Location of seller: Petaling Jaya/Selangor/

Contact method/details: PM

Age of item: Used / New / Sealed / Whatever / offer me !

---

Item(s) conditions:

Picture:

Reason for sale:

[WTS]Asus Strix Gtx 980 DirectCU II 4GB OC!

HAS — Fri, 13 May 2016 17:27:52 +0800

Item(s):Asus Strix Gtx 980 DirectCU II 4GB OC ( 2 units)

Package includes:Card + Box + CD + Sticker

Price:RM 1800 (each) // buy 2 discouunt -rm100

Warranty:Unitl November 2017

Dealing method:COD/POS(own risk pay first)

Location of seller:PJ / Melaka / KL

Contact method/details: 013-2507441

Age of item:1yrs+

Item(s) conditions:Tip TOP. Some of the benchmark and 4k gaming video is here

4k gaming - https://www.youtube.com/watch?v=n6am46BquLs
Ultra benchmark Unigine heaven - https://www.youtube.com/watch?v=OuoX9IyVqoQ
The division benchmark High settings - https://www.youtube.com/watch?v=5lXXmAJZb4o
The division benchmark Ultra settings https://www.youtube.com/watch?v=8xksTAD7-oM&feature=youtu.be
4k benchmark - https://www.youtube.com/watch?v=x4l0qBJ1Wqs

Reason for sale:Upgrade

SQL statistic help

HAS — Tue, 09 Feb 2016 00:33:22 +0800

any expert here?

last time i using interval, but i dont think it work like i want to,
i just want to declare year and month.. any guru can teach me here?

this is sample data as request:

food_type | sales | date_sales
pizza buy 02-01-2015 12:00:00
pizza buy 02-01-2015 03:00:00
pizza sell 03-01-2015 01:00:00
pizza sell 04-01-2015 05:00:00
pizza buy 05-01-2015 02:00:00

this is sample i trying to do

DECLARE @Startdate AS datetime = '02-01-2015',
@Enddate AS datetime = '05-01-2015'

SELECT TYPE_FOOD, COUNT(CASE WHEN STATUS = 'BUY' THEN 1 END) AS [INCOMING], COUNT(CASE WHEN STATUS= 'SELL' THEN 1 END) AS [OUTGOING]
FROM Shop WHERE [Something_Date] BETWEEN @StartDate AND @EndDate

OR

SELECT TYPE_FOOD, COUNT(CASE WHEN STATUS = 'BUY' THEN 1 END) AS [INCOMING], COUNT(CASE WHEN STATUS= 'SELL' THEN 1 END) AS [OUTGOING],DATEDIFF(MONTH, DATE_OF_PURCHASE, @YEAR ) AS [YEAR]
FROM Shop
GROUP BY TYPE_FOOD, DATEDIFF(MONTH,DATE_OF_PURCHASE, @YEAR )
-- i cant use datediff because i want between date..

this the close query i can get if using datediff...not year only anymore...

Food TYPE | MONTH | BUY | SELL
pizza 12 10 5
pizza 13 3 1
.... ... .. ..
pizza 32 5 2

How to make sql output like this:

Food TYPE | MONTH | BUY | SELL |
pizza Feb-15 10 5
pizza Mar-15 3 1
.... ... .. ..
pizza May-15 5 2

please help me guru, i very beginner in sql

<WTB>Buying Dominator 2gx3 (CMP6GX3M3A1600C8)

HAS — Sun, 11 Oct 2015 03:08:07 +0800

as per topic,,, i buying pls pm me

WTB> Seasonic PCI-E power cable

HAS — Sun, 08 Feb 2015 01:40:32 +0800

Item(s):1

Package includes: cable only

Price:offer me

Warranty:no need

Dealing method:COD/POS

Location of seller: PJ

Contact method/details:PM ME

Age of item:dont care

---

Item(s) conditions: fine.

Picture:please provide me... to make sure what i looking for is same like my powersuply...

Reason for buy: need more connecter

[WTS] GTX 570 1280MB GDDR5 (EVGA)

HAS — Thu, 05 Feb 2015 12:47:15 +0800

Item(s): EVGA GTX 570 1280MB GDDR5 AND LEADTEK GTX 570 1280MB GDDR5

Package includes: All Accessories, CD, Receipt, Original Box..

Price: Offer me

Warranty: 1 Week Personal Warranty

Dealing method: COD ONLY..

Location of seller: PJ/SELANGOR

Contact method/details: PM ME

---

Item(s) conditions: Tested and 100% Working.

Reason for sale: Upgrading

WTB> Faulty Graphic Card 6 Series and Above Nvdia

HAS — Tue, 03 Feb 2015 19:23:21 +0800

Item(s): Faulty Graphic Card Nvidia or ATI

Package includes: Graphic Card only needed

Price: Offer me

Warranty: dont care got or not

Dealing method: COD area Selangor or POSTAGE

Location of seller: PJ/KAJANG/NILAI/SELANGOR AREA

Contact method/details:PM ME OR LEAVE A MESSAGE HERE

Age of item:

---

Item(s) conditions: Faulty/Problem Graphic Card / No use..

---Please pm me about the Item exact faulty condition thanks you..

[WTB] Anabolic 15lbs choc

HAS — Sat, 15 Jun 2013 13:40:32 +0800

Buying one only... and cod pls.. pm me price ok thx....~

need chocolate flavor

W3400V INNACOMM

HAS — Mon, 21 Feb 2011 21:56:08 +0800

Hi guys,

I need some expert help here..

i just sign up streamyx 1 mbps package with my roomate,,

but one of us is using torrent and downloading stuff... it ruin our gamers latency

i need help how to divine the bandwidth... i been to modem router setup but i duno how to configure it... need help here..