Ms Sql Server Technology Discussions

[ipaddress0]

2 months wfh, 1 montha vacation man... 

enjoy mayya  :police:

[Darling999]

working from india man... aa manager gadu april h1's time... manam job ichina client letter ani sava godtaaru so april ki postpone cheddam hiring ani cheppadu man...

Hmmm Helpless bhayya... India nubdi pani avtubda? Monna poyina 2.5 months ki Konchem kashtam anpinchindi nights

[loveindia]

enjoy mayya  :police:

 

thanks man, you also enjoy man... tondarloney nenu kuda one house vaadni avta.. appudu enjoy start chesta :D 

[ipaddress0]

thanks man, you also enjoy man... tondarloney nenu kuda one house vaadni avta.. appudu enjoy start chesta :D 

atb mayya 

[manjunath455]

#4H#  #4H#  

[vizagpower]

SSRS Lo count based on condition ela chestam , I mean say 1000 records unte i need to get count of rows based on conditions say count of all cancelled accounts and count of active accounts based on a flag ??????

[loveindia]

SSRS Lo count based on condition ela chestam , I mean say 1000 records unte i need to get count of rows based on conditions say count of all cancelled accounts and count of active accounts based on a flag ??????

 

elaborate more man... ardam avaledu question... 

[mtkr]

elaborate more man... ardam avaledu question... 

 

 

lyk oka query nundi vache count reslt ni ela ola column count laaaga chupinchaali ani askng....

[vizagpower]

lyk oka query nundi vache count reslt ni ela ola column count laaaga chupinchaali ani askng....

[vizagpower]

elaborate more man... ardam avaledu question... 

Say I have three statuses " Approved" , "Pending", "cancelled" , I need to get total  of accounts which fall into these 3 categories , say 

 

 

Sno  Status  Last Quarter   previous Quarter     percentage change (calculated column)

 

1    Approved  200                 400                      (400-200)/200

2   pending      150                 50                        (50-150)/150

3   Cancelled    25                  50                         (50-25)/25

 

Also how can we find the caluclated column for grouping in SSRS ?

[vizagpower]

elaborate more man... ardam avaledu question... 

Say I have three statuses " Approved" , "Pending", "cancelled" , I need to get total  of accounts which fall into these 3 categories , say 

 

 

Sno  Status  Last Quarter   previous Quarter     percentage change (calculated column)

 

1    Approved  200                 400                      (400-200)/200

2   pending      150                 50                        (50-150)/150

3   Cancelled    25                  50                         (50-25)/25

 

Also how can we find the caluclated column for grouping in SSRS ?

 

 

Can i call you today ?

[JammichettuPandu]

Long thread

[loveindia]

 

Say I have three statuses " Approved" , "Pending", "cancelled" , I need to get total  of accounts which fall into these 3 categories , say 

 

 

Sno  Status  Last Quarter   previous Quarter     percentage change (calculated column)

 

1    Approved  200                 400                      (400-200)/200

2   pending      150                 50                        (50-150)/150

3   Cancelled    25                  50                         (50-25)/25

 

Also how can we find the caluclated column for grouping in SSRS ?

 

 

Can i call you today ?

 

 

elaborate annanu kada ani india ki call chesestaava man... :P I am in india now...

 

= (IIF(isnothing(Fields!PreviousQuarter.Value), 0, Fields!PreviousQuarter.Value) - IIF(isnothing(Fields!LastQuarter.Value), 0, Fields!LastQuarter.Value)) /  IIF(isnothing(Fields!LastQuarter.Value), 0, Fields!LastQuarter.Value)  

 

Best solution... if possible nee sql query loney chey aa calculation or else SSRS Xvelocity Engine is not that great... if too many aggregations it will choke... 

[manjunath455]

why can't we use case statement in dynamic sql statement? Evarikaina teliste pls cheppandi :3D_Smiles_38:

[Darling999]

Delete and truncate lo Rollback vaadachu kadaa... only Delete antaaru entii, I can do truncate rollback asloo in the SSMS.

 some one explain... Loveindia