Viewing 15 posts - 1 through 15 (of 16 total)
I tried to get a UNC that I can use to point to a csv file on the root of my website but my webhost said I cannot do that...
June 15, 2010 at 8:30 pm
Tough love... you can't beat it 🙂
I guess I was dragging my feet a little because I find correlated queries a bit intimidating but you were right, Lynn....
June 23, 2009 at 7:51 pm
Thank you RBarry and Lynn for your solutions. I apologize for the mismatch in the table name between DDL and DML for table InsuranceClaim. I was expecting the...
June 23, 2009 at 5:34 pm
Chris -- The LEFT JOIN improved the execution time astronomically.. really, it went down from about 30 seconds to about 1 second. Thanks!
Lynn and Gail -- I'm having trouble...
November 12, 2008 at 1:31 pm
Mark,
That looks exactly like what I need!
Thanks,
Ahmet
October 28, 2008 at 8:36 am
Here is how I'd like to see my output (Sorry I couldn't line up the columns better, but I hope you get the idea). In this sample data, employee...
October 28, 2008 at 8:30 am
Our guys are getting pretty good about clocking out. Occasionally we have employees doing double shifts -- that's what causes the multiple rows for the same day/same employee.
October 28, 2008 at 7:28 am
Thanks for your suggestion, Seth.
It works beautifully unless an employee has clocked in & out more than once on a given day -- I realized last night, while I was...
October 28, 2008 at 5:59 am
Excellent. Now I get it.
Thank you both.
September 24, 2008 at 5:50 am
Thanks for your response!
Does anyone know how to pass a null value from a Crystal Reports parameter into an SQL query? I can pass numeric values but not sure...
September 23, 2008 at 1:23 pm
Thanks Stephanie.
I'll make the change.
June 19, 2008 at 10:31 am
I'm still testing but I believe I have a solution thanks to all your suggestions -- especially Jeff and Stephanie (many thanks). The reason I was trying to represent...
June 19, 2008 at 8:49 am
Stephanie Giovannini (6/16/2008)
I have copied queries directly from Jeff Moden's article at:http://www.sqlservercentral.com/articles/TSQL/62867
and modified them to suit this purpose.
Great stuff!
I'd still like to modify this so the rep codes...
June 18, 2008 at 6:39 am
Can someone post a code sample that shows a query working with two databases simultaneously?
June 17, 2008 at 6:06 pm
Thanks to all for your responses!
Once my head stops spinning I may have a follow up question but for now I need to get a bit more comfortable with...
June 17, 2008 at 12:56 pm
Viewing 15 posts - 1 through 15 (of 16 total)