|
|
-
Madhivanan Replied 12 Months ago through ASK | 1 Point
Are they in the middle of the string? Can you post some sample data and expected result?...
![]()
|
0
·
0% ·
0
|
|
-
Madhivanan Commented 12 Months ago through Ask | 10 Points
Are they in the middle of the string? Can you post some sample data and expected result?...
|
-
Madhivanan Replied 12 Months ago through ASK | 1 Point
What characters do you want to detect?
This may be a starter
Where col like '%[^a-b0-9]%'...
![]()
|
0
·
0% ·
0
|
|
-
Madhivanan Commented 12 Months ago through Ask | 10 Points
What characters do you want to detect?
This may be a starter
Where col like '%[^a-b0-9]%'...
|
-
MadhavanM Question Received 12 Months ago through ASK | 1 Point
HI Madhivanan,
I m trying to find the column which is having any ASCII value.
column type is VARCHAR2 and NOT NULL. Please help me resolve....
|
-
Madhivanan Replied 12 Months ago through ASK | 1 Point
See if you can apply this logic
http://beyondrelational.com/modules/2/blogs/70/posts/10840/dynamic-pivot-in-sql-server-2005.aspx...
![]()
|
0
·
0% ·
0
|
|
-
Madhivanan Commented 12 Months ago through Ask | 10 Points
See if you can apply this logic
http://beyondrelational.com/modules/2/blogs/70/posts/10840/dynamic-pivot-in-sql-server-2005.aspx...
|
-
Guru Samy Question Received 12 Months ago through ASK | 1 Point
Hi Madhivanan,
I have one doubt the one task in SQL Query, so can please suggest me.
Table name is :TblMarkList
Sample Data:
MID RollNo SubjectID MaxMarks ExamDate Marks
1 12345 Sub01 100 05/04/2012 50
2 23456 Sub02 100 06/04/2012 60
3...
|
-
Madhivanan Replied 1 Years ago through ASK | 1 Point
Use dynamic sql with the code shown here
http://beyondrelational.com/modules/2/blogs/70/posts/10792/importexport-to-excel.aspx...
![]()
|
0
·
0% ·
0
|
|
-
Madhivanan Commented 1 Years ago through Ask | 10 Points
Use dynamic sql with the code shown here
http://beyondrelational.com/modules/2/blogs/70/posts/10792/importexport-to-excel.aspx...
|