quote:

---

it seems vb's day 1 start on 1899-12-31, and sql's on 1900-01-02. i've played around with some settings and it seems that...

Hi Dale and Ritch,

I've missed your long and indepth explanations, Dale

However, to claim the longest post I think you have to beat Antares686.

A small hint:

Unless...

Hi Robert,

quote:

---

I need to insert a date+time value from VB into a datetime field. I do not want to use a formatted...

Hi Dale,

I always thought 'associate' is only used with business meaning.

Can I say: '(S)He's my buddy' when it is not so official?

Cheers,

Frank

Yes, TRUNCATE is faster than DELETE.

Not sure what DROP and (re) CREATE TABLE do

Cheers,

Frank

quote:

---

Never mind! Don't you just hate software that doesn't do what you want it to do?

---

Hi Patrick,

quote:

---

You rarely say "This is an acquaintance." when introducing someone. It means that you don't know them and have only met...

Hi Tim,

quote:

---

SELECT @str = 'SELECT TOP ' + Convert(varchar(10), @topn) + ' * FROM #tmpIncentive ORDER BY ' + @sortcolumn + '...

Hi Tim,

quote:

---

I realise this makes it all the more important to use an Order By clause, but I really don't want to...

Hi Mark,

quote:

---

Without an ORDER BY in your SELECT statement, SQL does not guarantee the order in which rows are returned, regardless of...

Hi Tim,

quote:

---

I'm trying to create an index dynamically on a temp table in an sp. I can build the statement happily but...

Hi Jac,

quote:

---

I am in an in house project, so fund allocated for this. I am sorry !

Any alternative?

---

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]