jacowess,

Look at my previous post and look at your original post. If that's what you're actually running, you have syntax errors in the code.

Jacob Luebbers (1/19/2009)

---

Jeff Moden (1/19/2009)

---

...but would you need to restart the numbering each time a customer changes (or other thing) within the same day as in the original data I...

munishprathap (1/19/2009)

---

Thanks Jeff

according to my requirement i need to keep the one column type as bigint but unfortunately

i keep it as DateTime after long time i found that it was...

Well... does it?

smunson (1/19/2009)

---

Jeff,

After 30 years of having to find ways to get data in or out of computer systems for almost every conceivable purpose, what I've found is that in every...

mohinidba (1/18/2009)

---

Hi this is cluster server .Inthis backup was failed with the erro

can not open the following files

t;\michrosoftsqlserve\mssql.1\mssql\data

all of the data files of the system dbs and user dbs.

and the...

Ummm... what happens when you run just the SELECT?

select NonEmpty [Tests].[Fixed] on columns,

from Cube

where ([Test Date].[Date].&[2009-01-16T00:00:00]

I'm thinking that you have some illegal text in the where clause and you're missing...

How do you know the records already existed in the database? And,...

Two way street here, chum... would you mind telling...

This is absolutely the wrong thing to do. Dates should not be stored as integers.

What are the business rules stating that you should convert the column from a DATETIME...

Perhaps pre-aggregated and dynamic crosstabs would help a bit...

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/cross+tab/65048/

I've had a lot of success with the combination.

If someone else is doing the same thing and are in the process of modifying data, there may be an open transaction that is locking the table and no timeout...

Aren't there about 10 million articles on how to break pwdencrypt() ?

No need for a variable, at all...

SELECT SiteName

FROM db2.dbo.Customer c2

INNER JOIN db1.dbo.Site s1

ON c2.SiteName = s1.Debnr

WHERE s1.Name...

All of that information is available in Books Online, as well.