G Bryant McClellan (2/12/2008)

---

Matt,

Actually I am fully aware of the differences between primary keys and clustered indexes. Having worked with SQL Server since v4.2.1, I've had ample time to explore...

Also - Andy Leonard's article from today outlines pretty much all of the steps for doing all of this using SSIS. You're describing an incremental load pretty much to...

That explains it. There's no drop-down in the non-moderator version, just the checkboxes.

Just wanted to make sure I wasn't missing out on some cool toy....;)

cmcklw -

There has to be some element that matches what you're importing to what's already in there. Meaning - there would need to be some way for you...

I'm not sure that it is. Some of the less intelligent SQL editors will link things blindly based on fields called the same thing, instead of making sure it...

Keeping in mind that you are doing group by in your select (so there are duplicate records being hidden). The fact that you're using the SAME fields in both...

You're missing the FROM

update inventory

set inventory.INV_QTYONORDER = 0

FROM INVENTORY --<<change here

full outer join inventory_supplier

on (inventory.INV_ID = inventory_supplier.INVSUP_INVID)

where inventory.INV_QTYONORDER <> 0

and inventory_supplier.INVSUP_SUPPNUM = 11

I also wouldn't run an update...

jonnie.pettersson (2/11/2008)

---

Adam's solution seems more tested than mine...I'm sure it is 🙂 otherwise I think this will work...but be aware, it's not tested

Select c1.ConsultantID, c1.Level, c1.Title, c1.PeriodEndDate

from @C c1...

Then set up the FORMAT function in the ASP page to control.

There's no truncation going on. The time component is stored as the fraction of a day, so 12:00:00...

Sounds to me like "wrong tool for the job". Meaning - SQL Server is really not designed to do that, and while it CAN be tortured into doing it,...

Brooke -

could you attach a sample of the input file and what you're trying to get out of it. It would help to decipher what it is you're...

What is the data type of the column you are storing this in? If you're storing this in a datetime field, then you can simply use a FORMAT on...

Mike C (2/11/2008)

---

Matt Miller (2/11/2008)

---

That's an interesting thought, but there are times when you might get the same data (say - you're tracking outcomes of consecutive coin tosses). There...

What are you using to access the data? Considering that datetime fields store both the time and the date, what you're getting at seems to be a presentation issue...

pauls2 (2/11/2008)

---

I understand there are times when an identity (not my first choice because of the non-portability) or other artificial key is very helpful. But I don't think...