[OR] clause didn't work, that's the first thing I tried prior to asking.

The data returned is going to be used on reports so no filtering right now, just put on...

SQLKnowItAll (6/14/2012)

---

SQL_NuB (6/14/2012)

---

I'm working on converting an access db to SQL and I came across several Access queries that are the same with the exception of 1 parameter in the...

Thanks, I'll check it out.

it's coming from Oracle. I'm importing it to SQL for dashboards that will be viewed via SharePoint.

How will bulk Insert work via SSIS? I've used it via C# code,...

its being stored as a number(6,0) such as 200109

the URL isn't being stored, its just a string that is being pulled out of the table and then wrapping a link around it

I follow ya, its going to be a nightmare overall

Right now the tables are small, however alot of tables (over 50) so the data is small due to its still in a pilot/beta mode. IMO, the scripts should only...

Thanks for the reply, so my thought and recommendation is good then, I agree dropping and recreating the database everytime will be a nightmare and time consuming. Now if I...

i'm using sitefinity and so far i can't find that setting.

How can I make it work in a tabular query?

select * from

(

select content,

max(case when...

yes its showing 4 hours ahead of the time I enter so if I enter in 2 on the front end of my web app the db is storing it...

I know that, i'm looking on how to correctly create my proc for this scenario instead of having several inline queries in my code

again, performance isn't an issue right now, the table will be at most 50 records at any given time

so what your saying, due to I need to search against 1 table for 2 values won't work?

those values aren't used from a table, they are entered into a table on the dataentry screen.

This is for search only against one table, I have to pass 1...