I have a table that shows activities for different drivers. There is a datetime field that logs the arrival and departure time. During the course of the day the driver can have several start...
I've never writen a stored procedure and it may be years before I write another one.
All I want to do is call a .NET program everytime the IF EXIST reports a new row in the table.
There are ...
Hello Experts,
I want to backup the production server and restore it on the development sql server 2005.
All I wanted to know whether the data on the development will get completely eras...
I copied a table from Sql 2000 to sql 2005. Table in sql 2000 has statistics of this type WA_sys_FRAm_ID_.....
but table in sql 2005 does not have it. What is that and how can I get both...
Experts:
Can someone eyeball this SQL which uses PIVOT and help me with the error? It works find until I try to ADD more that ONE field to the SUM in the PIVOT..???
--Weekly Reserve Data...
Is there a way to loop through field names in a table inside a stored procedure? I want to be able to pass a table name to a stored proc and have it loop through the field names and print eac...
how can i clear a table with enterprise manager? i dont to delete the the table .. just delete all clear all records .. should be an easy question .. i'm not really look for a query .. but mor...
We have a production database (150 GB) that we would like to replicate to another server for reporting purposes. The requirement is to have the replicated data to be as close to the real - tim...
I have a website running on Window 2003 Server and SQL 2000. Let's call this Server A.
I am moving the website files and database to a new dedicated server with a new hosting company. Envi...
Need to backup WSUS and EPO database automatically, therefore need to purchase SQL. Is there a difference in backups from workgroup vs. standard? Databases are below 3GB.
I have the following data in the below tables.
1:SELECT [User_LogonName]
,[User_Password]
,[Order_OrderProductID]
,[Product_IsHitBased]
,[Order_HitsPurchased]...
What I am trying to do is allow the user to return data based off of results being created from a new table. I have 2 tables that I need to join and dump the results into a new table, then jo...
Hi ,
I have an Int field containing seconds that I need to convert into a Time Stamp.
I have managed to select
Select CONVERT(char(8), DATEADD(second, ActualDuration, ''), 108)
From
Ta...
