Viewing 15 posts - 631 through 645 (of 1,183 total)
1. No, there are not restrictions to the number of statements for an IF block. Provided you use BEGIN and END if more than one statement is used.
2. I don't...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 9, 2008 at 10:14 am
Jeff Moden (1/3/2008)
Molly Cary (1/3/2008)
Yes thanks....I wasn't aware of this travesty that I was doing. 😉 I have reposted (hopefully correctly).... 😀
Not really a travesty, Molly... it just that some...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 8, 2008 at 3:33 pm
Jeff Moden (12/31/2007)
Jason! Hey! How's the new job???
Just getting settled in now. I'll be better suited to give an answer/opinion in a week or so. 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 2, 2008 at 12:29 pm
Jeff Moden (12/31/2007)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 31, 2007 at 6:43 pm
Great article Buck, and it couldn't be more timely for me. I just ended a SQL Development position and am going to start my first "DBA" position next week. You...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 24, 2007 at 1:31 pm
Well if you restrict your updates by state and have the state column indexed, i believe the updates will take just as long as if you had them in separate...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 22, 2007 at 8:08 pm
Yes, and place an index on the State column. There's jus no logical reason that i can think of to seperate the data when it's all related. I can see...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 22, 2007 at 8:00 pm
No problem Jeff! I'm really starting to se the true value of the Tally table BTW.. 😀
Hey, you never answered my PM.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 21, 2007 at 6:19 pm
Thanks, After 5 years of heavy development and studying and a tad of admin I'm off to my first DBA position. It's still going to be heavy development, but more...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 21, 2007 at 4:05 pm
Jeff, thank you, that's perfect! that makes this day that much better, cause now I can go home. 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 21, 2007 at 12:46 pm
Matt Miller (12/21/2007)
Still- looks to me that an old-style pivot syntax (the sum(case when ...end) type of statement) ought to do what you wish
That only get s part of it....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 21, 2007 at 9:17 am
Matt Miller (12/21/2007)
What happens if the Billable time has something in...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 21, 2007 at 9:15 am
karthikeyan (12/21/2007)
Can you tell me where exactly you can apply spt_values table?I mean In which situations you go to spt_values.can you list out some examples ?
I thought Mr. Moden...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 21, 2007 at 5:15 am
Yes, you can revert back at any time. Whether your data's integrity has been violated is still another question.
I could have sworn that there is/was an upgrade compatibility wizard, but...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 21, 2007 at 5:00 am
Sure,
DECLARE @String NVARCHAR(4000)
SET @String = 'SQLSERVERCENTRAL'
SELECT
item, COUNT(*)
FROM
(SELECT
-- this will get the specific...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 21, 2007 at 4:50 am
Viewing 15 posts - 631 through 645 (of 1,183 total)