Forum Replies Created
Viewing 15 posts - 1,906 through 1,920 (of 5,356 total)
-
RE: How do I do this?
Damn, beaten by 2 minutes, Adam!
Should take a course in fast typing
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: How do I do this?
What about
UPDATE Table
SET qty_total =
case when start_qty - end_qty < 0 then 0 else start_qty - end_qty end
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Extract Info From Event Viewer
I don't think this is possible using plain T-SQL. However this might be interesting for you:
http://www.microsoft.com/technet/scriptcenter/tools/logparser/default.mspx
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Guess even MS misses typos.
Oh, and while we're at it. Shouldn't
Functon
read
Function
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Guess even MS misses typos.
Sorry, I meant there are more severe and not so funny errors than this additional E.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Load data and exclude What Already exists
Sorry, but I have never seen a Merge Join when you use NOT EXISTS. You should always get Nested Loops.
From my observations I have seen NOT EXISTS performing better...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Numeric and decimal data types
I might be wrong, but I think the NUMERIC data type is still included in the SQL 2003 Standard. So, I guess it will take some time, before one can...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Guess even MS misses typos.
What is the E-Mail address for it? sqlwish@microsoft.com ?
I wish there were only such mistakes in SQL Server
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Load data and exclude What Already exists
Dave,
just a note on this
LEFT OUTER JOIN
..
WHERE ... IS NULL
While this solution surely works, you'll find the same rewritten to use (NOT) EXISTS to perform generally better. Try...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Should secondary indexes be defragmented?
See if this will help you:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Need to Generate Script for Foreign Keys
Yes, after posting my reply I became aware of it. Sorry, no good idea other than the one you already had. Maybe this can be done via SQL-DMO, but I...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Need to Generate Script for Foreign Keys
Success
Back to your question:
Probably the easiest solution is to check the appropriate option in EM when you click on "Generate Script"
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Pagination using sql query
More than one way to skin that cat
http://www.microsoft.com/sql/techinfo/tips/administration/resultset.asp
http://www.aspfaqs.com/webtech/062899-1.shtml
or here
http://www.aspfaq.com/show.asp?id=2120
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: VBA and VB differences
Andrew,
long time no see
Do a search on the MS site. I haven't got the link at hand now, however there are some nice...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Where clause in a variable?
Have a look here
http://www.sommarskog.se/dynamic_sql.html
http://www.sommarskog.se/dyn-search.html
--
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,906 through 1,920 (of 5,356 total)