Classroom SSIS training

Can anyone recommend a live classroom environment SSIS training course? Anwhere in the U.S. would be fine.

Thanks,

Ken

Idea Integration provides hands on training for SSIS, SSAS, and SSRS. I think we have some classes coming up too. Send me an e-mail at jason.gerard AT idea.com and I'll get you the info.|||

You might try Symphic Technology. (Url: www.symphic.com.) They provide training out of Manhattan, NY but also do on-sites.

I saw their booth at Boston TechEd a couple months ago and they looked pretty good.

|||Please e-mail any further training requests to bknight AT whiteknighttechnology.com OR bill.bickford AT idea.com. Thanks.

Classroom SSIS training

Can anyone recommend a live classroom environment SSIS training course? Anwhere in the U.S. would be fine.

Thanks,

Ken

Idea Integration provides hands on training for SSIS, SSAS, and SSRS. I think we have some classes coming up too. Send me an e-mail at jason.gerard AT idea.com and I'll get you the info.|||

You might try Symphic Technology. (Url: www.symphic.com.) They provide training out of Manhattan, NY but also do on-sites.

I saw their booth at Boston TechEd a couple months ago and they looked pretty good.

|||Please e-mail any further training requests to bknight AT whiteknighttechnology.com OR bill.bickford AT idea.com. Thanks.

checkboxlist and SQL search using AND/OR on selected checkboxlist items.

I have a checkbox list like the one above. For example, Training OR Production – should include everyone with an Training OR everyone with a Production checked OR everyone with both Training and Production checked. If service AND technical support – just those two options will show – the customer can only have those 2 options selected in their account and nothing else. Is there an easy way to build the SQL query for this scenario? Any suggestions or tips?Thank you for any help

You can create a procedure that accepts a parameter ('AND' or 'OR), which perform a query based on the parameter:

create proc sp_testQuery @.logicOP varchar(3)='AND',@.id int,@.name varchar(20)
as
if @.logicOP='AND'
select * from t1 whereid=@.id and name=isnull(@.name,name)
else if @.logicOP='OR'
select * from t1 whereid=@.id orname=@.name
else raiserror('You must choose a logic operator ''AND'' or ''OR''',16,1)
go
sp_testQuery 'AND',1,null

Then what your code need to do is just call the stored procedure with providing all required parameters that come from your website.