You have three people on this thread that...

tigars39 (7/30/2013)

---

That column is the tIME STAMP (date and time) that a sample of a reading have been taken. I just genertaed insert statement for the first few rows because...

OK so you have a bigint with a value of "634956975000000000" in every row. What does this value represent? It looks nothing like a datetime value.

Massan (7/30/2013)

---

thanks those are very usefull resources and i use them specially mssqltips.com articles and scripts

and microsoft Virual lab for High availablity labs.

all those resources are availble and i can...

It would be a LOT easier if you could post ddl and sample data.

if OBJECT_ID('tempdb..#Something') is not null

drop table #Something

create table #Something

(

VendID char(3),

Type int

)

insert #Something

select 'ABC', 1 union all

select 'ABC',...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

tigars39 (7/30/2013)

---

Hi

thanks for the reply. I checkd the link in your signature and, am sorry to say that i dont understand how to do that.

I am working on an existing...

Hi and welcome to SSC. Myself and countless others are willing and able to help you. However from what you posted we don't have much to work with. It would...

What you are describing is classically known as the "Bin packing problem". It is very complicated to say the least. There is no easy way to do this and in...

kanchan 58240 (7/29/2013)

---

Hi Thanks for the reply.

Yes. from the query we need to remove 'and'.

The column datetime1 in both the table is of type datetime.

The values which are present are...

smrobin (7/29/2013)

---

So I am attempting to create a clustered index on a view. I am trying to create the index off of the following fields (order_date (datetime), offer_code varchar(3),...

sipadu (7/29/2013)

---

I have an example

create TRIGGER InsertarPeriodoForUpdate

ON dbo.calificacion_IQA

for update

AS

BEGIN

SET NOCOUNT ON;

declare @id int

declare @mes int

select @mes=mes_calificadcion, @id = id_calificacion_iqa from updated

if...

If you are going to use TOP 6 here you MUST supply...

So you work as a DBA consultant and you are looking for free tutoring about the fundamentals??? Something seems very wrong here. For one, you are getting paid for the...

Since you started a new thread and Chris pointed me back to this one I will post here.

I would agree that trying to keep this data in multiple tables is...