Viewing 15 posts - 16 through 30 (of 33 total)
i have two tables organization dtls and emp dtls
organizationdtls
columns : oid, orgname, level, parentid
values: 10, Unit1, 1, 0
11, Dept1, 2, 10
12, Dept2, 2, 10
13, Section1, 3, 11
Employee dtls
columns: eid, empno,...
December 27, 2011 at 12:21 am
i have two tables organization dtls and emp dtls
organizationdtls
columns : oid, orgname, level, parentid
values: 10, Unit1, 1, 0
11, Dept1, 2, 10
12, Dept2, 2, 10
13, Section1, 3, 11
Employee dtls
columns: eid, empno,...
December 27, 2011 at 12:02 am
No.
I am getting output perfectly with the querry i have provided but i need the missing days for example if cards are not added on some days like 6,7,8,9, 10...
February 9, 2010 at 1:52 am
I got result from this querry but need missing days also
select day(createdate) as days,count(cat1)as Cat1,count(cat2)as cat2,count(cat3)as cat3 from in_catidview
where year(createdate)=2010
group by day(createdate)
order by day(createdate)asc
cat1,cat2,cat3,cat4 have values of 1,2,3,4.
It will return...
February 9, 2010 at 12:17 am
No , the ouptut should be some like that..
one idea is to have for loop with each day in month and get count of each category with function but...
February 8, 2010 at 5:42 am
IS IT POSSIBLE to get unique TID though we have other records unique? I mean TID should be repeated only one that too with value 20 with updated values?
March 23, 2009 at 5:37 pm
I am expecting TID SHOULD BE UNQUIE IN MY RESULTS.. THAT TOO UPDATED DATE..
DEFINATION FOR THIS TABLE IS
EIDintno410 0 no(n/a)(n/a)NULL
ENAMEnvarcharno100 ...
March 23, 2009 at 5:16 pm
thanks a lot for giving help so early.
i am very kindfull to you.
it is executing properly with out any issues.
thnx dude..
March 26, 2008 at 8:28 am
when i m using xp_sendmail it is giving an error like
xp_sendmail: failed with mail error 0x80040111
may i know what is the error behind it?
January 27, 2008 at 5:37 am
npe, i dont know how to write code for it or any procedure related to it
January 25, 2008 at 11:06 pm
well sorry for not providing full information.
i am a .net developer but poor in sqlserver.
i am working in small firm where there is no body to help me out from...
January 25, 2008 at 12:29 pm
well sorry for not providing full information.
i am .net developer but poor in sqlserver.
i am working in small firm where there is no body to help me out from this...
January 25, 2008 at 12:17 pm
well with the client request i gave solution.
i never ask for what he needs !
November 12, 2007 at 11:25 am
Viewing 15 posts - 16 through 30 (of 33 total)