It...

Krasavita (3/6/2014)

---

by putting these code:

WHERE (CONV_DATE > DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)) AND (CONV_DATE < DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 30))

I get error arifmetical...

Glad that worked for you. 😀

$Raam (3/6/2014)

---

Hi

I Understand, when you delete a row in the parent table, the database server also deletes any rows associated with that row (foreign keys) in a child table.

So...

Krasavita (3/6/2014)

---

Hello,

Can someone please help me

I am trying to get the following information can't get it,I need to get from

field is MAX(CONV_DATE) AS MaxConv_Date

I need get max CONV_DATE...

The best way to do this is what is known as a cross tab. These come in two varieties, static and dynamic. I will demonstrate the static version.

Notice how I...

yuvipoy (3/6/2014)

---

As i said

TableA C1 uniqueidentifier (PK), C2 uniqueidentifier, C3 ......

PK is a cluster index

TableB C1 uniqueidentifier(PK) , C2 uniqueidentifier (FK_TableA_uniqueidentifier ), C3 ......

Column c1 PK is a cluster index...

Yes it just another way to alias a column. 😀

Hi and welcome to the forums. Can you post this as consumable ddl and sample data? Take a look at the first link in my signature for best practices when...

SJTerrill (3/5/2014)

---

It seems SQLServer draws a line at a given precision (I guess it's 16) for the floor() function when interpreting strings that 'look' like reals... it starts to round...

hlsc1983 (3/5/2014)

---

Sean Lange (3/5/2014)

---

hlsc1983 (3/5/2014)

---

i have a query regarding my database design. The snapshot of my database was posted in my earlier post.

In my database i wanted to include a...

Nice job posting ddl and sample data.

The reason that nobody has offered any advice yet is because your question is totally unclear. This to me looks like a denormalized...

hlsc1983 (3/5/2014)

---

i have a query regarding my database design. The snapshot of my database was posted in my earlier post.

In my database i wanted to include a table called 'Subjects'...

yuvipoy (3/4/2014)

---

It is Non-Clusterindex

object_id name ...

Seattlemsp (3/4/2014)

---

First, thanks again all respondings!

Second this is not a homework from school. I greatly simplified the table structure. We have a security setup challenge. I need to find...