If (OBJECT_ID('dbo.FIREReportsData', 'Table') Is Not Null)

Begin;

Drop Table dbo.FIREReportsData;

End;

Go

If...

-- Join the weekly and monthly results based off of incident type to produce

-- your result set.

Select W.IncidentType, W.Incidents, Ytd.YtdIncidents ...

Again, it is not a problem. Always glad to help if I am able.

No. I left the table...

Well this turned into all kinds of fun...

The unpivots expect all of the fields to be of the same type. Since we are including comments we had to make...

Apologies, I missed Friday's post or I would have gotten back to you sooner.

All you need to do to add new fields it include them in both portions of...

-- Retrieve by user name.

Select RoleName

From dbo.aspnet_Users As U

Inner Join dbo.aspnet_UsersInRoles As Ur On Ur.UserId = U.UserId

Inner Join dbo.aspnet_Roles As R On R.RoleId = Ur.RoleId

Where...

Though am able to convert tsv to table now..but was wondering why did it truncated the columns when i converted tsv- to excel -to table?

Total number of columns were...

I believe you need to install SSIS on the machine you are trying to invoke the package from.

http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx

How many of your records contain Nulls? Also, you may want to follow a suggestion that was put forth earlier and only update rows that are different. If there are...

Example: date values: 3-20, 4-1, 4-6, 4-9, 4-14

If you start at the most recent date, you'd eleminate 4-9 and 4-1. But if you'd start with the oldest date, 4-6 and...

It is not a problem. Glad to help if I am able.

-- If you already have a variable with the start date, you can avoid hitting the table

--...

Just in case you ever do see complete dupes... Figured I'd throw it in for the sake of completeness.

Declare @Table Table

(

...

Declare @Table Table

(

RowId Int Identity(1, 1)...

i have a problem when the StartDate=StartDate or EndDate=EndDate

like the data sample below

Insert Into @Table (Id, StartDate, EndDate)

Select 'id1', '20081016', '20090531' Union All

Select 'id1', '20090601', '20090605' Union...

Update Table

Set Column = REPLACE(Column, '00000', 'A10000')

Where (CHARINDEX('00000', Column, 1) > 0);

Update Table

Set Column = REPLACE(Column, '00001', 'C10000')

Where (CHARINDEX('00001', Column, 1) > 0);