Viewing 15 posts - 54,646 through 54,660 (of 59,078 total)
I'd like to know why the hell you have letters in the NPA column. 😉
October 11, 2007 at 8:34 pm
Search for "hierarchy" on this forum... also lookup "expanding hierarchies" in Books Online. Because you're using 2k5, you may want to add "CTE" to your search criteria.
October 11, 2007 at 8:26 pm
Title of this thread is "I just want to do my job!".
Have you figured out what "your job" is, yet? I think you would become bored if you just...
October 11, 2007 at 8:10 pm
Jack Corbett (10/8/2007)
October 11, 2007 at 7:49 pm
luissantos (10/11/2007)
Sorry, if i send you this post , but i send to you a private message and i know if you will receive them, so i attache...
October 11, 2007 at 7:47 pm
Please see the following for how to resolve this problem...
http://www.sqlservercentral.com/Forums/Topic296166-8-1.aspx#BM296961
October 11, 2007 at 7:41 pm
You've managed, quite nicely, to build a partially exclusive Cartesian Join known as a "double triangle" join. Please see the following post...
http://www.sqlservercentral.com/Forums/Topic359124-338-1.aspx#bm360151
You need some other criteria, hopefully and equi-join,...
October 11, 2007 at 7:29 pm
Hi Greg,
I don't know if Belution is kaput or not... I've seen them go down for several weeks only to rise again. Looks pretty bad this time, though... haven't seen...
October 11, 2007 at 6:09 pm
Well sure it does, Ken... how else are you going to "step through the databases"? sp_ForEachDB??? That's got dynamic SQL and cursors, too!
October 11, 2007 at 6:16 am
Heh... yeah... several solutions similar to that were posted.
The remaining question I have is, what will this be used for? Without knowing were the decimal point WAS... the information...
October 11, 2007 at 6:02 am
... and that was my point... not all Dynamic SQL is bad nor even indesireable.
October 11, 2007 at 5:56 am
So far, nobody can explains to me that my original query with INNER JOIN doen't works and without INNER JOIN, works very nice.
... and you haven't posted the real life...
October 10, 2007 at 5:21 pm
Please provide the code and data that demonstrates when the correctly specified Update and Index fails. Then provide your correct Order By method that solves the problem.
October 10, 2007 at 7:18 am
The code you have is the classic code necessary to put records together from multiple rows in a name/value table. It's actually pretty darned fast... only thing faster would...
October 10, 2007 at 6:41 am
Sarvesh,
First... when you get an error, you need to post it so we can see what's going on.
Second... are you actually using SQL Server 2005?
October 10, 2007 at 6:29 am
Viewing 15 posts - 54,646 through 54,660 (of 59,078 total)