When I add the WHERE clause mGroup

[qwert231]

When I add the WHERE clause mGroup = @Group my query breaks, but when I drop that part (the part in red) it works. Any ideas why?
The mGroup field is a nvarchar(50) field.

DECLARE
 @Job int,
 @Group nvarchar(50)
INSERT INTO #TempTable 
(
  ImageName
)
SELECT 
  ImageName
FROM 
  Photos
WHERE
  Hide = 1 AND JobNumber = @Job

AND mGroup = @Group

 

[hneal98]

Where have you assigned anything to @Group?

 

[SQLBill]

What errors do you get?

-SQLBill

 

[qwert231]

No error. When I execute the SP I pass in an nvarchar value (just a string). Incidentally, I am caling this from ADO.Net.