Viewing 15 posts - 2,056 through 2,070 (of 8,416 total)
MonsterRocks (3/4/2011)
Thanks a lot.... but here #tab1 will be already derived from CTE.... so it will take more table scan... u suggest me to go with this?
It depends on how...
March 4, 2011 at 5:28 am
Chris Morris-439714 (3/4/2011)
Dave Ballantyne (3/4/2011)
SQLkiwi (3/4/2011)
Copyright infringement is when you're reprinting the work without permission.
It is...
March 4, 2011 at 5:19 am
Plagiarism is when you're pretending the work is your own and not giving proper credit.
Copyright infringement is when you're reprinting the work without permission.
It is possible to do both at...
March 4, 2011 at 5:13 am
ramarkishna (3/4/2011)
Really Nice Solution
That's almost there, but the output isn't quite right (multiple columns and huge blank spaces). Also the performance will not be as good as the...
March 4, 2011 at 5:05 am
Yogesh Potdar (3/4/2011)
Thanx - Regarding the parenthesis and standards, can you provide me the standards for writing the SQL Query, as i was looking for those 🙂
Yes, the syntax is...
March 4, 2011 at 5:01 am
Once you've read that article, this code should make sense:
SELECT CONVERT(VARCHAR(12), Emp.empno) + ' | ' +
STUFF(CA1.marks.value('./text()[1]', 'varchar(max)'), 1, 1, '')...
March 4, 2011 at 4:53 am
HowardW (3/4/2011)
It's important to note that none of these solutions will guarantee to delete the same rows as are being returned by the select statement...
Hi Howard,
I agree with your comments...
March 4, 2011 at 4:16 am
Hi Karen,
There are a number of strategies; which one is best depends on your precise circumstances. You can find a good general technique in this SSC article: http://www.sqlservercentral.com/articles/67898/. ...
March 4, 2011 at 4:01 am
Yogesh Potdar (3/4/2011)
Its bit easy you may try this...
There's no point specifying NOLOCK on a local temporary table, and the syntax that omits the WITH keyword and parentheses around the...
March 4, 2011 at 3:47 am
Just to be clear, Bart's example is compiled as:
SELECT CASE WHEN 0 <= 0 THEN 0 ELSE LOG10(0) END;
..which also gives the error (when it should not). Reproduces on...
March 3, 2011 at 10:16 pm
Gianluca Sartori (3/3/2011)
It looks like that behaviour is determined by the fact that the code executes inside a TVF.
It is constant-folding at work. If you replace the literal constant...
March 3, 2011 at 10:12 pm
Eric M Russell (3/3/2011)
March 3, 2011 at 12:15 pm
GSquared (3/3/2011)
Yep, but I haven't had a chance to try that in anything but proof-of-concept environments yet.
Understood.
March 3, 2011 at 10:33 am
Eric M Russell (3/3/2011)
March 3, 2011 at 10:26 am
GSquared (3/3/2011)
March 3, 2011 at 10:19 am
Viewing 15 posts - 2,056 through 2,070 (of 8,416 total)