Viewing 15 posts - 2,836 through 2,850 (of 4,087 total)
ROW_NUMBER() is overused. Here the OP needs a single value from one record to be available across the entire partition, namely whether a NULL exists on any record in...
January 14, 2016 at 8:44 am
asita (1/13/2016)
I am using sql server 2008R2
For future reference, there is a forum specifically for SQL2008. You would be better off posting in that forum, because you are less...
January 13, 2016 at 10:23 am
Even though your data doesn't have a primary key, it should have one or more natural keys. You need to identify what those natural key might be and use...
January 13, 2016 at 10:20 am
sqlfriends (1/12/2016)
That is a good reminder.Unfortunately the original data does not have a pm, am.
There are three possibilities:
1) The data is set up with 24-hour times and you're all set.
2)...
January 12, 2016 at 3:11 pm
Please note that since you don't include AM or PM, the hearing time will be interpreted on a 24-hour clock, so your 0330 will be 3:30 AM.
Drew
January 12, 2016 at 1:04 pm
John Mitchell-245523 (1/11/2016)
January 11, 2016 at 11:23 am
You can create the tables directly from Visio. It's been awhile, and I don't have a copy of Visio to walk you through how to do it.
Drew
January 8, 2016 at 7:40 am
Hint: LIKE without wildcards in the second expression is equivalent to =
Given that, think of it like the distributive property. You have an element in common in both inner...
January 7, 2016 at 12:11 pm
You just need to slightly modify the query Lowell provided.
SELECT * FROM #CoverageTable
WHERE CoverageID IN ( SELECT CoverageID FROM #RateTable )
EXCEPT
SELECT * FROM #RateTable
Drew
January 6, 2016 at 1:45 pm
Hugo Kornelis (1/6/2016)
sql_only (1/6/2016)
why does
DECLARE @phi DECIMAL = (SQRT(5)+1)/2
SELECT @phi;
return 2
and not 1.618
Integer math.
Actually, no. The SQRT function returns a decimal even though the input is an integer. ...
January 6, 2016 at 11:07 am
Please post sample data and expected results as specified in Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Drew
January 5, 2016 at 1:26 pm
Jeff Moden (1/1/2016)
January 4, 2016 at 7:56 am
Jeff Moden (12/30/2015)
Here's the code I wrote last night with the validation checks that I added today. Details are in the comments in the code.
GREAT! But suppose your company...
December 31, 2015 at 7:46 am
Jeff Moden (12/30/2015)
Generating data to the ms across a large range of dates is very important to testing.
I would say that depends on what you're testing and the...
December 30, 2015 at 3:11 pm
Jeff Moden (12/29/2015)
December 30, 2015 at 9:08 am
Viewing 15 posts - 2,836 through 2,850 (of 4,087 total)