Search results for query: *

I've been racking my brain on this and after several google searchs and attempts I can not get this to work. Basically the statement works fine but I want to run it daily and do not want it duplicating the results if they already exist in the table. Let me know if you guys can help me figure...

So I'm not sure what happened but I built a windows server 2012 standard running a web server. Sent it to the data center and everything worked great for 6 months or so. One day it wasn't live so I remote booted it and ever since I've been missing a lot of functions and have been resorting to...

Ok basically what this statement is doing is going through all product names in the product table and finding the years and inserting them into a product specification attribute table. The tricky part is the products are all listed like this: Exhaust system for 92-95 Honda Civic. The...

Hello, I have SQL Server 2012 and I can not for the life of me to get this to remotely connect via ODBC or other. I have disabled the firewall, enabled the TCP and Named Pipes in the SQL Server Manager as well as enabling the Remote Connection check box in SSMS. I made sure the SQL Server...

INSERT INTO Product_SpecificationAttribute_Mapping (ProductId, SpecificationAttributeOptionId, AllowFiltering, ShowOnProductPage, DisplayOrder) SELECT Product.Id AS ProductId, SpecificationAttributeOption.Id AS SpecificationAttributeOptionId, '1' AS AllowFiltering, '0' AS ShowOnProductPage...

INSERT INTO Product_Category_Mapping (ProductId, CategoryId) SELECT Product.Id AS ProductId, Category.Id AS CategoryId FROM Product, Category WHERE Product.Name LIKE Category.Name Hello, I keep coming up with 0 results and can not figure this out. I am trying to find Category.Name in...

UPDATE ProductVariant SET Length = (SELECT Table1.Length FROM Table1 WHERE ProductVariant.Sku = Table1.Sku) I keep getting this NULL error code but cant figure it out. There are no nulls in Table1 is there something I should add to the code to make this work? Thank you. Msg 515, Level 16...

CREATE TABLE #files(filename varchar(255)) INSERT INTO #files EXEC master..xp_cmdshell 'dir C:\Inetpub\wwwroot\website\html\images\productSpecific\large1\*.jpg /b' UPDATE...

Ok I havent used Access in a while to actually create something so Im trying to make a sales report. I have two tables: First Table dbo_tblOrders with orderNumber, salesTaxRate, orderShipping, orderTotal, orderDate, shipFirstName and shipLastName Second Table dbo_tblOrderDetails with...

Hello all, I just upgraded servers and we are now using sql server 2008 rather than sql server 2000. I have some scripts to convert since they are giving me errors about "Multi-Part Identifier could not be bound". Below is one of my scripts that if I can get to work Im just I can convert the...

Hello all, I am operating the following dedicated server: Windows Web Server 2008 R2 64 Bit Intel Core 2 Quad CPU q9550 @ 2.83 GHz 4 GB Ram 2 @ 750GB SATA Drives w/ Raid Controller The only purpose of this server is to run 1 asp.net custom shopping cart system website. Times are tough and...

Hello, I have put in place some rules to change my links. The before and after is below along with my webconfig file. I am only having one problem getting the form buttons to carry the correct URL. Click the after link below and change the ZERO to 0 on the domain then try hoovering over the...

Ok so I was running windows server 2003 and had tons of problems when I used the SMTP service to send out emails from my asp.net application. I used the basic POP3 service for my actual emails. Somehow spammers were able to use that SMTP service to send out junk mail to people. I then just...

Hello all, basically I have only 1 dedicated server which will be running my ASP.net shopping cart on it so that online shoppers can buy products from me. Ive noticed there are different versions (even free ones) of SQL Server, what do you guys think the minimum version I can get away with...

Hello all, Im currently using the following script: CREATE TABLE #files(filename varchar(255)) INSERT INTO #files EXEC master..xp_cmdshell 'dir C:\Inetpub\wwwroot\company\html\images\productSpecific\medium1\*.jpg /b'...

Hello all, I cant figure this out for the life of me and Ive tried a variety of different settings. As of right now if I restart my server my ram will slowly run out until programs start to crash. I finally narrowed it down to my SMTP being used to send out massive qty's of spam to people. I...

I have windows 2003 server and i have a basic windwos STMP server setup for a website. The website is an asp.net site and sends out emails from the server when the user submits their email address. I do not want to block SMTP all together but I just noticed that my queue folder was full of...

Ok guys im used to making forms so I cant figure out why my code isnt working on this table im working on. I created a table called tblSPRINTGRIP2 which has a field called make and a field called model. When i design the table I did the lookup wizard on the data field for make so that it would...

Hello all, I am currently using the basic built in Windows POP3 service for my emails. And I am just using my ISP's SMTP server to send mail. It is all working fine but when I go on vacation I can not send mail since I am not on my ISP's SMTP anymore. Is there anyway for me to setup my own...

ok here is the code I have currently UPDATE tblProduct SET retailPrice = tblProductPriceUpdate.retailPrice, jobberPrice = tblProductPriceUpdate.jobberPrice FROM tblProductPriceUpdate WHERE tblProductPriceUpdate.company = tblProduct.company AND...