I've taken over the job of administering our main SQL instance we use for our ERP application (Dynamics NAV) The install has many files listed in the...
We have a large ecommerce application. The product inventory, order workflow etc... is handled by Navision...
I have a bunch of PhoneDeals in my vDeals view... when i query this, i do something similar to: select * from vDeals where HandsetID = '1234' This...
Hi, I've currently got a view, that uses this statement: SELECT DISTINCT h.Name, h.Manufacturer, h.Model, h.HandsetID, h.LaunchDate, h.Features,...
long post alert... I have a few tables in my database, which represent data i get from a txt file, which i import every day using bulk copy. there...
Hi, I use the following SQL to import a CSV file- BULK INSERT tableName FROM PATH_GOES_HERE WITH (FIELDTERMINATOR = '|', TABLOCK) works great,...
I have something similar to this: ProductID (int) Yes (Bit) No (Bit) Basically, each row can either be yes, or no... how can i enforce that?
Hi, We have a number of databses that we develop against on our local machines. We constantly swap our ".bak" files between each other, with latest...
Hi there, Suppose i have a data structure similar to below: LocationID LocationName ParentLocationID 1...
up until now, both SQL Server, and IIS were running one one machine. i have bought a new server, running sql server 2000. this machine is called...
This should be a simple error to fix.... but the server is already set to mixed mode... sql & windows authentication any ideas what else could be...
I have upsized an Access database to SQL 2000. I am now in the process of sorting out all my SQL Queries so that they will work on SQL 2000.... one...
Hi guys, my mind has gone blank... the following sql works fine against an access db: SELECT Name, NameLast, CompanyName, Choice, PictureRef,...
Hi there, i have upsized an access database to sql 2000... most of the tables "Autonumber" fields have correctly been created as identity columns,...
i have a stored procedure that uses a fulltext search to search descriptions. this is a fulltext catalog. i also have another catalog which catalogs...
Hi there, i have the following sql: EXEC sp_fulltext_catalog 'ProductDescriptions', 'create' EXEC sp_fulltext_table 'tblProducts', 'create',...
Hi there, i have the following stored procedure: CREATE PROCEDURE test( @OrderID BIGINT, @OrderComplete BIT OUTPUT ) AS BEGIN...
Hi there, im trying to create a stored procedure to select the number of orders for each product. the table structure is as follows: tblProducts -...
Hi there, i have a Full text search on a table... tblProducts I am trying to query it, to search the descriptions of products.. this is the code i...
Separate names with a comma.
