Viewing 15 posts - 2,506 through 2,520 (of 4,080 total)
No data to test with from you, so I don't even know if your code will run, but let me ask why is this in your code?
(
SELECT ordername, ordertype, ordernumber
FROM...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2009 at 5:49 pm
nroudak (8/26/2009)
truly sorry for making you angry ... I just couldn't paste real servers and db names (sensitive), besides it wouldn't help anyway ..
I'm no longer angry, but that's an...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2009 at 4:51 pm
select convert(varchar(8),getdate(),112)+'_test.csv'
The statement above will produce the correct file name for today's date.
What is "that day"? The file with today's...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2009 at 4:40 pm
You're welcome.
If I may make a suggestion for the future: Whenever I am working with dynamic SQL, I never begin with trying to execute the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2009 at 4:33 pm
[schema].
You have a table named this in every db on every server?
You have a table named this anywhere?
What you typed in was:
[server].[database].[dbo].
That wouldn't work either,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2009 at 3:52 pm
Can't get there, Lynn. I just came close to calling an OP a liar. My patience is exceedingly thin today.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2009 at 3:50 pm
Recursive Function
That's probably your problem with performance, right there.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2009 at 3:37 pm
insert into #FT_FinalAmts(specimen, SG_Great_Less, Creat_Great_Less, PH_Great_Less)
select specimen, coalesce(SGgreat,SGLess), coalesce(creatGreat,creatLess), coalesce(phGreat,phLess)
from #FT_GreatLessAmts
ISNULL() would work too, in this instance.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2009 at 3:35 pm
my problem is just that....
select @SQLstr
produces almost exact line:
SELECT @myVarOUT =someValue FROM [server].[database].[dbo].
WHERE someName = [@myName]
It does not. You did not do as I requested. You...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2009 at 3:18 pm
Thanks for posting back, Peter. Your results make sense when I look at them now. Still using my creaky old laptop, I'm seeing the following times...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2009 at 11:55 am
In the meanwhile, here's a hint:
You are putting '[schema].' in as a constant, instead of using two variables to supply the schema name and the name...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2009 at 10:50 am
Please, let us see the value you are building:
-- add this statement and rerun your code, then paste the printed results back here.
PRINT @SQLstr
EXEC sp_executesql @SQLstr, N'@myVarOUT...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2009 at 10:46 am
Since Flo brought up the TVF approach, I want to ask. Can anyone point me to documentation about the performance of TVFs v stored procedures? ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2009 at 10:12 am
print @@error ????
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2009 at 9:35 am
Hi, Flo. Nice to "see" you again. Hope all is well with you.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2009 at 6:32 am
Viewing 15 posts - 2,506 through 2,520 (of 4,080 total)