I'm not really sure what you're trying to accomplish. Can you provide table scripts and inserts as well as what you've already tried? Here's a link on best...

you can try Visual Studio (need database edition) or RedGate

Not realy sure what you're looking for. Do you want to delete the data before loading? Reseeding has to do with a table that has an identity column....

declare @vdt_date smalldatetime

set @vdt_date = getdate()

set @vdt_date = '2009-09-30'

set @vdt_date = '2009-10-01'

select @vdt_date,

case when month(@vdt_date) >= 10 then

...

select max(id) id , name, max(version) version

from versions

group by name

you can use a proc with output parameters. Then you could use some logic on the month to determine which fiscal year the date is in

You can use a CTE to accomplish this, but I think you should read the link provided by Lynn first.

do you have any table layouts, data that you could post?

you have to remove the criteria from the query. You can place it in a case when statement and use sum instead of count

SELECT department, sum(case when salary >...

I think I might be missing something, but it looks like all the joins are going against the QALS table, so you don't need the inner join. Couldn't you...

There is an SSMS tool pack that you can install as an addin to SSMS. That allows you to color code each connection. You can find it here...

Once you find the max price then you can find the max date. Try this

declare @tbl table

(

sort int,

type varchar(100),

date datetime,

price decimal(12,2),

...

Here's one way, but if the source table is large could be a performance nightmare

--===== If the test tables already exist, drop

IF OBJECT_ID('TempDB..#mysourcetable','U') IS NOT NULL

...

You can use a cte with row_number to order and get the days. Here's an example using your data

create table cust (CustomerID int, OrderID int,OrderDate smalldatetime,DaysBetweenOrders tinyint)

insert into cust...

you can group by fields that are not in the select clause. Results won't make much sense, but sql allows this.

SELECT a,b

FROM #temp

...