Viewing 15 posts - 16 through 30 (of 203 total)
This is a very good question, thank you Ron. The only thing difficult to figure out is that you mention that database contains this table in the beginning but then...
November 24, 2010 at 9:21 am
guus.endeveld (11/19/2010)
Oleg,Thanks for your reply, but I think you could be a bit more positive in your reaction on my basic solution.
Guus
I am terribly sorry if my answer offended...
November 19, 2010 at 11:03 am
On ASK side we have a badge named Necromancer, which is given to someone who dusts out a question older than 60 days, answers it and gets 5 upvotes. To...
November 18, 2010 at 5:49 pm
Also, it breaks miserably if the week is less than 10 because it makes an assumption that the format is yyyy-ww while in reality it could be yyyy-w. This code...
November 18, 2010 at 4:43 pm
Lowell is probably correct, but there is a possibility that the numbers in your spreadsheet mean the date portion before the decimal and the number of seconds after the decimal...
November 17, 2010 at 3:28 pm
One way out of this is to embed another exec executesql in your @trg1_sql value. For example, if you have:
set @trg1_sql = 'use ' + @dbname +
...
November 17, 2010 at 10:41 am
Carlo Romagnano (11/14/2010)
In sql2005, I get an error:"plan_handle" is not a recognized table hints option.
Carlo,
Please check compat level of your SQL Server 2005 AdventureWorks database. If the level is 80...
November 15, 2010 at 9:39 am
A little ambiguity around Partitions can be on any column part aside, this was a very good question, thank you Stewart. Interestingly, we had a question on ASK side asking...
November 11, 2010 at 9:09 am
Hugo Kornelis (11/9/2010)
Oleg Netchaev (11/8/2010)
should be count(*) or even better count(1)Why would that be better?
Simply due to sanity reasons. I heard the rumor way back when in the dark years...
November 9, 2010 at 8:54 am
timothy bates (11/8/2010)
--The format for dates used here is YYYYMMDD and is intended to be functional within your environment.
CREATE TABLE [dbo].[Gregory] (
[dt] [datetime] NOT NULL ,
[row] [int] NULL...
November 8, 2010 at 10:09 am
timothy bates (11/5/2010)
Zero based index/offset counting strikes again. 😉
Next question, how many days in the year 0 AD?
This would be a very good question as the correct answer would be...
November 5, 2010 at 11:46 am
Oh well, I lost a precious point on this one. The statement in question
looked so ridiculous that it made me think that there...
October 29, 2010 at 11:39 am
sknox (10/26/2010)
Of course, if you're storing your value in an attribute, NULL is represented by the absence of the attribute in the record element, and SQLXML deals with that fine.
Absolutely...
October 26, 2010 at 9:29 am
UMG Developer (10/19/2010)
October 19, 2010 at 8:15 pm
mtillman-921105 (10/19/2010)
I think I know why they can get away with it. It's because Oracle's even harder to use. :hehe:
Very true indeed. I did have quite few unfortunate...
October 19, 2010 at 11:35 am
Viewing 15 posts - 16 through 30 (of 203 total)