Viewing 15 posts - 9,706 through 9,720 (of 15,381 total)
At the very least the WWW consortium does not agree that there is no such thing.
‘ is left single quote
’ is right single quote
--EDIT--
Proof...I typed in the html escape...
January 3, 2013 at 3:18 pm
I am totally lost now...are you saying that it changed your inner joins to left and right joins?? You have me stumped.
January 3, 2013 at 3:14 pm
zombieisdead2020 (1/3/2013)
where RecordId = 3212and not(replace(AlphaNumeric2 + AlphaNumeric5 + AlphaNumeric7 + AlphaNumeric9, '2012', '') = '')
Get rid of the NOT to keep is ARGable.
where RecordId = 3212
...
January 3, 2013 at 3:11 pm
Maybe combine them into a single select?
where RecordId = 3212
and
(select case when AlphaNumeric2 = '2012' then 0 else 1 end +
case when...
January 3, 2013 at 2:26 pm
That will work as long you don't care about missing/duplicate data or a host of other nearly impossible bugs to figure out. I would highly recommend you get very familiar...
January 3, 2013 at 1:54 pm
twahl0630 (1/3/2013)
need to find a faster way to do this select into I'm using or ststatementso filter on multiple columns
any ideas
select m.RecordId,m.NumberForSearch into #dump
from table1...
January 3, 2013 at 1:44 pm
Are you using the GUI to build your view? I have not seen the behavior you are talking about. I created a view and when scripting it back out the...
January 3, 2013 at 12:32 pm
This isn't something you can control from your code. That is how Outlook displays the text. There is a user setting in Outlook disable that feature but it is somewhat...
January 3, 2013 at 10:20 am
Good topic for a question. However since I always try to get the answer without running the code I tend to really dislike questions with this level of nested logic....
January 3, 2013 at 8:54 am
tony@kenny.net (1/3/2013)
I was also concerned about how well it...
January 3, 2013 at 8:42 am
For an even better solution stop using dynamic pass through sql and do this with a stored proc. The advantages are numerous. You can avoid sql injection, debugging is a...
January 3, 2013 at 7:29 am
Take a look at Gail's post. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D
She explains how to deal with this type of thing very cleanly.
January 3, 2013 at 7:25 am
roger.plowman (1/3/2013)
Would it have killed the designers to create...
January 3, 2013 at 7:14 am
adonetok (1/2/2013)
I use len(rtrim(ltrim(NDC))) but got the same problem
Then you must have some non-display characters in your data. Try outputting select * to text instead of the grid. Do you...
January 2, 2013 at 9:07 am
In my position what is a worthy programming language to learn that will continue to be the standard in dev? .NET? How can I practice? In Visual Studio? Another reason...
January 2, 2013 at 9:04 am
Viewing 15 posts - 9,706 through 9,720 (of 15,381 total)