Search:
Type: Posts; User: disruptivehair
Search:
Search took 0.06 seconds.
-
My solution was to comment them all out. :afrog:
-
My execute button is the top one, i.e. a red exclamation mark.
-
Yeah, I looked for that too and didn't see any indication that that's allowed but it didn't say it wasn't allowed either. This allegedly works on SQL Server 2000... :confused:
It gets better...
-
I tried the 'with' thing already but I tried it with brackets [] instead of parentheses (). I'll try it again how you wrote it. :thumb:
-
No, but the person who programmed the proc that I'm fixing did! His hints don't work in 2005 and now I have to make them work, even though I don't think they're really necessary. Grrr. I don't...
-
I've just been given a proc in SQL 2005 to fix and it has a bunch of index hints in it. I know sort of how they work but I don't really use them and evidently the syntax has changed a lot from one...
-
More info...if I refer to the chart explicitly by its index number I can change the font face but not the font size...unless I do this:
With xlSheet.ChartObjects(5).Chart
With...
-
Sorry; I just realized I didn't specify WHAT the problem was. On each chart the fonts on the chart are set to 8 pt except on the last one where they are 4, which is what Excel would set by default...
-
Every time I run this code, the font on the axes is set to 8pt on 4 out of 5 charts. I have absolutely no idea what the problem is here. I'm drawing a complete blank. I thought maybe the loop...
-
-
The DBAs have requested that we change this setting from OFF to ON when creating clustered indexes. Fine, but when I scripted one with SORT_IN_TEMPDB = ON then ran it, then looked at the create...
-
I wrote this query to extract all cases from the PPEKBaseData table where the value of OM_Complete was less than 90 days old:
SELECT * FROM PPEKBaseData
WHERE Pol_no NOT IN
(SELECT Pol_no...
-
Mmmmmmmmm kaaaaaaaaaaaaaaaaaaaaaay.... :confused:
-
I don't swing that way, sorry. :bigyello:
-
-
No, it's because it takes 70-80 calories of energy to produce a single calorie of beef. It's basically one of the most inefficient sources of protein to produce and should be eaten only...
-
Why is an atheist asking us to pray for him?
edit:
Damn, someone beat me to it!
-
I eat meat...chicken, turkey, and fish mostly. We eat a bit of pork; maybe twice a month; and we hardly ever eat beef for environmental reasons. We try to have a veggie dinner at least once a week...
-
What about chicks who wear too much perfume? There's one standing near me right now and it's making my eyes water.
-
If someone handed you a bag containing 4-5 million dollars, you'd pee in your pants for joy. ONLY about 4-5 mil. :lol: :lol:
-
Yay, I did something right! :thumb:
-
I know that, but I can dream. :cool:
-
Alcohol could be anything tho...liquor is not beer, not wine....BOOZE. I used to work with this one guy who drank a smallish bottle of gin every day at lunch. In full view of everyone. :eek:
-
I could, but there's only one instance where that column is queried and I have functions that take care of building my parameters and they can't handle it. I guess here I would classify my solution...
-
-
Aftershave and cologne are two different things. :)
I DID say liquor! :thumb:
-
That reminds me, I should buy a ticket; I think the EuroMillions is on Friday and the national lottery is on Sat. Not much up for grabs, but it's all tax-free. YAY!
-
OK.
Is HAVING generally considered to be a bad thing tho? I'm still kind of new at this and I like getting advice from people who are better at this than I am. (I'm not being sarcastic at all!)...
-
Because the @Filter parameter I pass in already has a where clause sometimes, and I don't want to fiddle around with all the conditionals. The query runs very quickly so I don't see that HAVING...
-
Nevermind, figured it out:
CREATE PROC dbo.sp_FEWeeklyAcceptedTargets2(@Filter nvarchar(200) = NULL, @AcMeth nvarchar(1))
AS
DECLARE @strSQL nvarchar(2000)
DECLARE @strWhere nvarchar(200)
...
-
Here's my proc:
ALTER PROC dbo.sp_FEWeeklyAcceptedTargets2(@Filter nvarchar(200) = NULL, @AcMeth nvarchar(1))
AS
DECLARE @strSQL nvarchar(2000)
DECLARE @strWhere nvarchar(200)
SET...
-
Hehe...there's this pinky-ring, gelled-hair guy in my office who just got back from there...you know the kind, they come in to work reeking of cologne and come back from lunch reeking of liquor. ...
-
Kabul would probably be a party destination if they had cheap booze and Easy Jet flew there for a tenner. I would ask why Brits drink so much but since I live in the UK, I know why: NOTHING ELSE TO...
-
Buy houses for all my loved ones.
Buy an arsenal of classic cars. I'm not a gearhead, I just like how they look.
Book expensive holidays, first-class all the way; and it would be tough and...
-
What is it with Brits and Tenerife?
-
On Saturday: Didn't die in a plane crash
That's it.
-
-
-
It's going to be 50F here today but it feels warmer than that.
Today's high in Dallas (where I'm from) is going to be 71F. God, I wish I was there instead of here.
-
It's an application, not an assignment.
I was lucky...I didn't have to write any essays to get into uni. I just sent my SAT scores and high school transcripts to the University of Texas at Austin...
|
Click Here to Expand Forum to Full Width
|