Viewing 15 posts - 52,381 through 52,395 (of 59,064 total)
One more thing... the ticketing system should have the concept of "Parent Tickets" and "Projects" associated with it. Seriously, this is the only way to keep a handle on...
February 21, 2008 at 7:12 pm
Eric Peterson (2/21/2008)
We need to better document user requests comming into the system and a good...
February 21, 2008 at 7:10 pm
Gosh... can't you just make a linked server and write a proc that would maybe use a little dynamic SQL to just copy everything it sees on the linked server...
February 21, 2008 at 7:02 pm
Yes, you can save the result set in a table by using a kind of "back door" way using a call to OSQL....
--===== Create a temp table to hold the...
February 21, 2008 at 6:51 pm
Yeah... I know, I know... thanks guys...
Sticknyn... don't let them scare you off, Man... if you know a way to pass a table variable in 2k5, you've just gotta tell...
February 21, 2008 at 6:25 pm
stricknyn (2/21/2008)
I can pass a table variable into a stored procedure that has a table variable as a parameter.
You can? And it works? Would you mind...
February 21, 2008 at 5:43 pm
All I can say is, CRAP!!!!!
As pjancicka states, it works fine on 2K SP3a, and doesn't work correctly on anything after that!
Hey! Some of you MVP's...
February 21, 2008 at 5:20 pm
Myschif,
Adam and the other folks are too kind with their words about my articles. The articles do, however, explain some major pitfalls with the performance of some of the...
February 21, 2008 at 4:11 pm
I saw you in the post, Adam... I knew you would do as good as I could. And, thanks for the plug!
February 21, 2008 at 4:02 pm
Shiv (2/21/2008)
I have given that direction as parameter bcos i want use it like a condition there. That's not problem I can just keep 'queryout' there directly instead of direction...
February 21, 2008 at 11:52 am
Matt Miller (2/21/2008)
February 21, 2008 at 11:50 am
Heh... sure you did... you learned that there's more than one way and that one of the ways will be easy. 😀
February 21, 2008 at 5:24 am
I understand... if "every code change can be acceptable", then consider implementing that which is found at the following URL:
February 21, 2008 at 5:12 am
What is the exact wording of the error?
February 21, 2008 at 4:22 am
Yeah... it's a simple "Name/Value" table that can easily resolved using various high performance methods (none of which require a CLR) including simple cross-tabs. What kind of an error...
February 21, 2008 at 4:20 am
Viewing 15 posts - 52,381 through 52,395 (of 59,064 total)