Viewing 15 posts - 15,946 through 15,960 (of 18,926 total)
You don't make it count down. Add a datefield with default getdate().
Then the query would be something like this :
Select * from dbo.MyTable where DateField between dateadd(HH, -2,...
June 30, 2005 at 7:07 am
This is something I did for someone who wanted to find the unused dbs in its mssql/data directory.
You should be able to adapt this script yourslef :
--list the database...
June 30, 2005 at 6:56 am
Yup, that's almost as sneaky as Noeld's solution to join to stored procs
.
June 30, 2005 at 6:55 am
Read my previous post carefully, execute the code one part at the time if you need to. This can handle any number of cities at the same time. ...
June 30, 2005 at 6:48 am
Yes, it can create locks in tempdb and grind the server to a halt (Less likely with 1=0).
If you need a table, script it out and execute that script when...
June 30, 2005 at 6:44 am
Damn, I saw that but I thaught there was 4 variables but there are only 3.
Using the profiler would have caught that
.
June 30, 2005 at 6:40 am
That's almost what I had but I wasn't sure of the relations....
June 30, 2005 at 6:37 am
Why would the alias make this work (even if it does, I don't see why it is required)??
June 30, 2005 at 6:33 am
One could argue that if they had coded the app correctly in the first place (returning as little rows as possible), unicode or not, the problem wouldn't have been there.
June 30, 2005 at 6:31 am
Are all the files in the same directory?
June 30, 2005 at 6:20 am
Not too sure (think I don't see all the tables/relation in this).
How about this ? :
Create a new view using enterprise manager.
Select all the tables you need (to display...
June 29, 2005 at 8:57 pm
Always another way to skin the cat
.
On board with the not doing it in production part??
June 29, 2005 at 8:45 pm
Did the vba code I sent you worked, because other than that I have no clue of what the problem can be?
The last thing I can imagine to see the...
June 29, 2005 at 8:44 pm
I don't have the script to prove this, but even the table variable is created in tempdb. It really all depends on the needs of the moment and the...
June 29, 2005 at 8:41 pm
Yup... still only one where keyword is allowed per select
.
June 29, 2005 at 8:39 pm
Viewing 15 posts - 15,946 through 15,960 (of 18,926 total)