Hey MD,

Check out if the SQL below gives the results you are looking for:

SELECT

 code = r.code, 

 code_updated = SUBSTRING(r.code, 1, 2) + '0' + SUBSTRING(r.code, 3,...

Hey There Leslie,

Check out if this SQL is what you are looking for:

SELECT

  *

FROM

  WorkedHours w INNER JOIN

    Employees e LEFT OUTER JOIN

      Dependants d ON...

Hey,

Are you able to do a SELECT on the view such as:

SELECT * FROM myview

Just taking a guess here:

I'm thinking that maybe mytable in database2 might contain...

Hey StephanJ

Some approaches that I could think of are:

[Approach 1 : Go SQL Server all the way]

1) Create a stored procedure to identify user e-mails with...

Hey Juanita,

I corrected the UPDATE statement in the code in my previous post.  I noticed that I originally posted the UPDATE like this:

  UPDATE SQL_Table a

    SET <pairs of "sql...

Hey There Juanita,

The approach you mention about loading the Access data into an auxilary SQL table and then working off that table seems like a reasonable approach.  I...

Hey barcoder,

Check out this SQL to see if this is what you are looking for or helps you get there:

SELECT

  P.Productcode,

  PlantName = MIN(F.PlantName)

FROM

 ...

hey egnagey,

try adding the following HAVING clause to your SQL to see if that is what you are looking for:

SELECT

  tblroofs.roofid, cap.estimatedcost as CapCost, cap.estimateddate

FROM

 ...

Yeah, I've seen this too for the case posted ...

It seems as if though SQL Server is expecting the start_value and end_value of BETWEEN to be the same...

Hey jmarg,

You would have to resort to dynamic SQL to be able to concatenate @filterCMD.

From looking at the code posted, you could do this:

IF @filterCriteria LIKE 'w'

 ...

Hey Jordan,

SQL for this might be something like this:

SELECT

  *

FROM

  Some_Dates_Table

WHERE 

  DATEDIFF(year, someDate, GETDATE() ) = 1 AND 

  DATEPART(week, someDate) =...

hey joe,

you would have to resort to dynamic SQL to be able to do this.

so your proc would look something like this:

CREATE PROCEDURE dbo.usp_product

(