peshvar.com

SQL breakdown TIME

By peshvari, on March 19th, 2009

This statement will count number of records in a given month and breakdown it every 30 minutes.

select count(ID) as ID_Count, Date_30min from
( select ID, convert(datetime,convert(varchar(14),calldatetimefield,120) + case when datepart(minute,calldatetimefield) < 30 then '00' else '30' end) as date_30min from tablename where calldatetimefield between '2009-02-01 00:00:00.000' and '2009-02-28 23:59:59.997' and ......) . . . → Read More: SQL breakdown TIME

Molood in peshvar

By peshvari, on March 15th, 2009

I have also found this on youtube. I missed all . . . → Read More: Molood in peshvar

SQL updating field with current timestamp

By peshvari, on March 10th, 2009

MS SQL to update a field to current time:

update tbl1 set col1 = convert(varchar(5),getdate() ,108)

result:

col1 . . . → Read More: SQL updating field with current timestamp

Peshvaries in 1957

By peshvari, on March 10th, 2009

I got these two pictures from someone in Bahrain…. I have no idea who these people are.. the picture was taken in 1957…

if you do please let . . . → Read More: Peshvaries in 1957

Pay Zakaat, Sadagha, donation and etc Online

By peshvari, on March 10th, 2009

I recently came across this site:

Khaire Online

you can pay Zakat, Vaghfeyat, Sadagha and more donations online… You can also choose the country that you would like to send your donation to.

The site in based in Kuwait. KNET is the only option that they accept for online payment. Visit their web site for more . . . → Read More: Pay Zakaat, Sadagha, donation and etc Online

Peshvar Soccer team in Kuwait

By peshvari, on March 9th, 2009

Hi All,

Shabab Team

This is Shabab team in Kuwait. Apparently they are doing pretty good. Just to avoid any copyright, I got the picture . . . → Read More: Peshvar Soccer team in Kuwait

Wedding – Aroosi Peshvar

By peshvari, on March 7th, 2009

I just found this video on youtube 🙂
Funny, I was there . . . → Read More: Wedding – Aroosi Peshvar

Cat For Sale: $22,000

By peshvari, on March 5th, 2009

Wow, we thought of getting one for the . . . → Read More: Cat For Sale: $22,000

Linux VS Windows

By peshvari, on March 5th, 2009

The first OS that I used was DOS… I guess it was version 6.2 if I recall correctly…

then Widows 3.1, way easier than typing command and things like that… well, then Windows 95, 98, 2000 etc… so I kind of grew up with Windows… Not that I don’t link Linux but I never had the chance . . . → Read More: Linux VS Windows

EBAY

By peshvari, on March 5th, 2009

I love ebay… If you want to have fun online, ebay is the place to go.

I have so far sold about 10 to 15 different items on ebay, made about 500$ from things that I didn’t need anymore. Trust me, people will buy it. Try it, you wont . . . → Read More: EBAY

Sponsors