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

[Kontekurradu]

What is mdx MAN ?

[Quickgun_murugan]

Token and TokenCount are two functions introduced in the SQL Server 2012 release of SSIS and they assist you with the splitting of strings, something that was quite difficult in earlier versions of SSIS.

https://msdn.microsoft.com/en-us/library/hh213216(v=sql.110).aspx

[sanbk]

3 minutes ago, Kontekurradu said:

What is mdx MAN ?

Multi Dimensional expression. Idi oka language tsql laga cubes nundi data pull cheyadaniki this is more related to SSAS

MDX enti ani adigavu ante porapatuna kuda SSAS job ippatlo try cheyaku endukante deeniki next amma mogudu DAX kuda vachindi 2012 version loo 

[mtkr]

 

43 minutes ago, kum5758 said:

bros- any links for this pls

https://www.mssqltips.com/sqlservertip/2922/sql-server-alerts-with-text-messaging-from-sql-server-database-mail/

 

??

[loveindia]

7 minutes ago, sanbk said:

Multi Dimensional expression. Idi oka language tsql laga cubes nundi data pull cheyadaniki this is more related to SSAS

MDX enti ani adigavu ante porapatuna kuda SSAS job ippatlo try cheyaku endukante deeniki next amma mogudu DAX kuda vachindi 2012 version loo 

DAX is the most easiest language compared to MDX / SQL man... MDX is the mother of SQL man...

[loveindia]

Please close this thread man, its boring... 

[Quickgun_murugan]

Just now, loveindia said:

DAX is the most easiest language compared to MDX man... MDX is the mother of SQL man...

MDX n SQL are two different languages. but mDx is more complex.. DAX is not too complex easy to learn with a basic knowledge of excel functions. 

[sanbk]

evaraina job unte cheppandayya MSBI meeda june 30 ki assam na project... 

[k2s]

5 minutes ago, loveindia said:

Please close this thread man, its boring... 

 

[kum5758]

47 minutes ago, mtkr said:

 

https://www.mssqltips.com/sqlservertip/2922/sql-server-alerts-with-text-messaging-from-sql-server-database-mail/

 

??

thanks bhayya

try chesa last week..work kavatle.

 

[kum5758]

18 minutes ago, kum5758 said:

thanks bhayya

try chesa last week..work kavatle.

 

ipudu workout aindi bhayya-- ma vadidi verizon network ata.

used below , Thanks

http://blog.directionstraining.com/microsoft-sql-server/texting-alerts-from-sql-server-database-mail

[cool_dude]

hi sql babus , i need some help 

i have table like following structure 

claim Id 

1234

2346G

5673

45673C

56732

Which ever has alphanumeric ,the last string value should be replaced with blank value so that every records are INT.... Results should be like below

1234

2346

5673

45673

56732

Thank you in advance...

[loveindia]

3 hours ago, cool_dude said:

hi sql babus , i need some help 

i have table like following structure 

claim Id 

1234

2346G

5673

45673C

56732

Which ever has alphanumeric ,the last string value should be replaced with blank value so that every records are INT.... Results should be like below

1234

2346

5673

45673

56732

Thank you in advance...

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

[kasi]

[cool_dude]

On 6/4/2016 at 10:11 PM, 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

ha ha... thank you lovindia bhaiyya... will check it..Next time complex ga aduguthanu...