Hello experts,
I have an SQL Server 2000 installation running on a Windows 2003 server. At the moment we have our data files (.MDF) on a RAID-5 array. I have added new hard drives to the a...
I tried the following solution from a previous question (attempting to reseed and renumber the values in the IDENTITY column):
DBCC CHECKIDENT ('leads', RESEED, 100)
where 100 is the new l...
Update Age column from DateOfBirth column for all records in the table?
I have a Age column thats null right now. I also have a DateOfBirth of column. how do I calculate and update the Age...
What command or scriot do I need to age the log files. Basically to stop them growing. I back the databses up every day.
i just want to know which id's that are active in tableB do not exist in the given time frame for tableA. is this correct?
SELECT DISTINCT a.ID FROM tableB b WITH (NOLOCK) INNER JOIN table...
Hello,
I need to know the best way to return the inserted identity in MS SQL 2000. Please note I have considered the follow. If the reason I am ruling them out is invalid, please let me k...
I have a SQL database that was created for one plant to track in house customer production, location, etc. This program has grown and now wants to be used by our other locations as well. The...
I am importing data from flat file every day using dts package. I want to insert a unique batchid for each import. Can somebody please tell me how I can code for this?
Hi
In MS SQL Server 2000, I want to setup a user who can read / write from the database. Which is easy, just assign db_datareader and db_datawriter roles to that user.
But i also want t...
I am trying to convert teh following into a stored procedure.
-----------------------------------------------------------------------------
MyConn.execute("UPDATE tbl_RegUsers SET regUser_...
I am trying to understand what I need to have in place for SQL Server 2005.
Currently, I am running SQL Server 2000 on two Windows 2003 servers and on my development PC.
Before I install ...
i'm sorry, this is getting crazy right now. here's my query:
SELECT EndPoint,LEFT(Symbol,2) AS Product,Client,MsgType,COUNT(Type) AS Count.SUM(Quantity)
FROM .......... o WITH (NOLOCK)
...
I need to Update Price in a bunch of rows by a percentage that can vary, but the catch is that the percentage needs to be of the result. So if the Price is $100 and the percentage were 25% the...
Friends,
I have the following qry:
Select ResultItemID, Lap, SectionTime From
SectionTimes
Where
SectionID=-1
AND SectionTime > -1
AND RunID=3
AND
SectionTime IN (Select Min(Sect...
Here's an abbreviated layout and the associated question. We have 2 Tables:
ItemMaster
CostHistory
ItemMaster has 2 fields:
- ItemID (PK)
- VendorID
CostHistory has 4 fields
- C...
The following code produces this sort of output:
Id like to show only results for todays date how could I do this please ?
All field names are in dutch unfortunately ..
datum_hour_datumaf...
sql v2k, i bulk insert into a view in order to process some data, then push it to another table. that content of that 'data' was changed last night, so i'm trying to bulk it into the table, e...
Hello
In a TSQL stored procedure (SQL Server 2005) I can do something like this:
If (@@Error <> 0)
Begin
to handle an error.
How can I trap a timeout? In my case, I am executi...
We have a server with SQL 2k (deafult) and a shiny new 2k5 instance that I can't connect to!
I thought that 2k5 instances were fair game when it came to connecting with 2k but that I would ...
I have a field in my MSSQL database that is a VarChar data type. I want to run a check on that data to see if there are any invalid currency values. I'm looking for something like IsCurrency.
I am working on a query:
And I do this:
sum(TotalMg) as TotalMGBought
I Would like to add a condition:
Where TotalMGBought > 3600
I get TotalMGBought Invalid column name
How would I write a quey that asks:
Select * from articles
where datepublished = "the current date today"
Experts if you have coding ready available....
I want trigger coding that transfer data only added in last 24 hours from table1 to table2
I have a Webpage that when a Agent accepts a log it puts a '1' in the field agentcontacted
I have a trigger that runs when that field is updated which sends an email out.
Once the email is s...
Hi
Second question in as many mins
Can someone give the me the code to identify rows that are missing from one table but in another. both the tables have a field called houseid.
Cheers
