Viewing 15 posts - 3,391 through 3,405 (of 4,087 total)
roryp 96873 (12/29/2011)
December 29, 2011 at 9:09 am
You realize that this is a presentation issue and is best handled in the presentation layer.
Drew
December 29, 2011 at 8:58 am
If I understood what you're trying to do, this is a more efficient approach.
SELECT n.[ID], n.DisplayTime, n.NEText, c.Other_ID
FROM @Case2 AS c
CROSS APPLY (
SELECT TOP (1) n.ID, n.DisplayTime, n.NEText
FROM @Notes AS...
December 29, 2011 at 8:23 am
The problem occurs because of how the precision and scale of the result are determined from the precision and scale of the operand expressions. Check Precision, Scale, and Length...
December 29, 2011 at 7:09 am
GSquared (12/28/2011)
I'd prefer to see the query that gets a syntax error, and fix that first, and then worry about optimization and standardization next.
I don't think it's that easy to...
December 28, 2011 at 1:50 pm
There may not be syntax errors, but there are lots of logical errors. For instance, the table clean_cust_account_lcd_cancel_switch is queried three separate times when it looks like it should...
December 28, 2011 at 1:37 pm
December 28, 2011 at 8:36 am
pdharmaraju (12/28/2011)
use the loop and insert into new table
It has been shown repeatedly that the loop performs much worse than the string splitter that was linked to previously in this...
December 28, 2011 at 7:52 am
The problem with this query is that the order of the UOMs is not meaningful. It just happens that the UOM for capacity comes before the UOM for weight...
December 23, 2011 at 7:43 am
stourault (12/22/2011)
December 22, 2011 at 1:40 pm
Jeff Moden has a very good article on exactly this problem. Solving the Running Total and Ordinal Rank Problems (Rewritten)[/url] Be sure that you follow all of the...
December 22, 2011 at 1:31 pm
Use NTILE() to divide each partition into two parts (control and experimental) and then use ROW_NUMBER() to assign a number to each record within the group and match corresponding numbers....
December 22, 2011 at 1:23 pm
angela.nira (12/22/2011)
Is there an easy way? Any help you could provide would be greatly appreciated.
We're all unpaid volunteers. We're more than willing to help as long as you've...
December 22, 2011 at 8:40 am
senthil_sn1 (12/22/2011)
In ODBC the SQL language is English. The Regional settings is Japanese. This is settings in workstation. In the database server the regional settings is English
This goes back to...
December 22, 2011 at 6:59 am
ChrisM@home (12/21/2011)
Secondly, use COALESCE(ExistingColumn, StagingColumn) like this to handle the NULL issue:ExistingColumn = COALESCE(ExistingColumn, StagingColumn)
Actually it sounds like he wants to overwrite the existing column if both the existing and...
December 21, 2011 at 6:54 am
Viewing 15 posts - 3,391 through 3,405 (of 4,087 total)