Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: grippy
  • Content: Threads
  • Order by date
  1. grippy

    How do I turn this statement into an IF NOT EXISTS statement?

    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...
  2. grippy

    Help should I reinstall Windows Server 2012?? Start menu, charm bars, icons all disappeared

    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...
  3. grippy

    Need help on my existing SQL Insert Query

    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...
  4. grippy

    Remote connection issues cant Telnet to 1433

    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...
  5. grippy

    Need some help with my SQL Statement please

    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...
  6. grippy

    New quick help correcting SQL Statement

    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...
  7. grippy

    Quick SQL code help dealing with NULLS

    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...
  8. grippy

    Quick SQL Script Question need a fix

    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...
  9. grippy

    Need Help on Query for Orders. 90% Done just cant figure out the last

    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...
  10. grippy

    went from SQL 2000 to SQL 2008 need help converting this SQL code over

    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...
  11. grippy

    Need help picking correct version SQL Server 2008

    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...
  12. grippy

    IIS 7 Web.config file problem with link rewrite rules

    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...
  13. grippy

    Question about SMTP in 2008 compared to 2003

    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...
  14. grippy

    Quick question on which version of SQL Server 2008 I will need?

    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...
  15. grippy

    Quick Help on SQL Script

    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'...
  16. grippy

    Win2K3 SMTP Settings allowing Spam mail to be sent

    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...
  17. grippy

    Basic SMTP Server ? My Queue is full of junk how do I block?

    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...
  18. grippy

    Quick Question - Problems referencing Table in SQL

    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...
  19. grippy

    SMTP Question on W2K3

    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...
  20. grippy

    Need Quick Help on a SQL Script Addition

    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...

Part and Inventory Search

Back
Top