Forum Replies Created
Viewing 15 posts - 586 through 600 (of 5,356 total)
-
RE: Dynamic SQL String
Since DATEDIFF returns an Integer value, SQL Server tries to cast your @strSQL also to an INT, because INT has a higher precedence. What about this?
DECLARE @strSQL NVARCHAR(50)
DECLARE @MyDate DATETIME
Set...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: is possible to do an ''''on error goto'''' in TSQL?
http://www.sommarskog.se/error-handling-II.html
http://www.sommarskog.se/error-handling-I.html
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Variable parameters
See if this helps: 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] -
RE: Should I change my avatar
Thanks Calvin, I've downloaded the book and will read it. At a first glance it's doable with a dictionary at my side.
The intellectual...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Searching Stored Procedures & User Defined Functions
Not only that...
You can frequently observe the question why one cannot use GETDATE() inside a UDF. And equally frequent you will see someone suggesting to wrap GETDATE() inside a view...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Issue with Sum of field from two table
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=173285
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Issue with Sum of field from two table
From your sample data, is it possible that a product can appear in only one table, or do they always appear in both tables?
Without having a crystal ball in...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Should I change my avatar
Thanks Phill!
Meanwhile I've read a bit closer into this copyfight thingy. Sad, but true. For now, I'll stick to this one...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: deleting records without writing to transaction log
It deletes ALL the data in the table without using the log file, regardless of recovery mode.
Slightly incorrect. TRUNCATE is minimally logged. The deallocation of the datapages actually is recorded...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Help with a query
Äh, yes?
Let's leave it here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=173895
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Help with a query
What is the reason why you want to keep permanently this redundant information?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Should I change my avatar
wtf *?@3$%&"gr@| If someone complains, it's still enough time to remove it.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Should I change my avatar
Yeah, I don't like it, too, but it's the best I've found doing a quick search....I'll work on this.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Searching Stored Procedures & User Defined Functions
Haha, Remi, thanks for correcting my on this. This shows how much I deal with UDF's.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Should I change my avatar
Aah, now I understand. And although I personally think that's nothing but ridiculous, I have changed the avatar. I don't want to cause any trouble here.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 586 through 600 (of 5,356 total)