Hi All, I have created a DB design for implementing WIKI in one of my project. I have created a column of data type NText to store the content of the wiki page. Normally ppl would store the wiki pages as flat files but since my project work on a web farm scenario I need to save the contents...more >>

HI all I have a table that holds reporting data, there is a value field and a report year field. I would like to have the values of current year and previous year and the difference of a particular product on one line. BAsically similar to a pivot I gues where the sumamry is on the value colum...more >>

I have some data like this create table sample_data (id int identity (1, 1), transaction_type int, profit_loss int ) insert into sample_data values (10, 200) insert into sample_data values (11, -20) insert into sample_data values (12, 100) insert into sample_data values ...more >>

Hi, Is it possible to store a set of SQL statements (generated on the fly through server side scripting) to be executed at a certain time? I was thinking of storing a series of statments in a table to be executed at a later time using SQL server agent. Is there a function in SQL server ...more >>

I want to create a table which has co-relation among one column ID Say I have values in a column A, B, C, D, E, and F there is this relation between them A B C D E F A 1 3 4 5 2 7 B 1 C 1 D 1 E 1 F 1 This means co-relation between A, B is ...more >>

I have a stored proc that I need to pass in a comma delimited string. In the sp I am calling a function (ParseString) to create a table variable with the comma delimited values. I need to then use this table variable in my select statements. I must return a single row back to the applicatio...more >>

Hello, Is it possible to create a mechanism where stored procedure is automatically called by the event of ending/committing of any transaction regardless to it's source (something like a trigger ON_ANY_TRANSACTION_END) ? Thank you, VT ...more >>

Hi all, I keep getting this error, and the problem is the Minutes column? Disallowed implicit conversion from data type varchar to data type money, table 'tempdb.dbo.##tmp, column 'Minutes'. Use the CONVERT function to run this query. I'm basically adding the Column names of a table to ...more >>

Hi, when I modify (do some changes and save) stored procedure from SQL Server Enterprise Manager does server keep any trace about this changes? In table dbo.sysobjects there is field 'crdate' with date of creation of stored procedure but I'm wondering is there anywhere date of modification o...more >>

I have the following INSERT command but I only want to insert 1 record when I run it. Can anyone help me with the WHERE clause or? Thanks. -David INSERT INTO product ([prod_seq_nbr]) SELECT MAX([prod_seq_nbr])+1 As NextID FROM product ...more >>

Since we can't backup sql2005 to sql2000, I need to copy all objects from 2005 to 2000. I have already exported all data successfully, but how do you export Stored procedures/functions/ triggers etc. Normally I would creat a script of SPs and FUNCs and run the script file in SQL2000 QA, bu...more >>

Hi, My apologies in advance for this lengthy message. But I've tried to include as much information as possible here incase the scenario needs to be recreated. Our previous DBA had created a stored procedure to gather stats on the data and allocated file sizes for all DBs on a few server...more >>

Hi, I'm having problem bulding the right SQL select with tricky conditions. For example, let's say I want the number of objets by date where (object name is 'something' and the number of command with this object greater than 5) OR (object name is 'something else' and the number of command ...more >>

I am having trouble restore a backup of a 2005 SQL database to a 2000 SQL database? Any ideas? The error I get is: "The backed-up database has on-disk structure version 611. The server supports version 539 and can not restore or upgrade this database. RESTORE FILELIST is terminating ab...more >>

Inadvertently issued an update against an entire table instead of a single row. Anyone have any ideas on a method for rolling back that transaction from the log - to keep me from having to restore of the .bak? ...more >>

Hello, I'm running SQL 8.0 on my local box and I'm having problems inserting a Chinese Yuan character into a record in a table: If I do the following in query analyzer: INSERT INTO MYTable ('=E5=85=83', 'CNY', 1, 'Chinese Yuan') And run an VB6/ASP application that uses the field it doe...more >>

Greetings everyone, I'm having a lil problem with a stored procedure. It always returns twice the same results and I can't figure out why. If anyone have spare time and can have a look, I would be very grateful. Here's the proc : =============================================== SET QUOT...more >>

Can a cursor be declared within a cursor? If yes, then is there anything one need to be aware of when implementing it. Essentially, I'd like to use a cursor to go through each row of one table (containing server names) and then for each server, open another cursor to execute commands to run...more >>

Hi SQL gurus, We have a very complecated query using many tables. To keep it simple we are doing query and puting the result to a #temp table. Then use the #temp table to another query and puting it to #temp2. Then again do the same process until we get the result. It is very difficuult t...more >>

Hello, I need to do a rowcount (this part is no problem) but on the retrun value, I need it to always be four digits long (0001 > 9999), this will then be part of a varchar. What is the best way to do this? Thanks for the help Bryan ...more >>

Hi, I have a table which has doc_id and presc_type_code.presc_type_code can be 'B' or 'G' I want the count of prescriptions by docid and by type code.I know this can be done using case statements rather than subqueries but I am stuck. The output should be docid,noofgenerics,noofbrands. ...more >>

Windows 2000 ..NET 2.0 SQL Server 2005 ADO.NET We have a database on one of our domain servers. When I try to connect to the database via a SQL Server login from any machine in our domain everything works fine... However when I try to connect to the database from a non-domain machine ...more >>

hello, i have a following table with image data type CREATE TABLE Pictures ( picture_id INT PRIMARY KEY, picture_name VARCHAR(20), picture IMAGE ) some of a rows may have picture data and some are not. my question is, how can i use a select statement to retreive the output of the foll...more >>

I'm not sure if this is the correct forum or not, but I have a basic question. Currently we have are doing calculations via stored procedures and then returning the results back to the client in either a web page or a winForm style application. There are times that the stored procedure takes ...more >>

Hi i am using slq server 2000 i want to create update query like that update A set A.col1=B.Col1 where a.col2=b.col2 i used in access like that update A,B set A.col1=B.Col1 where a.col2=b.col2 works fine but with sql server its not working when i use above query its gave me error....more >>

Hello! I have a table (tblBlocks) that looks something like this: startIpNum endIpNum locId 1 3 1 4 424 2 425 424 3 ..... startIpNum and endIpNum represents a range that needs to be looked up in order to fi...more >>

Hello all, Having finally getting a query to run, I discovered it was down to some () around an AND. This is the particular line: ([ExpireDate] is null or [ExpireDate] > @TheDateToday) Without the (), the query will not run. Why is that please? Please not, that the above is 1 of a...more >>

Guys, Been working on a search function, after testing had a few results that didn't quite add up so wandered if you would have a look. The result that doesn't seem to add up is when you try the the below. I've put two examples in there (it says how to comment each out to run them), one wit...more >>

i have read, and think i understand, some of the stuff on traversing and sorting trees and hierarchies using sql. The CTE seems the cleanest method, but a while loop like this one: http://www.sqlteam.com/item.asp?ItemID=8866 is also interesting... however, i have to do something like this on ...more >>

Hello, I need help for the following task and I'm new to this. At first, I made it using C# and doing like 3 recordsets, then parse them to build new recordsets and filter to build the final result. But it's too long and I decided to make a stored procedure which could return the result. If s...more >>

Hi, I'm trying to run the following stmt... declare @server_name nvarchar(50) set @server_name='ABC' declare c1 cursor for select name from @server_name.master.dbo.sysdatabases ::::::::::::::::: ....where in the select stmt of my cursor, the server_name is ref. by its local variable....more >>

Hi, I'm having a little trouble with this query select * from tblv10lcustomer cu inner join tblv10laccount ca on cacustomer.id = cu.customer.id where surname = ('Capper','Jones','Webb') and (groupid = '45') the error that i get is: Server: Msg 170, level 15, State 1, Line 4 Incorre...more >>

Hi All, I am at the end for plausable reasons as to why Running XP_SendMail in a Scheduled Job should miss out the header information Code is a s follows ... Exec master..xp_sendmail @recipients = 'ashah@phonesforall.co.uk', @subject = 'Agent No Sale Reason Report', @message = 'Please See...more >>

Hi, How do we pass a parameter to the cursor ? cursor cursor1(p_sid number) select * from table_1 where ssid = p_sid; open cursor1(10); In the above psuedo example the parameter is passed to the cursor at the time of opening the cursor. p_sid is the parameter passed to the cursor ...more >>

Hi I need a hint for getting <Interfaces> <Properties> identity from table, that have the highest <Priority>, <Group level> and <Role level>. like SELECT TOP 1 (for each interface) .... ORDER BY <Priority> (DESC), <Group level> (DESC), <Role level> (DESC) Interface Properties Priority...more >>

I have some records like that Name email age John a@b.com 12 Veli a@b.com 15 Merry x@y.com 12 Kent d@a.com 10 I want to eliminate duplicate records in email column.. However I also want to have other records which i...more >>

Not sure if this is a mental block or i'm just thick lol I have a query SQL MAX(Revision) as Revision, ln, Version FROM VP WHERE (ln='L0016885') AND (Status <> 'Deleted') GROUP BY lv, Version This return an expected slection set like Revision ln Version 0 ...more >>

When I create some stored procedure in enterprise manager and then edit the syntax in sql query analyzer, I always get the folloewing 2 lines in front of procedure: SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO ALTER PROCEDURE ..... Why? Because this 2 options are set to OFF...more >>