Viewing 15 posts - 3,466 through 3,480 (of 14,953 total)
Or execute it with the recompile option.
exec dbo.MyProc @MyParam=MyValue WITH RECOMPILE;
Will that do what you need?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 30, 2011 at 7:30 am
sqlnaive (8/30/2011)
select isdate('01/01/2011') or isdate('01-01-2011')
-- giving 1 in sql server 2008
select isdate('01/01/2011') or isdate('01-01-2011')
--...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 30, 2011 at 7:28 am
The plus symbol works.
LEFT(LTRIM(MID(prefix,7,4) + phone),20)
I also noticed you have "TRIM" as a function in there. No such function in current T-SQL. Try "LTRIM" and/or "RTRIM" instead.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 30, 2011 at 7:25 am
Does it all boil down to instant vs long-term gratification? Are money and knowledge/skill the same thing?
Yes to both.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 30, 2011 at 7:20 am
"Concatenate" is a Denali feature as far as I know. Doesn't exist yet in SQL 2008.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 30, 2011 at 7:15 am
GilaMonster (8/30/2011)
GSquared (8/30/2011)
Actually, in the US, the government does own and run the two biggest companies in that particular arena (Fannie Mae and Freddie Mack).
Yes, I know. And they buy...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 30, 2011 at 7:13 am
GilaMonster (8/30/2011)
Jeff Moden (8/29/2011)
GilaMonster (8/29/2011)
Jeff Moden (8/29/2011)
GilaMonster (8/29/2011)
mtillman-921105 (8/29/2011)
But communism is not seriously considered a real option anymore.
Come down and tell some people in government here that. It would...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 30, 2011 at 6:32 am
Have you changed the default language of the server instance?
I checked, and both of the date formats you listed return 1 when I try them in SQL 2008 R2, using...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 30, 2011 at 6:22 am
mtillman-921105 (8/29/2011)
GSquared (8/29/2011)
GilaMonster (8/29/2011)
WayneS (8/29/2011)
Just read this: http://ittybiz.com/death-threats-online/. Appalling.Unbelievable. What is it, that they feel threatened by someone else's success?
I read a book about that once, by some guy named...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 29, 2011 at 1:01 pm
There are some questions here that need to be answered before much can be done with this.
First, what is the "Importance" column in TableA? Can you have repeating values...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 29, 2011 at 12:43 pm
GilaMonster (8/29/2011)
WayneS (8/29/2011)
Just read this: http://ittybiz.com/death-threats-online/. Appalling.Unbelievable. What is it, that they feel threatened by someone else's success?
I read a book about that once, by some guy named "Marx". ...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 29, 2011 at 11:52 am
Tom.Thomson (8/29/2011)
WayneS (8/29/2011)
Just read this: http://ittybiz.com/death-threats-online/. Appalling.
Awful.
Is there nothing that can stop it?
Maybe whover hosts the evil blog has terms of business that exclude this sort of thing (very...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 29, 2011 at 11:48 am
Try this:
DECLARE @x XML
SET @x =
'<i18n>
<language id="en_US" version="1.0" context="US English definitions">
<entity id="MyCases" type="end_user" context="My cases" translationRequired="true">My cases</entity>
<entity id="Registration" type="admin_only" translationRequired="false">Registration</entity>
</language>
</i18n>';
--Checking if the specific node row exists in...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 29, 2011 at 11:00 am
I tend to use brackets where needed. I use table aliases and column aliases where they are needed or where they help to read the query, like if I...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 29, 2011 at 10:45 am
Grant Fritchey (8/26/2011)
Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I have four...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 29, 2011 at 8:41 am
Viewing 15 posts - 3,466 through 3,480 (of 14,953 total)