Hi, do we need to use FOR XML PATH? I understand the concept for STUFF(), but how can i concatenate the Diagnose/Departments?

1. Open a Command Prompt by typing cmd in the search field, and selecting "run as administrator" 2. Change to the folder your files are in using the CD command (i.e. CD C:\\Users\Admin\Desktop\PDF (you can get this from the address field in Windows Explorer, highlighting it, copying it, and selecting "paste" into the Command Prompt screen. 3. Enter "Dir >" followed by <name of output text file> (i.e. dir >datasheet.txt) 4. Press Enter NOTE: if you have any spaces in the name of your output text file, you must put quotes around it, so a desired filename of 'list of article headings.txt' would be entered as "list of article headings.txt"

Exactly what I was looking for, thanks for showing

works good, thanks!

single Record with ITEM NAME='ABC' and qty=40.00 and batchno='AB04' can we multiple as per no of qty. means in report 40 record should appear for Sticker Printing

Can you tell me how to return mean multiple columns get to one column.

Speak

Worked like a charm. Thank you Mr. Patel!

Thank you!!

Great work

Pl. Zoom karo & awaz dalo

Don't think you are alone in KZbin channels

bhai thodi aur mehnat karo videos is good

a little commentary wouldn't kill you.

what if not all of my ID-s belong to multiple records? I mean I only have a few rows with the same ID, and I want to roll up only those, and the rest of them would be remain the same as before.

Thank you so much! dude!

some text instruction would have been convenient haha but this was v helpful nonetheless owo

this is called parenting right ? what you just did .. there's another option for grouping.. this didnt help man

Thank you 4 your tips maaaaaaan :-)

Thanks for your tutorial! Solved a problem for me. But it seems to me that there's room for simplifying the formula? Haven't given it a serious thought though.

Dim D1 As Integer D1 = TextBox1.Text DateTimePicker2.Value = DateTimePicker1.Value.AddDays(D1)