User Profile

enfuego

Last Activity: Jan 15 '08, 03:58 PM

Joined: Jan 4 '08

Location: Akron/Canton OHIO

enfuego replied to Select Case Where Like?

in SQL Server

Jan 15 '08, 03:58 PM
Thank you for the reply. It seems to be working so far. I have to build some fill DB w/ dummy data to fully test but I stopped getting error codes. Thank you again....

See more | Go to post
Leave a comment:

enfuego started a topic Select Case Where Like?

in SQL Server

Jan 14 '08, 06:46 PM

Select Case Where Like?

Hey kids, got a problem. Here's the code:

Code:

Rev.techCompany CASE WHEN techCompany LIKE 'North_IR' THEN 'NorthIR'
	   	WHEN techCompany LIKE 'South_IR' THEN 'SouthIR'
	   	WHEN techCompany LIKE 'East_IR'  THEN 'EastIR'
	   	WHEN techCompany LIKE 'North_[^IR]' THEN 'NorthContractor'
	   	WHEN techCompany LIKE 'South_[^IR]' THEN 'SouthContractor'
	   	WHEN techCompany LIKE 'East_[^IR]' THEN 'EastContractor' END

...

See more | Go to post

enfuego started a topic Nested SELECT FROM WHERE AS IN

in SQL Server

Jan 4 '08, 07:55 PM

Nested SELECT FROM WHERE AS IN

The code below give an error of

Code:

Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '='.
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '='.

I Am not sure why. Plz advize. Thank you in advance.

Code:

SELECT     xxx.reviews.id, xxx.reviews.techCompany, xxx.reviews.jobSummary, xxx.reviews.inspectionDate, xxx.callTypeReview.reviewId, xxx.callTypeReview.callType, 
xxx.findingsComments.reviewId,

...

See more | Go to post

No activity results to display

Profile Sidebar

Leave a comment:

Select Case Where Like?

Nested SELECT FROM WHERE AS IN