Chris (12/9/2008)

---

hi,

I have a table in which the columns are date,count,status

this is what i have

select date,sum(count),status from table1

where date = getdate()-1

group by date,status

order...

Depending on the "width" you could still get into trouble.

So far the fastest way I have seen uses SET ROWCOUNT ...

Let me see if I can find the...

You should post a "sample" of the data 4-6 rows per table is probably enough.

pvar (12/9/2008)

---

Hi,

I have a table with 4 boolean fields. I need to find the records that have more than one boolean field set to true. That means records with A...

There are several options but I think this is what you are looking for.

Be careful if the tables get into the 50+ million rows row_number() may not give you what you need in terms of performance.

This kind of manipulation is tricky when you find people with more than one word in their name like " Kate van der Mullen"

This is just a conventions issue. It will only help if you use standard scripts to access those otherwise it should not matter.

http://blogs.digineer.com/blogs/larar/archive/2007/07/30/smart-index-defragmentation-for-an-online-world.aspx

FROM BOL:

http://msdn.microsoft.com/en-us/library/ms177445(SQL.90).aspx

The relevant Part for your case:

Importing Data from a Single Client (or Stream) into a Non-Empty Table

You should have a rough estimate of how many rows...

This is actually depends on what is the number of characters in a cell containing what you are looking at.

MS EXCEL has a limit which is exceeded by...

Read This

Oblio Leitch (12/4/2008)

---

What I have: id|data|date

1|A|'1/28/08'

1|B|'2/02/08'

1|C|'2/03/08'

1|C|'2/09/08'

1|C|'2/22/08'

1|C|'5/11/08'

1|A|'6/01/08'

1|D|'7/15/08'

1|C|'7/21/08'

1|C|'8/19/08'

1|A|'9/17/08'

What I want:id|data|date1|date2

1|A|'1/28/08'|'2/02/08'

1|B|'2/02/08'|'2/03/08'

1|C|'2/03/08'|'6/01/08'

1|A|'6/01/08'|'7/15/08'

1|D|'7/15/08'|'7/21/08'

1|C|'7/21/08'|'7/17/08'

1|A|'9/17/08'|null

In other words, I want to collapse the data by removing duplicates *only when the data changes from a previous record* and maintain...

It is not a bug in "behavior" but (in my opinion) it is, in terms of what the UI shows 😀

jude.pieries (12/4/2008)

---

- I get the following error when I attempt to create a publication from the wizard

A exception occurred while attempting to execute a tsql statement or...