Viewing 15 posts - 10,726 through 10,740 (of 15,376 total)
This has a distinct feeling of being a dynamic sql version of a catch all query. Take a look at Gail's article about this here. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D
September 14, 2012 at 8:45 am
Saravanan_tvr (9/13/2012)
September 14, 2012 at 8:00 am
Skanda (9/14/2012)
am having two columns
Usage, Expiration date.
My requirement is : when "usage" column is blank "expiration_date" should not come in select,
Am using below logic, but it is not working.
select
case...
September 14, 2012 at 7:50 am
dwain.c (9/13/2012)
Sean Lange (9/13/2012)
...some guy on the internetI think I'll change my board name. 🙂
LOL by no means was any disrespect intended good sir. 😀 I of course would be...
September 13, 2012 at 7:27 pm
valeryk2000 (9/13/2012)
That may work short term but in the long run that is not going to survive. The text datatype has been deprecated and will be removed in the future.
It...
September 13, 2012 at 2:02 pm
aaron.reese (9/13/2012)
If you can't unencrypt it, is there any point in keeping it
Yes, an example is in my original post; where you convert another value and compare the results. ...
September 13, 2012 at 1:57 pm
sbk2007 (9/13/2012)
Thanks so much, well I had already achieved the resultset yesterday (but with loop:)) urs worked liked a breeze without loop!!Thanks again..
Important lesson here is that looping should be...
September 13, 2012 at 1:48 pm
Sharon Kumar (9/13/2012)
I want output where faclity is a and b having same our id column value
eg: a=2
...
September 13, 2012 at 1:46 pm
Sharon Kumar (9/13/2012)
OURIDFACLITY
1A
1b
2C
3D
3b
3A
2A
4B
5B
I want output like
OURIDFACLITY
1 A
1 b
3 ...
September 13, 2012 at 1:24 pm
joe.wolfe (9/13/2012)
September 13, 2012 at 1:12 pm
jane.frasier (9/13/2012)
September 13, 2012 at 12:53 pm
m.henly (9/13/2012)
When the original developer put it all together (about ten years ago) and started to show me the basics of Sql, he told me to always use...
September 13, 2012 at 12:39 pm
valeryk2000 (9/13/2012)
No 2010. Why no active support for 2003-2007 (by Microsoft?)Actually I found the solution - changed (n)varchar(max) to text, and this one Access handles as memo.
Thanks
That may work short...
September 13, 2012 at 10:48 am
Because as you say you are an "Accidental DBA" and your query is full of nolock hints you might want to read up on the hint some more.
http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
http://www.jasonstrate.com/2012/06/the-side-effect-of-nolock/%5B/url%5D
If you can...
September 13, 2012 at 10:41 am
I might add to that not to use select * and if at all possible change the name of your table to not use a reserved word.
select * from [order]...
September 13, 2012 at 10:28 am
Viewing 15 posts - 10,726 through 10,740 (of 15,376 total)