Viewing 15 posts - 1,201 through 1,215 (of 1,240 total)
reamades (5/19/2015)
OwnerID
OwnerName
OwnerAddress
OwnerCity
OwnerState
OwnerZip
PropertyDescription
County
etc.
So John Smith might have OwnerID=1 in Tarrant County. And there might be Smith, John in Reno County that has OwnerID=205. I'm still wrapping...
May 19, 2015 at 12:01 pm
Nope... All CHAR(1) to CHAR(1)... (not shure how the [Union####] come into play...)
here's the warning section of the plan.
<Warnings>
...
May 18, 2015 at 9:52 pm
Alan.B (5/18/2015)
If the collation that the table is stored in is Case Insensitive then you use a...
May 18, 2015 at 9:40 pm
I don't know that I'm 100% clear on what you want but I think this should be pretty close...
Check this with the sample data and see if it's what you're...
May 18, 2015 at 6:31 pm
I agree that the ">= / <" syntax is the all around better syntax and I'll stick to it exclusively, moving forward.
May 18, 2015 at 9:52 am
Lynn Pettis (5/15/2015)
I would still refrain from using BETWEEN for date ranges. Biggest reason being if there is a data type change to column such as DATE to DATETIME...
May 15, 2015 at 8:38 pm
WOW... I could have sworn that the last time I tested, CASTing from a DATETIME to a DATE made it unsargable...
Just tetested with this...
DECLARE
@BegDate DATE = '2015-01-10',
@EndDate DATE...
May 15, 2015 at 5:21 pm
I'm with ya... I'd written a piece of obfuscation code that actually worked a little too well for it's intended purpose... Rather than trashing the code, I figured that it...
May 15, 2015 at 4:51 pm
Next question:
How would you describe the differences between being "Loyal" to a company and "Dedicated" to a company? Heh... The answer will be provided either at 2AM tomorrow morning...
May 15, 2015 at 4:10 pm
The following is what I'd put in the NEVER do category...
WHERE CAST(t.SomeDateTime as DATE) BETWEEN @BegDate and @EndDate
Actually... I should say "Never do again" category... I have a few report...
May 15, 2015 at 3:26 pm
Both good points... Although I'd still put this in the "good idea not to do this" category as opposed to the "never do this" category...
May 15, 2015 at 2:58 pm
ScottPletcher (5/15/2015)
Never use BETWEEN on dates or datetimes;
Out of curiosity, why do you say this?
I could see it it you were talking about DATETIME data types only, simply...
May 15, 2015 at 2:39 pm
It depends... CAST is typically the preferred syntax being that it's an ansi standard... But, sometimes it's necessary, when working with different date/time data types to use the CONVERT function...
May 15, 2015 at 10:38 am
The reason it doesn't work in either of your original versions is because they are both attempting to concatenate a date datatype to a varchar data type... The two data...
May 14, 2015 at 10:45 pm
If keeping those rows is important... This doesn't seem to beat it up too bad...
IF OBJECT_ID('tempdb..#address') IS NOT NULL
DROP TABLE #address;
CREATE TABLE #address (
address_id INT,
addr1 CHAR(30),
addr2 CHAR(30),
...
May 14, 2015 at 8:55 pm
Viewing 15 posts - 1,201 through 1,215 (of 1,240 total)