Novak_Djokovic Posted July 31, 2015 Report Posted July 31, 2015 SQL database lo ....we had a "dbo.SiteApplicationDetails" table it got about 20+ columns.... some of the columns ....i have to code ....are named like: respective to each month of a year ..... OperJanDays OperFebDays OperMarDays OperAprDays OperMayDays OperJunDays OperJulDays OperAugDays OperSepDays OperOctDays OperNovDays OperDecDays StartDate EndDate we are passing " @ClaimDate" parameter......into "sp_SiteApprovals" stored procedure..... depending on above cloumns ...i have to do the claims..... SELECT 1 FROM dbo.SiteApplicationDetails WHERE ???????? there are other filters in above SELECT query to pull single record from the table.....but ihave to filter further with @ClaimDate and cloumnvalue..... (The above select query is inside "sp_SiteApprovals" ) how should i filter from the table depending on ....claimdate and value in corresponding month column...??
Novak_Djokovic Posted July 31, 2015 Author Report Posted July 31, 2015 Example: If @ClaimDate = '06/01/2015' Claim month should be for June.... So....i have to check if there is any value or "Zero" for "OperJunDays" column in the table....? If "OperJunDays" column value is "31" then i have to RETURN 1 from the "SELECT 1 FROM dbo.SiteApplicationDetails WHERE ????????" in the stored procedure..... If "OperJunDays" column value is "0" then i have to RETURN 0 from the "SELECT 1 FROM dbo.SiteApplicationDetails WHERE ????????" in the stored procedure.....
Novak_Djokovic Posted July 31, 2015 Author Report Posted July 31, 2015 calling loveindia vuncle kwalling....calling....
Novak_Djokovic Posted July 31, 2015 Author Report Posted July 31, 2015 calling loveindia vuncle Thanks....:)
4Vikram Posted July 31, 2015 Report Posted July 31, 2015 nenu devudni ki kuda pm petu he can also help i guess... ravali ravali loveindia ravali ravali
loveindia Posted August 1, 2015 Report Posted August 1, 2015 give atleast some sample data to work man...
4Vikram Posted August 1, 2015 Report Posted August 1, 2015 give atleast some sample data to work man... nenu chepale sql ante ochestadu manshi ani.. kudos to you bhaiyya, sql kastlaki apathbandhavudivi nuvvu
loveindia Posted August 1, 2015 Report Posted August 1, 2015 nenu chepale sql ante ochestadu manshi ani.. kudos to you bhaiyya, sql kastlaki apathbandhavudivi nuvvu
loveindia Posted August 1, 2015 Report Posted August 1, 2015 If you know subject reply to his Q, fake pakodi L batch ok elli pani chusko man inka kasta paddavu ga... aada cheppina daantlo neeku ardam aindi endo cheppu alaney code raasi ista picha naa putra...
loveindia Posted August 1, 2015 Report Posted August 1, 2015 bomma neeku unte help him or STFU beggar evadraa nuvvu fake fakodi.... aadangi uncle gaani laaga verey valla ids eskoni vachav... naaku bomma undo ledo naaku telsu kaani nee billa jagratha ra rey... aina chaduvula thread lo nee galeez eshaalu aapi pakka thread eyyy ra pundakorr..... maaku vachu ra tittadam dafferr...
Pichkaari Posted August 1, 2015 Report Posted August 1, 2015 If you know subject reply to his Q, fake pakodi L batch How are you ideBeZaWaDa .. brother of idiBeZaWaDa ..
Recommended Posts