Viewing 15 posts - 2,476 through 2,490 (of 6,036 total)
Actually my suggestion would look like this:
select ma.memid, ma.attributeid, ma.thevalue, ma.effdate, ma.termdate,
substring(rtrim(ma.thevalue), len(rtrim(ma.thevalue))-1,2) countyCode
from [laforge\laforgesql].qnxt_plandata_oh.dbo.memberattribute ma
inner join (select memid, attributeid, max(effdate) maxEffDt
from [laforge\laforgesql].qnxt_plandata_oh.dbo.memberattribute
where termdate is null OR termdate >= getdate()
group...
June 10, 2009 at 8:27 pm
The column which is used the most for RANGE SELECTION (between, >, <) should be chosen for clustered index.
Then all records from the selection will be located consequently.
June 10, 2009 at 5:30 pm
1. Try always use INNER JOIN to a derived table instead of subquery.
2. Can you ask for a view on the remote server based on your query (with join, not...
June 10, 2009 at 5:13 pm
The best way is to have IDENTITY column on Managing table itself and not only get rid of lots of useless coding but allow multi-row inserts on this table as...
June 10, 2009 at 3:05 pm
Use locking hint (TABLOCKX) in "My Operation" and it will do exactly what you want.
June 9, 2009 at 6:19 pm
You've been given with 3 options.
Which one to choose - it's your call.
Actually, it's funny you nee to add headers to the data file.
It means that for years the data...
June 8, 2009 at 3:20 pm
Jeff Moden (6/7/2009)
Seems just the opposite is true because it doesn't work in 2k but it does in 2k5. 🙂
No, everything was correct in the statement.
They wanted it back...
June 8, 2009 at 12:58 am
Jeff Moden (6/6/2009)
June 7, 2009 at 6:34 pm
GSquared (6/5/2009)
You can use that dateadd(datediff()) method for taking any part of a datetime off. Works very well, and is quite efficient and fast.
Not any part.
It will fail for...
June 5, 2009 at 3:43 pm
bdmtsu (6/5/2009)
June 5, 2009 at 3:36 pm
I wonder - what company you do the project for?
EMPID BIGINT - if INT is not capable enough to hold all EMPID's - which company has billions of employees?
June 5, 2009 at 6:34 am
Actually XML's are for web-services, not for file systems.
Can you get the web-service which actually needs that XML just make a call to you procedure and grab the XML stream...
June 4, 2009 at 9:01 pm
Adi,
conversion through char is the slowest and resource consuming way to do this.
Don't use it any more.
June 4, 2009 at 3:09 pm
I'd suggest to use WHERE NOT EXISTS.
OUTER JOIN sucks in some situations.
June 4, 2009 at 3:01 pm
DATEADD(dd, DATEDIFF(dd, 0, DateTimeValue), 0)
June 4, 2009 at 4:45 am
Viewing 15 posts - 2,476 through 2,490 (of 6,036 total)