Viewing 15 posts - 346 through 360 (of 427 total)
@Yin Halen, thanks for having us in your thread. My day wouldn't have been as much fun without it.
@jeff, your audience must be on a more...
August 17, 2011 at 12:49 am
I know, the example was far fetched. And as I said: there are far better ways to implement the example. Still I don't share your idea that readability is always...
August 16, 2011 at 4:55 pm
Jeff Moden (8/16/2011)
August 16, 2011 at 3:33 am
It can be usefull, but only in very specific situations. But then, when people get to those situations, they tend to use alternative solutions since they are not familiar with...
August 16, 2011 at 1:50 am
Sean Lange, I hadn't yet seen the additional requirement of skipping 0's when I wrote my reply. That is why yours looked over complicated to me. Sorry about that.
Of course...
August 16, 2011 at 12:28 am
Sean Lange (8/15/2011)
DECLARE @a int = 102733019,
@b-2 int = 102733019 ,
@C...
August 15, 2011 at 5:05 pm
The ALL operator might be helpfull too (I always wondered when it would be helpfull and this is when 🙂 ):
declare @a int;
declare @b-2 int;
declare
August 15, 2011 at 2:08 am
I needed the iso week number too in SQL 2005. Looked for it in all the usual places (bol, forums, google, etc) and found many different implementations. Most however have...
August 15, 2011 at 1:42 am
As an example of Eugence's tip an excerpt of your query, but now using a left join (so you will still get an order listed even if its freight charge...
August 10, 2011 at 10:27 am
I've read from your request that you want one long string returned for the entire file: i.e. each row is stored in 47 characters with no row separator in between....
August 10, 2011 at 9:11 am
This has been answered above by skcadavre already? What don't you understand of it?
skcadavre (8/5/2011)
Not sure what ".fff" is, but the "T" is ISO8601 -> code 126
SELECT CONVERT(VARCHAR(100),GETDATE(),126)
If you really...
August 9, 2011 at 12:20 am
select (
STUFF(
(select N', ' + cols.COLUMN_NAME as [text()]
from Razor_3_Snapshot.INFORMATION_SCHEMA.COLUMNS cols Where cols.TABLE_NAME= 'TradeContributionSummary'
order by cols.ORDINAL_POSITION
for xml path('')
)
,1,1,'')
) Probably you won't notice this as a problem, but this version also...
August 8, 2011 at 11:36 am
Not only is it missing the value(), it is also missing the ", type" clause on the for xml path(''). Adding ,type makes the for xml path() clause return a...
August 8, 2011 at 11:19 am
I think you intend to use LIKE to find all instances that have one of the 'invalid' characters and then use the replace sequence to 'fix' the issue. Is that...
August 8, 2011 at 9:14 am
And a tip: when constructing queries, you will want to investigate the quotename() function.
August 8, 2011 at 9:00 am
Viewing 15 posts - 346 through 360 (of 427 total)