Forum Replies Created
Viewing 15 posts - 6,841 through 6,855 (of 7,499 total)
-
RE: Conditional UPDATE statement
How about :
alter the insert statement :
INSERT #temp
(
Fiscal_Yr_Ending,
Fiscal_Period,
Trans_Amount,
Acct_ID
)
SELECT
t.Fiscal_Yr_Ending,
t.Fiscal_Period,
sum( CASE WHEN tl.Trans_Type = 'D' THEN (tl.Trans_Amount * -1)
ELSE tl.Trans_Amount END ) Trans_Amount,
tl.Acct_ID
FROM
Transactions t JOIN Transactions_Line tl
ON t.Trans_ID = tl.Trans_ID
group...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: SQL Server Error: 18452 Not associated with a ...
Is there a windows thrust ?
To test :
1) map a new drive at the client to a disk(or test-share) of your sqlserver and use your own windows account (not the...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Update Table based on a join with the existing table
UPDATE det
SET SFDT_QtyMonth1=tmp.TMSF_QtyMonth1,
SFDT_QtyMonth2=tmp.TMSF_QtyMonth2,
SFDT_QtyMonth3=tmp.TMSF_QtyMonth3,
SFDT_VendRemarks= tmp.TMSF_VendRemarks,
SFDT_VersionNo=SFDT_VersionNo+1
from OPT_SalesForecastDetail det
inner join OPT_TmpSalesForecast tmp
on det.SFDT_SalesPlanCode='SF012005GEN0031'
AND tmp.TMSF_PackCode = det.SFDT_PackCode
WHERE (tmp.TMSF_QtyMonth1 <> det.SFDT_QtyMonth1
OR tmp.TMSF_QtyMonth2 <> det.SFDT_QtyMonth2
OR tmp.TMSF_QtyMonth3 <> det.SFDT_QtyMonth3
OR det.SFDT_VendRemarks <> tmp.TMSF_VendRemarks)
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Process Not Ending
Thanks for the feedback.
Glad you've solved it.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Automating sql scripts
check out http://www.sqldts.com.
There are a number of scenario's that may apply.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Process Not Ending
So there is the problem.
I didn't encounter such a situation yet.
What's the sql-version/sp / hf ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Process Not Ending
Did you run the @Cmd in a cmd-box for test ?
I guess it gives a popup at serverside
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Using CASE to UPDATE a column
Is this what you're looking for ?
I prefer using Left outerjoins because I find them to be more readable.
I also like using objectaliases...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Error 8646?what is the result to this problem?
your problem object :
select object_name(71577680)
Your problem index :
Declare @Name varchar(128)
select @Name = object_name(71577680)
exec sp_helpindex @Objname = @Name
I would run :
DBCC CHECKDB ( 'yourdb') WITH ALL_ERRORMSGS
check BOL for...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: T-SQL question
there are # of ways to do this. This is one of them :
how about : (#tmp1 is your table)
create table #tmp1 (id...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Question about Optimizations
I switch all db's to "bulk logged" in the first step of the maintenance job (dbreindex/indexdefrag).
then perform maintenance
then switch back to "full" when needed
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Tables Have Been Deleted
'create date last month...' can be when you alter the table e.g. using EM. It has the tendency to use a ddl sequence of rename - create - insert -...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Help with setting up a job
that way your usp_ only returns a value.
use raiserror of you want to have an error raised and set the jobstep's "on error" action to "quit job with failure"
Check BOL.
e.g....
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: How to setup DB Backup to network device for Active-Active SQL Cluster
SQL2005 ? or wrong forumgroup ?
SQL2000 : make sure your sqlserver / sqlagent serviceaccout has got the needed authority for your network-shares.
This job...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Help with ambiguous term
Try to alias the tables and you'll find your problem easy so solve.
select MyAlias.mycol,...
from myschema.myverymeaninglesstablenamefartolongtoread MyAlias
...
if you still cannot find it, post...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 6,841 through 6,855 (of 7,499 total)