I've had zero problems.

If you post the query you're using it's possible someone would be able to see where something is amiss.

Generally I think it's better to create a specific account that you want to use for your web application to access your SQL Server rather than using the built-in machine...

The request isn't altogether clear, but the way I'm reading it is that you're looking for the people who went to the last event as their first event. If...

Use this same application to fire off the SSIS package that will do...

Not sure exactly how you want to do groupings and the data you provided didn't exactly match up with the results but hopefully this will give you an idea of...

I wish they had the Internets back when I had homework assignments!

Please do not cross-post the same questions. This thread can be found here.

So you want to grant NTFS permissions via T-SQL?

Are these homework questions?

Put together table definitions (as I have done above) for all of the relevant source tables. Then write out the script to insert a meaningful amount of data into...

hawg (6/3/2010)

---

I would love to add an index but this is a third-party database so it's not going to happen - at least not by me. The vendor would...

You need to add the date column to an index. You won't...

In the future it helps to put together table definitions and insert statements so people can more easily help you:

create table #table2

(

CustomerNum int,

PostDate datetime,

OfferAccepted char(1),

OfferName1 varchar(10),

OfferName2 varchar(10),

OfferName3 varchar(10)

)

insert into #table2

select...

declare @ByName varchar(25)

declare @BySpecID int

declare @ByOfficeID int

declare @ByCity varchar(25)

declare @ByCounty varchar(11)

set @BySpecID = 21

set @ByName = 'r'

set @ByCounty = 'Albany'

select *

from #NameList

where [Name] like '%' + @ByName + '%'

and [City]...

Am I completely crazy or did you ask pretty much the exact same question in this thread, which is complete with an answer that went completely unrecognized?

Personally this is something I would do on the application side. You would need a separate set of tables to hold the data you need for your application to...