Viewing 15 posts - 4,306 through 4,320 (of 15,381 total)
jbalbo (6/26/2014)
I have a table(Comments)
two columns clientno and comment
one clientno can have many comments
I want to merge all the comments for one clientno in a new field
example
clientno ...
June 26, 2014 at 7:24 am
You are going to have to provide some of the business rules. Simply pasting a portion of some code is not going to cut it. It appears from the code...
June 26, 2014 at 7:21 am
reliableitservice (6/25/2014)
I want to thank you for your help!!I already apply this to the LIVE environment and is working like a charm!!!!!
THANK YOU SO MUCH!!!!
RITS
Glad you got it working. More...
June 26, 2014 at 7:10 am
jcrawf02 (6/25/2014)
Sean Lange (6/25/2014)
Lynn Pettis (6/25/2014)
Sean Lange (6/25/2014)
Ed Wagner (6/25/2014)
Koen Verbeeck (6/25/2014)
Ed Wagner (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
ChrisM@Work (6/25/2014)
djj (6/25/2014)
June 25, 2014 at 2:39 pm
reliableitservice (6/25/2014)
Thank you for your response.
The ROW_NUMBER can't be used. The "340" is a value that will change every time this script is used, furthermore this will be entered...
June 25, 2014 at 2:32 pm
itortu (6/25/2014)
Here is some output I verified for some customers.
Customer NumberAverage Days To Pay1000234
100031
1000639
1001447
1001994
1002012
1002223
1002325
10024-2
1002654
1002717
100310
1003939
1004122
1004254
I hope this is good to get help for solution.
I truly appreciate your willingness to help.
Boy...
June 25, 2014 at 2:19 pm
reliableitservice (6/25/2014)
For results, I would like to prompt the user to enter the "HANDLE" and the "Start Invoice #", the script will
search for and...
June 25, 2014 at 2:09 pm
Welsh Corgi (6/25/2014)
They tell me know that they do not use the...
June 25, 2014 at 2:05 pm
itortu (6/25/2014)
I fixed the data.
Now if you can post what you expect as output we can get started on working on a solution. I think we should reduce the amount...
June 25, 2014 at 1:57 pm
Alan.B (6/25/2014)
Sean Lange (6/25/2014)
Alan.B (6/25/2014)
First: Dang it Sean - you beet me to it! I had a very similar solution but you posted yours first. That said, I did do...
June 25, 2014 at 1:53 pm
Denise McMillan (6/25/2014)
But I'm not calling a funtion with...
June 25, 2014 at 1:49 pm
Welsh Corgi (6/25/2014)
What enhancements have been to the 2012 GUI (Client only) that facilitates faster coding, etc.?I appreciate you feedback.:-)
Faster coding would be achieved by not using the GUI for...
June 25, 2014 at 1:36 pm
Lynn Pettis (6/25/2014)
Sean Lange (6/25/2014)
Ed Wagner (6/25/2014)
Koen Verbeeck (6/25/2014)
Ed Wagner (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
ChrisM@Work (6/25/2014)
djj (6/25/2014)
June 25, 2014 at 1:13 pm
eng.sarah.kandil (6/25/2014)
Thank you very muchI uninstalled the express edition and installed the enterprise one and I was able to attach my database 🙂
Thanks again
You are welcome. Glad you were...
June 25, 2014 at 1:09 pm
Viewing 15 posts - 4,306 through 4,320 (of 15,381 total)