Viewing 15 posts - 39,856 through 39,870 (of 49,571 total)
Well, the clustered index keys are the columns in your primary key, ie PayCode and DBNo. Since you're filtering by a column that's not one of those and you have...
April 10, 2009 at 1:13 am
Krishna Potlakayala (4/9/2009)
san (4/9/2009)
how to take transaction log backup without .mdf fileInteresting, What are you trying to do here?
I'm guessing take a log tail backup after the MDF has...
April 10, 2009 at 1:07 am
Vivek (4/9/2009)
Indexes are not implemented in the database by the client so there are no indexes implemented on the database.
Why?????
Will millions of rows in the table and no indexes, you...
April 10, 2009 at 1:05 am
Florian Reischl (4/9/2009)
Anyway since the value cannot be converted to a number it also shouldn't be numeric...
Oh, but they can.
'15d1' and '15e1' will cast successfully to float. '10,0' will cast...
April 10, 2009 at 1:00 am
Jeff Moden (4/9/2009)
I believe you need to ping back and say it was an error. Read the last post on that link very carefully.
I'll take that 'apology' with a...
April 10, 2009 at 12:59 am
The other potential problem being that there are cases where ISNUMERIC returns true, but the value cannot be cast to decimal. ISNUMERIC means that the value in question can be...
April 9, 2009 at 3:47 pm
To do that, you'd need to cast the date to a varchar. Typically this is a presentation issue and shouldn't be done if this data is going to be inserted...
April 9, 2009 at 1:55 pm
Dev (4/9/2009)
select * from SysUser where name like '%/_%' --> No...
April 9, 2009 at 1:13 pm
WHERE SomeColumn LIKE '%/_%' ESCAPE '/'
The escape character makes SQL treat whatever follows it as a literal character.
April 9, 2009 at 12:54 pm
If I'm understanding your requirements correctly, you want this:
SELECT count(*), status_code_id, bp_type_id, dateadd(mm, datediff(mm,0, effective_date),0) AS EffectiveMonth
FROM dbo.best_practice_version
WHERE dbo.best_practice_version.status_code_id IN (5, 4)
AND...
April 9, 2009 at 12:07 pm
Bob Hovious (4/9/2009)
I have to ask (somewhat fearfully) how did Gail get to be Gila Monster?
😀 It's no secret or anything. The nickname dates back to University days and is...
April 9, 2009 at 11:46 am
Grant Fritchey (4/9/2009)
And having seen the Gilamonster in action, I'm glad this isn't possible!
Man, I'm sorry I missed that seminar. She made a real impression.
Join us next time?...
April 9, 2009 at 11:42 am
Might be a management studio bug. Try restoring using T-SQL?
April 9, 2009 at 11:24 am
There are times I wish I could reach through the computer screen and beat some sense into people...
I don't know if anyone recalls, much earlier in this thread I posted...
April 9, 2009 at 11:18 am
Lynn Pettis (4/9/2009)
And then there are those who really should not be giving advice. The code provided here wouldn't even pass a check in SSMS.
Are we really surprised?
April 9, 2009 at 11:14 am
Viewing 15 posts - 39,856 through 39,870 (of 49,571 total)