ragie (1/15/2010)

---

hi,

I am writing a stored proc where I query a table for a distinct list of values. & then for each row returned, i need to insert a...

Mauve (1/15/2010)

---

And it is best to answer later in the day as the question is usually...

Love you must the easy ones.

Welcome, you are. Any time.

Ready to smack yourself on the forehead??

SET @start_dt = (SELECT dateadd(hh, 19, dateadd(day,datediff(day,0,GetDate())- 9,0)))

SET @end_dt = (SELECT dateadd(hh, 19, dateadd(day,datediff(day,0,GetDate())- 2,0)))

Do the two select statements in your original post get you the correct starting and ending dates (not asking about time)?

I don't read the QotD in the newsletter, I read it on SSC.

In a test environment, try this:

delete from dbo.Table1

from

dbo.Table1 t1

left outer join dbo.Table3 t3

on (t1.OrdID...

Does the database have full-text catalogs?

Kevin Gill (1/15/2010)

---

In fact, I'll go further (and you can't stop me ;o))

Whenever I miss the intended point of one of these questions, it's usually because I've not paid attention...

Kevin Gill (1/15/2010)

---

To my mind, this question could/should have been moderated and edited to make it clearer.

Even though I would have got it wrong had it actually been asking...

A thought I had, what if the DBA interviewer was actually trying to see one or more of the following:

1) How you handle pressure/adversity

2) How much training will this candidate...

This query could possibly be tuned if you would provide the DDL (CREATE TABLE statement(s)) for the table(s), sample data (as a series of INSERT INTO statements) for the table(s),...

If your database is using either BULK_LOGGED or FULL recovery models, you need to set up transaction log backups to manage the growth of the transaction log. If you...

In your case, you need to remove the commas from the string. I'd also recommend using the date/time style, especially if you know the the dates are all formated...