Forum Replies Created
Viewing 15 posts - 2,836 through 2,850 (of 7,503 total)
-
RE: To insert a value from a table into a warning statment
did you try a joined solution like ...
Update A
Set RptStatement = ' watever you ' + C.comapnyName + ' @' + cast (year(getdate()) as char(4))
from...
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: Agent start on one cluster node, not the other
can you attach a sqlagent.out file that came from the (failed) start of the troublesome node ?
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: Raw Materials - The Decision
It's a shame Raw materials is about to be ripped from our daily relief.:crying:
Can't they just turn it into a flipover kalender (you know, this kind thing
)Many times,...
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: Are the posted questions getting worse?
GilaMonster (9/16/2010)
Combine this and the BIT thread and I'm just about ready to throw in the towel.I can understand this feeling .... :crying:
On the other side ... altough they came...
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: Are the posted questions getting worse?
Paul White NZ (9/15/2010)
Chad Crawford (9/14/2010)
If only you and DEAD people can read Hex, how many people can read Hex?Don't know. But I do know what an expired...
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: Patients who come in within 14 days
The easiest way to find out is to actually run the query and use the returned results to check for correctness using the subquery.
You'll only get comfortable with sql by...
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 move the SQL server table insert rows from test server to Prod server
-If you have BIDS you can just create a new integration server project and compose the stuff you want to using the import/export wizard.
-You could also just use SQLCMD to...
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 move tables, indexes & Logs from one disk to another disk drive
have a look at this SSC article http://www.sqlservercentral.com/articles/Administration/65896/ and see if it fits your needs.
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: Patients who come in within 14 days
With the extra "exists" clause it checks for existance of _any_ data in the query within the brackets.
Because I'm using a Correlated Subquery (check Books Online (bol) for "Correlated Subqueries")
I...
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: Are the posted questions getting worse?
Brandie Tarvin (9/15/2010)
All this talk about the "rankings" makes me want to know what they are and how many points or posts it requires for each one.Is it posted somewhere...
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: Patients who come in within 14 days
If this is for homework, please mention the url as a ref 😀
use mfCarlRepos
SELECT crn
, admission
, admdate
...
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: Index creation after of before populate?
Any partitioning involved ... search BOL for "sliding windows"
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: Are the posted questions getting worse?
GilaMonster (9/14/2010)
Grant Fritchey (9/14/2010)
The Dixie Flatline (9/14/2010)
There are two types of people in the world. Those who can see what's coming next.And...
And you're obviously one of those...
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: Database Mirroring - Witness
As traced, not all stuff is traceble ....
Select *
from sys.database_mirroring_witnesses
order by database_name, principal_server_name;
This dmv contains the witness info.
IMO it is fed behind the scenes.
You'll only see the dbmirroring...
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: Database Mirroring - Witness
I think the best way may be to trace the witness at mirroring setup time and during a normal witness removal operation.
This way you may be able to find out...
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 - 2,836 through 2,850 (of 7,503 total)