Comments by Naga Sindhura (Top 88 by date)

check for other constraints exists in BTU_MISReport table. because above solution perfectly works for altering a table column datatype as follows
ALTER TABLE BTU_MISReport
ALTER COLUMN ADDRESS NVARCHAR(MAX);

syntax errors will always points to staring line of the code base. check-it once again.

use alias name to select the column and will avoid Ambiguous column errors.
like - kolicina exists in AllTables table the change your select as AT.kolicina : to SUM (cast(AT.kolicina AS float)) AS 'Prodata kolicina'

it worked in the way he asked but small suggestion MAX(COALESCE(age,1)) needs to be replaced with MAX(COALESCE(age,0)). I know that that up to the business requirement. What do you think?

if you need one more entry like mentioned in Solution 4. Please refer that solution

syntax error in the select statement. So try this:
DECLARE @testdata TABLE (belowthen2 INT, between2and5 INT, above5 INT)
INSERT INTO @testdata(belowthen2, between2and5, above5)
SELECT 1,3,6 UNION
SELECT 3,3,6 UNION
SELECT 1,6,6

select belowthen2, between2and5, above5,CASE WHEN (belowthen2 < 2 and (between2and5 between 2 and 5) and above5 >5 ) THEN 'Above' ELSE 'Below' END as STATUS
FROm @testdata

if the issue got fixed this then thats fine otherwise you need to look at your from and where part as well

Agreed.. But small correction ...varchar(10) mentioned in the Problem Statement itself.. I know it is wrong as you mention earlier..

How data in name field stored in?
for 'harsh,suresh, mohan' condition - three different records- one for harsh, other for suresh, And, one more for mohan.
/Or harshsureshmohan /or something else
Please post your comment?

may be her intention is SELECT REPLACE(@emp, ',','') not SELECT REPLACE(@emp, ',','','')

try to change the from part as follows:

from tbl_Stock_Journal SJ
INNER JOIN tbl_item AS i1 ON i1.itemid =SJ.SJItmID
inner JOIN tbl_Stock_Journal_Details AS SJD ON SJ.SJID = SJD.SJID AND SJd.SJdItmID = i1.itemid

If it does work, try to post some sample data.

AT and BT are two fixed vales in ColB? What if you have the following combination? That time will you go for the CT, DT,...? First check other dependencies where you can decide perfect combination like for AA use AT, And, for BB use BT... may be some table to decide this combination at runtime if you don't have fixed combination.
ColA ColB
CC C01
CC C02
CC C03
CC C04

check this one once. It may help you.
https://stackoverflow.com/questions/17571233/how-to-change-schema-of-all-tables-views-and-stored-procedures-in-mssql

Agreed to your Explanation -
Here he/she needs to define/alter the tables structure in the following way:
1. Student table
-StudentID(PK)
-StudentName

2. Class table
-ClassID (PK)
-ClassName/Room Name

3. StudentClass - for Normalization
-StudentID(FK)
-ClassID (FK)

4. Subject - Table
-SubjectID(PK)
-StudentName

5. ClassSubject - Table
-ClassID (FK)
-StudentID(FK)

6. Teacher - Table
-TeacherID(PK)
-TeacherName

7. TeacherSubject - for normalization/mapping
-TeacherID(FK)
-SubjectID(FK)

First insert the records into following Core table:
1. Student
2. Class
3. Subject
4. Teacher
And then insert into the following mapping table:
1. StudentClass
2. ClassSubject
3. TeacherSubject

i.e. core tables first and then add the data into the reference tables.

one more thing master.dbo.spt_values table to repeat the columns for n times

CREATE TABLE RepeatRows (
Id int identity(1,1),
RepeatText varchar(100),
RepeatCount int
)
INSERT INTO RepeatRows SELECT 'Repeat 3 Times', 3
INSERT INTO RepeatRows SELECT 'Repeat 2 Times', 2
INSERT INTO RepeatRows SELECT 'Repeat 4 Times', 4
INSERT INTO RepeatRows SELECT 'Only once', 1

SELECT t1.*, t2.number + 1 RepeatNumber
FROM RepeatRows t1
JOIN master.dbo.spt_values t2 on t2.type = 'P' and t2.number < t1.RepeatCount

try to use auxillary table table mentioned in the following link.
https://stackoverflow.com/questions/33327837/repeat-rows-n-times-according-to-column-value

sys.columns and sys.systypes are tables

under your schema, Try to use to query with sys.columns to extract columns information and sys.systypes for data type. xtype or system_type_id 104 is for bit. I hope this will help you..

client won't allow us to install new font typesin report servers.

I applied the following permissionsets, but still I am getting similar error message.
var newPer = new PermissionSet(PermissionState.Unrestricted);
newPer.RemovePermission(typeof(FileIOPermission));

after removing appDomainSetup,permissionSetup from AppDomain.CreateDomain, dll could create the files where ever I mention like including C:\Users\UserName\Desktop\, its not restricting any paths of my local Machine.

No Its not. I could not restrict the one which I wants to.

yes, like C: drive or some other one.

I have changed my code from var generateFilesAppDomain = AppDomain.CreateDomain(
generateFilesPluginPathName,null,appDomainSetup,permissionSet); to generateFilesAppDomain = AppDomain.CreateDomain(generateFilesPluginPathName), however, I need to restrict the domain execution with some sort of permission like not access with C drive or some sort of sensitive paths. How could I do that one? any suggestions.

Sure thanks, I will look into it. I have tried to load the dll in AppDomainSample -> Main() method using the following code and is working without any issues, but I could not load it through thrirdPartyDomainLoader instance. Do you think, still is this an issue with permission issue or wrong code.

var assm =
Assembly.LoadFile(
@"D:\DotNetTraining0504\AppDomainSample\GenerateFilesPlugin\bin\Debug\GenerateFilesPlugin.dll")
.GetType("GenerateFilesPlugin.GenerateFiles");

Hi Kornfeld Eliyahu Peterб

Yes you are true, I don't have local admin permissions and even switching user is also not possible. However, I have added the following lines in my app.config but I could see the similar error message like earlier.
<system.web>
<trust level="Full"/>

"xmlns="http://library.by/catalog" is in Russian language. Will it effect my code?

Hi FranzBe,
When I serialize the declared object and then Deserialize then it is working as expected. However, I have modified the code as follows but still I am getting the same error @ "return (T)serializer.Deserialize(myStream);" line.

string path = @"C:\temp\books.xml";
StreamReader reader = new StreamReader(path);
string s = reader.ReadToEnd();
reader.Close();

Catalog deserializedCatalog1 = Catalog.XMLDeserialize(s);

Along with that I have corrected the Genre property to XMLElement.

Is there any alternative to achieve this? or is possile with NEWSEQUENTIALID if we alter the table?

I am not a stupid to ask silly questions like you feel. I struggling to implement edit/update operation in boilerplate from 1 week. If can able to answer it please do post it. If not please delete the comments posted by you so that it won't give wrong direction to the people if they really wants to.

Hi, you are not understanding my question at all. My question is about ASP.NET MVC5 boilerplate? Please keep your words before posting anything.

Yes your point is correct. I am not able to find proper documentation that why I posted this question. I have gone through the so many articles no one gave sample example to do edit function. Along with that, I have gone through the entire documentation of the boilerplate even there they didn't mention proper flow to develop for edit example.

select SKU,PRODUCTNAME,PRODUCTVARIANT from tbl_product where product in(SELECT * FROM STRING_SPLIT('ewew,slk,ewew',','))
STRING_SPLIT only works when you have SQL SERVER 2016

UsrMain table is in LEFT JOIN. However you have used UsrMain.id= 'T89387' is in the where clause which means the code internally treat that as INNER JOIN/ JOIN and one reason is CssRplOutboundPackageInfo.WorkState='Initial' don't have any records if this is the case then you need rewrite the code to by marking CssRplOutboundPackageInfo in left join.

I am using IE9 for my testing purpose. Can please suggest any imageslider, that should support by the all the browsers.

Hi Nirav, Here is my code,
<head runat="server">
<title></title>
<script type="text/javascript">
function settext(valueData) {

document.getElementById('<%=Label6.ClientID%>').innerHTML = valueData;
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<p>text </p>
<asp:textbox id="txtbox1" runat="server" onkeypress="settext(this.value)" >

<asp:Label ID="Label6" runat="server">

</div>
</form>
</body>
</html>

Sorryy to ask now,
The output i am getting here is one char back,
like if I enter "Hello", In my label it is displaying as "Hell".
How can I solve this.

Hi Sarah, Please mention your requirement exactly with Expected output.

I am ok with your point. However for same application with less records that is fine right. Alternatively we can use indexes on columns if there are many records.

please try to do debug, then you will know exact reason. However whatever you saying is correct.

getdate()is not a problem that is working fine for me.

Hi, As per understanding you are getting error, please try to debug your code and identify the error. Check your password length because you are convert it to hash and then you are saving. Your code is Working for me.. :)

Hi Richard MacCutchan,
Initially i tried with the code,
lblQues.Text = String.Concat("What is my <a name ='test' id='lnkMe' runat="server" href='#' >anchor name?");
here I am not able to get the control. so tried to add HtmlAnchor tag(both on page load).
I tied in this way that is not working or me. Is there any alternative to get the id's of all anchor tag.

Actually I assigned Id as 'anchor' to htmlAnchor. while getting that id i got an error at c.ID.

Hi Richard MacCutchan, i tried to get id name of all htmlAnchor using Type. Actually that is not required.

Hi Richard, I initialized a vale for string ids,still i am getting an error.

hi, globally i created variable for ids as string. i am getting an error because of c.ID.

hi, i am getting an error (ids = ids + " " + c.ID;) because o c.ID) could you help me for this

here ids reers to htmlAnchor.ID = "anchor"; that means all htmlAnchor id's

Thankyou SambasivaRaoG

code ni use chesi get chesukovali nenu direct ga kadu. and na output "lnkMe" ani ravali

u r correct. Miru chepina code naku work avuthundhi, kani naku anchor tag id ni get chesukovali adi ela?

vachu. na question enti ante oka label lo anchor tag undi. button click chesinappudu a anchor tag id result ga ravali.

Hi,i am not able to solve my solution.

Hi SambasivaRaoG,
In my problem i need to get id of anchor tag. No need to assign assign any thing.
from the first label i need to get id and that id should display second label on button click. Please help me for this.

Hi SambasivaRaoG,
I am not able to get the id of my anchor tag.

Hi SambasivaRaoG,
I need to implement this code Using Labels and my output is id of the anchor tag.

Hi Richard,
You are Correct.
Actually my problem is, implement a basic Calculator program using design patterns. i am new to design patterns. i don't know how to proceed.
I implemented code to develop the Calculator with the help of this link( http://code.msdn.microsoft.com/windowsdesktop/Simple-Calculator-54ec8e4a ).
Please suggest how to proceed.

Hi BillWoodruff,
No Parameters passing from or to WhoIsCallingMe() method.

Hi navin,
Your Query is working fine in webapplication, i want to same result from my Console Application. Is there any way to proceed?

i am not getting any error

thank you Tadit.

Hi Tadit, it's really helpful to me. I worked with this functionality it working fine in IE. The bottom right corner icon is showing outside of the div, Is the there any alternative showing slashes inside the div?

thank you, and sure Tadit Dash

Hi Tadit, thanks for your reply. the textarea showing browser compatibility issue with IE. When user trying to drag textarea using bottom right corner icon it showing in chrome and other browsers not in IE(it showing vertical scroll bar). what i have to add resolve browser compatibility issue with textarea?

yes, about the code.

Hi ridoy i am getting data from my database, however i don't have null values in my database.

through trirand it's working. However i have to implement with the freeware.
I am getting data from DataBase. properbinding is not hapening ,it is displaying empty data.
Iam getting problem with Request.InputStream. showing null values

Hi Roshith,
i am getting problem with Dictionary<string,> dict = jser.Deserialize<dictionary><string,>>(json); especially second argument. How can i resolve it. Is there any alternative be add?

Hi, how to apply same property on tabs ?

Hi when i trying to get jqgrid ID, i am geeting like 1 1,2 1,2,3 ... like that
using var containerId = jQuery("#list").jqGrid('getDataIDs'); code.
how can i get individual row ids like 1 2 3 .. on each iteration .

I need to implement these things with out commercial websites(like free ware).

hi Sampath,
Thank you for sharing that link. For the custom colors it working fine.

However when i am trying to edit the date using "http://www.trirand.net/examples/grid/editing_data/custom_edit_buttons/default.aspx" i am not getting any hyperlink for edit, save and cancel. i am not able to under stand exact problem. One thing i know is, in JQGrid1_CellBinding i am getting underline for edit, save and cancel. i don't think it make sence in my problem. Can you suggest anything about this problem?

correct, can you same implementation using asp.net web application/website

i tried to implement grid with help trirand. Here i am unable to customize the colors of jqgrid.

for this requirement not needed.

i wanted to implement this one using c# or dos command.

Hi, through command prompt it's working fine, however i wanted to restrict some files like .exe from source to target. How can we do this using robocopy.

Reason for my vote of 5 \n the way of implementation is useful to me, but i am getting confusion like "why to implement a jquery grid without using GridView?".

Hi ridoy,
i have implemented using asp.net web site not using web form.
can you clarify for this also.