Viewing 15 posts - 5,251 through 5,265 (of 8,731 total)
hanialbarni (2/9/2015)
February 9, 2015 at 9:35 am
Jeff Moden (2/9/2015)
I have no certifications or degrees and I can't use things like SSIS, SSRS, SSAS, or any of the other 4 letter words associated with SQL Server.
T-SQL...
February 9, 2015 at 9:02 am
hanialbarni (2/9/2015)
It did not work, maybe becuase am using different MYSQL WorkBranch ?
Maybe because this is a SQL Server forum and you weren't polite enough to mention that you're using...
February 9, 2015 at 8:30 am
It would be nice to have DDL, sample data and expected results to test but this should give you an idea.
SELECT *
FROM Applicants a
LEFT
JOIN Reviews r ON a.applicantId = r.applicantId...
February 6, 2015 at 3:40 pm
I'd like to say that it should not make any noticeable difference, but a better answer would be to test and measure both options to confirm it.
February 6, 2015 at 3:35 pm
Scott,
I mainly agree with you, but the OP stated that there's always one Payroll_Year at a time. Based on that, I wouldn't include it in the index.
February 6, 2015 at 12:22 pm
I'm guessing that you're working with Oracle because is the one that has varchar2 (AFAIK).
This is a SQL Server forum which means that you might not get the best suggestions...
February 6, 2015 at 11:47 am
You can use three part names to include database_name.schema_name.object_name
Or you could use synonyms.
February 6, 2015 at 11:12 am
Do you always query by employee? I'll guess you have more employees than payperiods. Assuming that, your columns should be EmployeeId, PayPeriod, CompanyId. If the queries use more the period...
February 5, 2015 at 7:20 pm
Sean Lange (2/5/2015)
Brandie Tarvin (2/5/2015)
I didn't even know this was a thing, but it is....
February 5, 2015 at 3:53 pm
krypto69 (2/5/2015)
I have a simple statement where I am trying to remove all commas that may be in the xn_workordeld column.
SELECT
xn_workordeld = case replace(xn_workordeld, ',', '') as "WORKORDER...
February 5, 2015 at 3:43 pm
New Born DBA (2/4/2015)
February 4, 2015 at 12:16 pm
Because you'll have problems with trailing spaces. Have you used the code that I posted to see the different cases and their results?
February 4, 2015 at 10:50 am
For an explanation on what Phil posted.
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
February 4, 2015 at 8:22 am
Viewing 15 posts - 5,251 through 5,265 (of 8,731 total)