I'm looking for dates in an SQL table, but the results are incorrect.
The datetime column looks this way by opening and viewing the table in SQL Enterprise:
8/10/2005 9:44:41 PM.
My q...
I made a Conversion Program in vb6 (access to sql) with SQL having no Identitys in the table So i can preserve the RowID and then hoping after the converision to alter the column to put the ...
I want to create a stored procedure in SQL server 2000 with a parameter that will default to today's date minue 30 days. I would also like to ability to over ride the default value in the stor...
Hi,
Sorry, I'm a DB newbie and this probably has a simple answer, but given that it's the week after Christmas there's no one anywhere to be found around here and the MSSQL docs aren't muc...
How do I pass a parameter to the report. Here is my code so far:
Dim paramList As New Generic.List(Of ReportParameter)
paramList.Add(New ReportParameter("paramFurnaceID", "...
Setup:
SQL Server 2005, VB.Net 2005 Windows Application
Problem:
at present i have a VB.Net program that creates CSV files, its opening the datareader and writing to the CSV File. the pro...
Hi Guru:
I work with Oracle but is completedly new to SQL Server. I was required to create database and restore from a dump file (I would think that it likes oracle's import). The dump file...
Hi,
I ran the job and to execute a SSIS dts package in sql 2005 server, I got the following error message:
Thanks for your help!
Date 1/25/2008 4:52:00 PM
Log Job History (Survey R...
Tables
Customer(CustomerID, CustomerName)
Order(OrderID, CustomerID, OrderAmt, ShipTo)
Select
L.CustomerID,
L.CustomerName,
Count(R1.ShipTo) OrdersShippedToTexas,
Count(R2.Ship...
Hi,
I am using a SQL Server 2000 DB, interrogated by Enterprise manager.
I can SELECT as:
SELECT c_AnswerMutli.*
FROM c_Applicant
INNER JOIN c_AnswerMulti ON c_Applicant.id = c_An...
I have the following procedure and i like to declare a copy of local variables
@Operation and @Operation_Access that i can use in the processing.
It is not allowing me to set up these....c...
I run this:
SELECT count(open_time)as Count,DATENAME(mm, open_time)AS Month
FROM probsummarym1
WHERE (datediff (mm, getdate ( ) ,Open_Time) > -4)
GROUP BY DATENAME(mm, open_ti...
Hi Experts
I have a SP that creates a varchar(200) string that creates from a table entry such as (A+(0.75*B)) a string such as (0.093000000000+(0.75*0.004087939911))
I now need to evalu...
hai there
I am developing an applicatin in VB and SQL SERVER 2000
I pass a date value (24/03/2005 10:33:27) from a text box to a stored procedure varchar variable
in stored procedure i w...
I am trying to connect to a linked server and keep getting the error Login failed. Not associated with a trusted SQL Server connection.
When I look at the server the user has permission. ...
Hello,
I just got done building some reports on my report server (local workstation, windows xp) that runs a report from a database hosted on a server 2003 box with SQL 2000 running on it.
...
I have a sql 2000 database that has been made suspect by having the log file deleted then replaced with an older copy. This is what happened. The database went into readonly mode because the...
I realise this question has no doubt been asked and answered many times, however I'm asking it anyway.
I need to convert a varbinary data type to Varchar so the results are viewable to cert...
My SQL Server CPU is pegged at 100% and the only process using the CPU is SQL Server service itself. I have tried restarting the server twice now, and it just immediately jumps back to 100% C...
I'm just curious if someone can give me some info about sp_execute and what it's used for.
Attempting to repair_rebuild database.
1. Stopped SQL services by running sqlservr -m within the command prompt
2. Logged on as Sa within Query Analyzer
3. Executed command Dbcc Checkdb('S...
Hi,
Please kindly assist how can we convert on runtime from EST to CST?
select convert(EST,CST,DTStart) from MyTable
Thanks.
I have a column named "Chain" in this this column has multiple values each seperated by a comma. Is there any way to remove or replace the last value, ie anything after the last comma.
Does anyone know a simpler way to get a YYYYMMDD format using a SQL Server date? I've done the following, but I'd rather have something cleaner:
select left(convert(varchar,benefitStartDate...
Hi
I have this SQL Query
SELECT * FROM [Files] WHERE [Files]='Category\Engineering\Reader Monitor Protocol.doc';
That comes up with the error
The text, ntext, and image data types ca...
