Forum Replies Created
Viewing 15 posts - 6,841 through 6,855 (of 7,502 total)
-
RE: ODBC
yep, I noticed I'd forgotten to mention 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: ODBC
rs12.ActiveConnection = "dsn=IMMDATA;uid=sa;"
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: Calculating number of seconds
I suppose you mean e.g. you have used us-insert time of a row and now you want to calculate the insert delay (network) ?
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: 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
Viewing 15 posts - 6,841 through 6,855 (of 7,502 total)