Viewing 15 posts - 151 through 165 (of 188 total)
Back to the original topic of this thread... And well, maybe it is this time: Do posters think we're answering bots instead of real people? http://www.sqlservercentral.com/Forums/Topic619172-1291-1.aspx. It seems he's going...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 17, 2008 at 3:44 am
david.c.holley (12/16/2008)
For the record, the discussion groups that I have been apart of do not have stringent rules as to what needs to be included and what does not....
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 17, 2008 at 3:40 am
larsosman56 (12/16/2008)
Curious why the design may be bad. I have the items in one table along with their attributes, and the way they interact with one another (hierarchies) in...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 16, 2008 at 12:06 pm
I never used TRY/CATCH in SQL, but your suggestion solution makes the TRY/CATCH kinda useless to me. So yes, I think you're hacking your code there. But where did the...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 16, 2008 at 10:36 am
larsosman56 (12/16/2008)
I can use some SQL advice with what I suspect is easy problem.
I need to insert rows of two items as a pair into a table (e.g. parent,...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 16, 2008 at 9:50 am
From my point of view, this might mean that your function always presented wrong data: the day and month are switched. Perhaps you should inform your team about this... If...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 16, 2008 at 2:53 am
That table is still relatively small, but showing 200000 records on a screen is of course useless. Is there a better way of decreasing the number of rows presented? Do...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 16, 2008 at 2:42 am
Lynn Pettis (12/15/2008)
I have also taken the time to create the scripts...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 16, 2008 at 2:26 am
sunfei0727 (12/15/2008)
1.??Sql server configuration manager,??sql nativeclient??2.???????,??tcp/ip ??????1443 ??
I like your solution, Sunfei... I wish I could read it 🙂
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 15, 2008 at 5:10 am
david.c.holley (12/14/2008)
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 15, 2008 at 4:56 am
Philip Horan (12/11/2008)
So........
1) I have been...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 11, 2008 at 6:02 am
Jeff Moden (12/11/2008)
johncyriac (12/10/2008)
Have a look at Tally/Number Table methods alsoSure... got any links? 😉 And, how do they apply for this particular problem?
Tip: add next time...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 11, 2008 at 5:43 am
After you opened the database, you do see the .ldb file in that folder though? If you open the ldb in Word (Notepad doesn't show readable text), you should see...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 2, 2008 at 7:08 am
Thanks for the table desc, but I didn't quite understand what you meant with your question. I guess Pr_RealEstateAgent_Id is the agent, and Pr_Id is the property? How is the...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 1, 2008 at 10:05 am
I took from what you wrote that if the user either have the input with or without the dash, it should give the desired result. If you want something else,...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 1, 2008 at 4:51 am
Viewing 15 posts - 151 through 165 (of 188 total)