Forum Replies Created
Viewing 15 posts - 1,681 through 1,695 (of 5,356 total)
-
RE: Cursors
Okay, this is an "administrative" one-time action. I think that's quite okay for such cases. The only alternative I can think of right now, might be sp_MSforeachtable. But if you...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Conditional Date selection - Help needed
Hey, I should have rather posted this instead:
http://dsc.discovery.com/news/afp/20040823/psychopath.html
And identify the common "management enemy"
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: How To Create New Database?
...or sp_attach_db.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: launch query analyser from enterprise manager ?
Not exactly an answer, but you can add ISQLW.EXE to the externals tools in EXTRAS and then use something like ALT+X 1 to launch QA.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: advice my site
Hm, I wouldn't reinvent the wheel, but rather have a look at http://www.hotscripts.com or similar sites like http://www.sourceforge.net . There are a lot of geeks around who developed...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Select first 10 rows of table
>But what if the dates are so randomly distributed that no date is the same?
In this case you'll find that you get two rows per name as requested.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Conditional Date selection - Help needed
Wrong!
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Select first 10 rows of table
The WITH TIES is not really needed in this situation, I think, because of the combination of ...IN... TOP 2 ... WITH TIES. If you have two or more rows with...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Conditional Date selection - Help needed
Regarding the funnies, I will take them in the spirit they were meant (I hope)
Gee, no. The funnies had nothing to do with your question!!!
Please, don't get this wrong. If...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Conditional Date selection - Help needed
You, too.
Here's one more: http://www.baetzler.de/humor/null.html
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: where is user databases physical filename stored?
Actually I think it's also in the header information of each database's primary file.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Conditional Date selection - Help needed
Okay, some Friday funnies:
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: T-SQL Question
From speaking to one of the guys here, he tells me it is a port of an old access app.
Sorry about that.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: T-SQL Question
Sounds like a port of an old Access app
But to answer your question, I don't think there should issues when joining both columns....
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: T-SQL Question
Counterquestion:
Why do the columns that you join on have different datatype length?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 1,681 through 1,695 (of 5,356 total)