Hi
Hi I have a query (please see attached code snippet) that loops through a table called CTcontracts, it Loops through each month of the Period selected i.e. with first day of the first mo...
HI Experts
Please look at the attached code, it is an auto-generated code by MS Enterprise Library, Can you explain what is the purpose of the check for @@rowcount value and why if it is 0 ...
I have set up linked server sucessfully.. i can see all the tables and views.. however, when I try to run a query I keep getting below error:
OLE DB provider "SQLNCLI" for linked server "Ap...
How can I add two tables that correspond to each other?
Example
Collum: pvpa.insallocation + pvpa.patalloction
Is it true that each CPU requires 1 x license, if i have QUAD-CORE, means 4 x licenses?
I have a job running on SQL Server 2000 under SQL Server Agent. This job calls a component which in turn opens Internet Explorer and load a page by calling a method on the object. The code ins...
I imported data from an excel spreadsheet into a sql table with data like so 1.000 or .9934 or .9930.
When I import it into a column of Decimal (5,4) it cuts off the zeros. 1 or 993. how ca...
hello
I am using SQL Server 2000. I have a table that has a field called Subscriber. This field accepts English or Arabic Data. I need to write a procedure to do some validation and manipul...
Hi! I have a server that has around 68 scheduled jobs. All these jobs belong to the same application and should execute once a day. Initially the jobs were scheduled to execute at 9:00am, but ...
I am designing a simple database that holds information about routers, switches, ports, and their physical location.
Ideally,
1 router has many switches, 1 switch has many ports, each port...
I'm trying to assess the most secure way to send and receive data from the field to a server with a proprietary application installed (designed to process the data).
Assuming that myself and ...
I usually use Access to work with the data in my SQL Server 2000. Recently I used Enterprise Manager to add a field to a table, then populated the field with data by creating a SQL query in En...
Hello guys,
i have a cluster that has a (push) replication to another server ,both are running SQL 2000 ,replication type is transactional (push only).
the replication is working fine ,but m...
I am trying to find the minimum and maximum date values associated with a specific week # that is returned from the DatePart(wk,SomeDate) function.
I would guess that a function would be th...
Hi,
I need expert advice here. We have offices in 11 states across US and the HQ is in the east cost. We want to import data from 11 remote offices to HQ twice a day. There's only one databas...
Hi Experts,
I have two servers, one is remote, we are relicating (push) to remote... How can I add fields to the subsriber: I don't know replication that much... we don't want to recreate r...
I would like to create a query that looks through a table, and for each unique key in one field, find the newest corresponding date located in another field.
If I have a table such as:
t...
I have growing tables that need reduced by 50% every week or so. I thought about using the sp_spaceused to determine the actual size then somehow use that info to delete 50% of the oldest rows...
Hi Experts,
I have a program (VB6) that quires an SQL table (rsPTR) to get a pointer to point into another table. A user's system reads the table (rsPTR) gets the value, then increments the ...
Im running sql 2005 express on my laptop and have sql 2005 server running on a hosted environment. I need to load the company website (in sql2005) on to my laptop running 2005 express and then...
Hi,
I have an application that I am deploying on a flash drive, so that it can run on any machine.
I need a datasource, can SQLServer Express be deployed like this, or will I have to go w...
how do I remove microsoft hotfix for SQl from my computer?
Does anybody know how to convert in SQL a number from decimal to binary:
Example: F = 1111
I tried select convert(binary, 12.22) but SQL interprets the word binary as Hex.
Thanks a ...
I have this SQL:
SELECT DISTINCT dbo.timItem.ItemID, dbo.timInventory.QtyOnSO AS QtyOnSO, dbo.timInventory.QtyOnPO AS QtyOnPO, dbo.timWarehouse.WhseID
FROM dbo.timItem INNER JOIN
...
I am the proud owner of a single database which sits on a MS SQL 2005 server. I have FTP access to the server from any of our subnets. For an RDP connection, I must leave our office and go to ...
