Hi Can anyone please help me ceate a logic (and SQL syntax) for this. I have a table which has the 1st column as some Primary key and the rest of the columns has integer values stored in them (there may be any no. of columns with the integer values). Now, I want to read the values in each r...more >>

Hi, Can someone please show me how to execute a stored proc which has been assigned to a variable. I have a table of stored procedures and I want to pick out a certain sp, based on a set of criteria, and execute it dynamically. I'm thinking of setting up a CURSOR to loop through the selected ...more >>

I have a student table that has student name, subject and marks. I want to write a query that returns 2 highest marks of each subject and the name of the students who scored those marks. All are welcome to send their comments. ...more >>

Hi, I have a table Name_Note: create table Name_Note ( id varchar (10), Note_num int, Purpose varchar (20), Note text ) With values Like ID Note_Num Purpose Note 1239 2 Outlook Note1 1239 1259 Outlook Note 1 1432 ...more >>

Hello, I am writting a stored procedure that adds records to a table where some of the field data depend on a couple of fields from a second table. I am trying to assign more than one columns from a query to multiple local variables... DECLERE @var1 int, @var2 int SET @var1 = SELECT ...more >>

I'm trying to write a proc to delete a row from a table whose primary key is a foreign key in 4 other tables. If there are no occurances of the value in the other tables I want to be able to return my own message back to the application, but I can't seem to suppress the SQL error message: ...more >>

Evening Folk ... Have an Active/Active cluster of SS2K (SP3) on Windows 2003 server. I have an SP that runs great on one node of the cluster BUT FAILS on the other node of the cluster. So in all the DBs (over 50) on NodeA the SP runs and returns the result set. On NodeB , in all the DBs...more >>

There is a table named [Attach] has a column named [Content] , and it's data type is [image] ! It record upload file ! I define another column named [MyFileType] to record upload file's type ! Now , I upload a excel file and it contains a word "SALI" ! The [Content] record the excel file (it's ...more >>

Hi, People, help me with problem to make the query qExpectedRESULT I will accept any suggestion and suppositions! Possibly use of User Defined Functions it is a right way ? -- START of DB Objects CREATE scripts ----------------------- CREATE TABLE [dbo].[Customers] ( [AG_ID] [int] IDE...more >>

I have a SQL 2000 satabase that has multiple administrators for it and I need to know when a new user is added to the server. Can you provide some suggestions on how to accpmplosh this task?...more >>

I need to dinamically select a column in which to insert based on a parameter, I have this code, but it throws an incorrect syntax error. The value that I'm inserting is always static (the current date) what I need to be dynamic is the column in which it'll be inserted. How do I dinamically s...more >>

Ho do I pass any of the following chars (<, >, ', &) in an xml doc. For example I need to pass the char: & inside the bellow string: ''abcde'' spTest @XMLDOC = '<IPS> <IP> Comment=''abcde'' </ip></IPS>' I am using sql2000 sp3a Thanks, Yaniv ...more >>

What is the best way to stoe the length of a movie? .NET has a TimeSpan entity; does Sql Server have anything like this?...more >>

Hi All, Say I have to use Cursor on a large table (T1) operation. I need to update the records row by row. Here is the two options, please help me verify which one is faster. Option1: Declare an updatable cursor based on some less-changing(almost unique) columns, using WHERE CURRENT OF...more >>

I'm designing a database for a medical research group in a university medical center that studies organ transplant patients following surgery. There is no existing database and all data is currently recorded on a lengthy paper form. The paper form has hundreds of checkboxes as well as dozens...more >>

Hi, I need to make a date difference in hours I have a function, there are declared parameters (datetime type) but the difference is still in a different type (even if its declared as int) ....... declare @date1 as datetime --system date, time declare @date2 as datetime declare @dif ...more >>

Hi, We are upgrading our network, servers, etc. On top of that, our new domain will be different due corporate restructuring. What is the best way for us to move our databases from one machine in Domain A to another machine in Domain B. Both domains are in the same physical location. We...more >>

I'm trying to build a "derived" query from 2 seperate table a Build count table and a defect table I've done this before but never with the calculated columns as in Year(TestDate) as 'Yr'. It fails and returns Server: Msg 207, Level 16, State 1, Line 17 Invalid column name 'YR'. Any help ?...more >>

hi, Im tryinf to fix in to the function date different. One of the date is in the declared variability and the other is current day why select datediff(hh,@datetime,getdate()) doesnt work in the function? It responds : INVALID USE OF GETDATE WITHIN A FUNCTION Thanks in advance ...more >>

Hi, I have a table T with 3 int columns, I need to update it every X hours with a query that returns the same 3 int columns. Currently I'm doing it using a cursor iterating over each row and checking whether I need to DELETE/UPDATE/INSERT it, this however isn't very efficient. So I tested 2 ad...more >>

Hi im working on a simple function. I have a table with two columns (datetime) and I need to extract date rom one of them and time from another one - and then to join it and save it in the variable (which is declered as a datetime). Please, can somebody help me or advice another waz how to get...more >>

I'm performing a particular word Search in MS Word, Text, PDF docs and displaying the results through Index Server linked to SQL Server when it is matched. For which I'm using Openquery in the stored procedure which works fine in Query Analyzer of the SQL Server but doesn't work ( shows non...more >>

hi frnds of this grp, i am new to this grp. i will xplain my problem. please help me out from this. my problem is: i want to install a sql in one system(i mean i want to make one system as server) out of 5 sys i have. they all are in network. now how can i install tht thing in order to have ...more >>

Hi everyone, i am in seek of help. I have a variable (called status) of type char(10). This needs to be extended to type char(11) and i need to append the character 'N' at this position. For example, if 'status' is any of the following strings of type char(10) NYNYYN NY NNYYY Y NNNY ...more >>

Hi, I want to use UserDefined format for my CLR UDT and I need a formula to calculate its MaxSize. Thanks in advance, Leila ...more >>

Hi, I am trying to use Point UDT from MSDN. But when I insert a null into this column, my SELECT on the table generates an error: An error occurred while executing batch. Error message is: Data is Null. This method or property cannot be called on Null values. Any help would be greatly appreciat...more >>

Hi, MSDN describes that Name property of Microsoft.SqlServer.Server.SqlUserDefinedType is not used by SQL Server, but by VS.NET IDE. I have set a name for my UDT, how can I see its effect it VS.NET IDE? Thanks in advance, Leila ...more >>