Viewing 15 posts - 3,076 through 3,090 (of 26,490 total)
Select Inventory_tagalongs.itemnum, Inventory_tagalongs.store_id,Inventory_tagalongs.tagalong_itemnum, Inventory_tagalongs.quantity from Inventory_tagalongs
LEFT JOIN tagalonglist
ON Inventory_tagalongs.store_id = tagalonglist.store_idtagalong_itemnum
Man i...
March 1, 2017 at 3:15 pm
< rant> Why can't people READ the error messages? They may be obscure at times but others actually tell you what the problem resides. </ rant>
March 1, 2017 at 12:43 pm
Insert into Inventory_tagalongs (itemnum, store_id, tagalong_itemnum, quantity)
select itemnum, store_id, tagalong_itemnum, quantity
from tagalonglistsqI do...
March 1, 2017 at 12:41 pm
I like the safety net of an alternative means of access. Also, our application relies on mixed mode to work.
Also, I have worked in environments that used web-based VPN...
March 1, 2017 at 12:38 pm
Sounds like homework and I don't know what version of MS SQL Server you are using so this may or may not work.
March 1, 2017 at 12:28 pm
March 1, 2017 at 9:45 am
Well, hard to say without having more information. It would help if you could provide the DDL (CREATE TABLE statement) for the two tables, some sample data (not production data)...
March 1, 2017 at 9:31 am
Thanks for checking back. I started with the Denver Dumb Friends League (ddfl.org) on...
February 28, 2017 at 8:57 am
February 24, 2017 at 4:38 pm
On something completely different, I was just looking at an internal database built by a developer. If I posted this database schema here you would see Mr. Celko galloping in on...
February 24, 2017 at 1:19 pm
Snow as come and gone today here in Colorado Springs.
February 23, 2017 at 4:38 pm
Image is a deprecated data type. Why do you want to use it instead of varbinary(max)?
February 21, 2017 at 10:43 am
Viewing 15 posts - 3,076 through 3,090 (of 26,490 total)