sql nerchukundam randiii... Ms sql server technology discussions...

[mtkr]

issue: SSRS rep ni excel ki export chesinappudu last lo col getting hidden(Extra column)... 

Soln: oka 1 hr mind tinnadiii ardam kaaka... 

round up the val of text boxs(all columns) width.. until 2 decimals is fine...

http://blogs.msdn.com/b/how_to_eliminate_merged_and_hidden_cells_issue_from_excel_export_of_ssrs_report/archive/2013/05/17/how-to-eliminate-merged-and-hidden-cells-issue-from-excel-export-of-a-ssrs-report.aspx

[loveindia]

 man.... 

[4Vikram]

1 minute ago, loveindia said:

 man.... 

spammer vuncle why spamming in this manchi thadu 

[loveindia]

1 minute ago, 4Vikram said:

spammer vuncle why spamming in this manchi thadu 

define spamming man...  calling @johnubhai_01 for clarification man... 

[4Vikram]

22 minutes ago, loveindia said:

define spamming man...  calling @johnubhai_01 for clarification man... 

he is the leader of spamming no he can only tell @johnubhai_01 @dappusubhani

[Sambadu]

On 6/4/2016 at 1:11 AM, loveindia said:

don't post easy kochens like this man... see below...

;WITH CTE AS (
SELECT '123' AS ClaimID
UNION
SELECT '1234A'
)
SELECT ClaimID
FROM CTE
WHERE ISNUMERIC(ClaimID) = 1
UNION
SELECT LEFT(ClaimID, LEN(ClaimID) - 1)
FROM CTE
WHERE ISNUMERIC(ClaimID) <> 1

;WITH CTE AS (
SELECT '123' AS ClaimID
UNION
SELECT '1234A'
)
SELECT ClaimID
FROM CTE
WHERE ISNUMERIC(ClaimID) = 1
UNION ALL ----------------------------------------- ekkada union all pettu bro......................... ( union vaddu)
SELECT LEFT(ClaimID, LEN(ClaimID) - 1)
FROM CTE
WHERE ISNUMERIC(ClaimID) <> 1

[Quickgun_murugan]

On 6/2/2016 at 1:18 PM, loveindia said:

ee thread enti ila undi man...

SQL always on lo oka node on-prem and oka node cloud lo pettali. dani setup ela cheyyali ? enni listeners kavali ? enni IP addresses kavali ? enni Load balancers kavali etc ? full details pls 

idi nenu kadu.. saamy adigaadu

[SwamyRaRa]

Ltt

[4Vikram]

start time inka end time ki time differene kavali but DATEDIFF(MINUTE, START_TIME, END_TIME) as Duration use cheste getting thi error

Arithmetic overflow error converting expression to data type datetime.

cast convert anni try chesna but not working... data type for columns is defined as INT and values are llike this : 43800000
39600000
39600000
47640000

 

what to do?

[papacha]

so what does this  43800000  define ante does it have date part hour part or minute part?

because if you have something like this 20151216234436 where 2015-12-16 23:44:36 then substring and replace use cheysi achieve cheyochu

[SwamyRaRa]

[4Vikram]

SQL Rawks 

[SwamyRaRa]

Pls share SQL/ssis/ssrrs training tutorials and videos 

also some useful links too

for beginners and beginners to become experts 

[mekapichal_mnthmkora]

On ‎6‎/‎2‎/‎2016 at 0:35 PM, k2s said:

@k2s thatha.. y laughing ray/

[DiscoKing]

1 hour ago, 4Vikram said:

SQL Rawks 

SQL tho paatu edanna programming lang vasthe triple rawks