Viewing 15 posts - 49,681 through 49,695 (of 59,078 total)
Then what in the application is giving you the offset of either 5 or 6 hours? Could it be that all the times are assumed to be GMT and...
June 25, 2008 at 5:23 pm
Stephanie Giovannini (6/25/2008)
Jeff, I like your schema better. Thanks for clarifying how phone numbers and addresses are ideally stored.
Heh... not sure it's the "ideal" way to do it, but I...
June 25, 2008 at 5:16 pm
Since Oracle 8.3, you also can use Case... 😉
June 25, 2008 at 5:08 pm
Good code... but be careful when you get a lot of rows or the groups of rows become large. Take a look at the following article...
http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
June 25, 2008 at 3:48 pm
R L Reid (6/25/2008)
June 25, 2008 at 3:36 pm
The best thing to do, in most cases, it to avoid any kind of function and any kind of correlated sub-query including Cross Apply. Yeah, I know... I'm going...
June 25, 2008 at 3:29 pm
Very good article... you did a heck of a good job on it. 🙂
Just a couple of observations...
You did all of this just because BCP won't export column headers......
June 25, 2008 at 3:10 pm
Wow... lots of RBAR there 😀
For starters, you can replace the following WHILE loop...
declare @cnt int
declare @UnitCount int
set @cnt=1
set @UnitCount=1
while @cnt<len(@s_Table_PkgNumber)
begin
if(substring(@s_Table_PkgNumber,@cnt,1)=', ')
begin
set @UnitCount=@UnitCount+1
end
set @cnt=@cnt+1
End
... with this...
SET @UnitCount = LEN(@s_Table_PkgNumber)-LEN(REPLACE(@s_Table_PkgNumber,',',''))+1
That one...
June 25, 2008 at 7:31 am
Darned forum... please replace the smiley faces in the code with right parenthesis...
June 25, 2008 at 7:12 am
Here's an example of what I'm talking about... go look at the nightmare code behind sp_MsForEachTable and sp_SpaceUsed... both can be replaced with this relatively simple and very fast...
June 25, 2008 at 7:11 am
sp_MSforeachtable is nothing more than a cursor/RBAR on steroids...
June 25, 2008 at 7:06 am
habib_nub (6/25/2008)
i want to insert multiple data into multiple tables column
You need to include a wee bit more info about what you want to do than that. Otherwise,...
June 25, 2008 at 6:51 am
Sorry... you are talking about "Table Variables"... best to look up about those in Books Online and take a look at the following article...
June 25, 2008 at 6:47 am
Change the default setting will likely open a huge can of worms for you... lot's of other folks code depends on NULLs not being equal to anything and changing that...
June 25, 2008 at 6:45 am
That's what happens when you "send" it to just one person, Venki... why don't you post the procedure here so we can all lend a hand... 😉
June 25, 2008 at 6:40 am
Viewing 15 posts - 49,681 through 49,695 (of 59,078 total)