I have a date string such as "Tuesday, December 04, 2007 8:41:38 AM" that needs to go into a datetime fields in SQL Server 2000. Is there an easy cast or convert statement to get this into t...
When I try to do this, I get an invalid syntax near ',' error. Is this not possible? I am just trying to get a count of how many insurance claims each individual member(memid) has for each pr...
I have created this trigger below to audit updates and inserts to my table, I also want any updates or inserts to be copied to another table called labdata, and then logged in my audit table. ...
I get the following error when I execute the following statement
SELECT *
FROM OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\temp;','select * from ...
What's wrong with following sql
Declare @Decimals Integer
Declare @Digits Decimal
DECLARE @myval varchar(9)
Set @Decimals = 3
Set @Digits = (9 - @Decimals)
SET @myval = 193.57
s...
Can somebody help me with this error :
//===STORED PROCEDURE CODE START
CREATE PROCEDURE web_ApplyCallCharges_Intl
@Month_Table varchar(50),
@Call_Zone varchar(5),
@Call_Type varchar(...
is there anyway to get an Optional Inner join in sql 2005
I am trying to get this stored procedure to return all Departments with a supervisorID specified or if the supervisorID is null
Now ...
Hi,
How can I get the 50 to 100 records of a select query (something like "rownum > 50 and rownum < 100" in Oracle)?
Thanks
I have been asked to fix a load of records which were broken by a bug in a recent software upgrade.
I have identified the relevant data, and created a sort order column xkey...
I have a ...
If you need to alter more than one column in a table, does MS SQL support doing this in one ALTER TABLE statement?
Or is it necessary to use multiple ALTER TABLE statements?
To try to resolve deadlocks in my DB, as per recommendations in BOL and MSDN, I'm going through my transactions, and, in cases where they:
1. select rows from a deadlocking table
2. do lo...
I am looping through a list of tables in a cursor, and for each table name I fetch, I need to check whether a particular column exists and do something if it does NOT... here is the basic synt...
How can i alter column in order to enable IDENTITY for a column of type int?
is there any way to disable IDENTITY of a Column?
thanks
I have a table with over 4000 rows of data, each with one leading white space.
Q. How can I trim the leading white space in the existing table or insert the data into a new table without t...
We are in the process of moving from a production SQL 2000 box to SQL 2005. We have multiple dbf files downloaded nightly to the SQL 2000 box. I created a bat file to copy them to the SQL 20...
I'm attempting to write a function that will provide me with next day of a given date. For instance, if the date I have is April 8 2004 (thursday) and I need the first monday following that d...
Hi,
I have a column in our call management database called ElapsedTime and it is the number of minutes an action took its datattype is an INT. For example in the call management application...
I have an SP that uses a cursor to transpose records into one line. We're trying to avoid using cursors, but it's all I could come up with at the time. Is it possible to transpose data using...
I have manually changed the service account for SQL Server Agent Service, SQL Server integration services, ful text indexing service from the local system account to a domain user account. The...
Hi,
How can I convert hours into minutes eg, 02:35:00 = 155:00
Can someone help me get the correct syntax for BCP? I want to BCP results from a select all on a temp table to a csv file on another server. The destination server is named instance, if tha...
Hi,
When we run sp_who2, there will be status column available and results with few status..Can someone explian means of suspended status?
I run the dbcc opentran and found the insert sta...
I am getting an error when i try to parse the query:
Server: Msg 2714, Level 16, State 1, Procedure ap_rpt_chunit, Line 32
There is already an object named '#baseline1' in the database.
S...
The problem described occurs under SQL Server 2005. This problem did not exist using SQL Server 2000.
My production environment has two computers, each of which is running an instance of SQ...
Hello,
I am running SQL Server 2000. I made a T-SQL job that is supposed to count the number of results for a given query and if the result = 0 execute a select statement. It seems to be...
