Hi, below is a not so elegant attempt at displaying 5 rows into a column for each. I won't know how many rows there will be for the query so this must be calucualted on the fly, thus I have used a cursor to do this. Two questions. 1> Why is the concatinated string being used as the select ...more >>

Hello. I have a application that will accept parameters from users. I'd like to give them a way to build dynamic parameters that substitute strings with formated dates allowing them to define Parms that are date smart. Say they define some sql that results in the desired date and format.....more >>

Hi guys I have a few tables to do with accounts and balances. I will never want a negative value in balance and so as well as front end code protection i would like to do a double check by making the database never allow such a occurence. I update one table which fire a trigger to deduc...more >>

I have a single table that contains about 2000 records of asset (vehicle) position information. The data is fed in quite often as each asset's position is updated. I would guess that each asset might update it's position as often as once every four seconds. I have a view with a simple se...more >>

In SQL Server 2005, I'm running this code with no errors: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo]. [#mytmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[#mytmp] but when I run this code, it says #mytmp already exist: CREATE TABLE #mytemp ( s...more >>

Hello... I want to be able to have a T-SQL script that when a name of a view is passed to it that the query then generates a result set that lists ALL underlying tables and views within the view name that was passed. So basically I want to see what tables and other views that referenced fo...more >>

Alguien habla españoool???? ...more >>

I'm trying to create a view that will display the contents of a table in a more user friendly way. I have tried may different variations of self joins and subqueries, but I'm striking out. Here is an example of the table/data. RECEIPT_LINE_QTYS table KEY RECEIPT_NUNMBER LINE_NUMBER QU...more >>

providing the following table structure: CREATE TABLE [dbo].[PRODUCT]( [ProdID] [nchar](10) NULL, [Cat] [nchar](10) NULL, [Product] [nchar](10) NULL, [Dept] [int] NULL, [Qty] [int] NULL ) insert into PRODUCT values('PR1','Cat1', 'Fruit', 1, 15) insert into PRODUCT values('PR1',...more >>

I would like to know the best way to handle errors when creating a connection to a DB in Vb 6.0. What will be the best way to handle the errors? Should I set both the connection and recordsets objects to "Nothing", if an error ocurrs? Shoud I try to close them first, and then set them to noth...more >>

Hi guys, Could you please tell me why this script return me an error when @var1 is not numeric. DECLARE @var1 CHAR(11) SET @var1 = 'R0002345432' SELECT CASE ISNUMERIC(@var1) WHEN 0 THEN @var1 WHEN 1 THEN CONVERT(INT,@var1) END Server: Msg 245, Level 16, State 1, Line 5 Syntax err...more >>

I'm trying to report on record counts meeting a certain criteria. If there aren't any, I'd like to see a row with all zeroes for the 8 weekly columns. The only way I've been able to do it so far is to use constants and UNION. I'd like to SELECT classification, but force the inclusion of all va...more >>

Hi, I have a query like this: USE pubs DECLARE @au_fn varchar(1000) SET @au_fn = " 'Johnson', 'Marjorie', 'Cheryl', 'Michael', 'Dean' " SELECT * FROM Authors WHERE au_fname in (@au_fn ) How can I assing multiple values to a variable and use it WHERE colName IN (@Variable) type of claus...more >>

All, This one has me scratching my head. There's a stored procedure in our main web application that is timing out a couple of times a day. When I go to the server and run it in management studio, it returns it's result set almost instantly. I look at the sql being submitted to the server in ...more >>

Is it possible to store select query result into a varchar variable with comma or semicolon separated list. e.g. I want to store results from following query Select Email from tbl_Users into a variable @EmailList i.e. following query result Email test@test.com test1@test.com t...more >>

Has anybody had luck getting IronPython assemblies to work in SQL Server 2005? I can't seem to find a definitive answer on whether or not this is possible. vic ...more >>

I have a simple SSIS script Task.. suddenly I'm getting warningss like this: SSIS The dependency EnvDTE could not be found. Warning 2 The dependency 'Microsoft.SqlServer.VSAHosting' could not be found. Warning 3 The dependency 'Microsoft.SqlServer.DtsMsg' could not be found. I also ma...more >>

I am running a query across a linked server and it is running drastically slow. Is there a way to speed it up or are there settings that bog down the execution time. Which tools would best suit me me to troubleshoot performance issues. Thanks ...more >>

Do we need to enable AWE in Windows X64 for SQL 2005? I have SQL 2005 on X64 with 34 GB of Memory. Thanks in advance Nitin Any whitepaper on configuring memory management on X64 is highly appreciated...more >>

I have a table similar to this: appnum units 1 1 1 4 2 null 2 null 3 2 3 null 3 1 I would like to be able to count the number of units = 1 and group by appnum. appnum 2 should return 0 result set ...more >>

I downloaded 90-day trial version of Visual Studio 2005 but this thing is only in .img file format and Microsoft does not provide any extraction utility for .img files. According to this page (related to another software with at least alternative.iso format) http://msdn.microsoft.com/vstudi...more >>

Is there a way to encode nvarchar to UTF8 so that I can retrieve stored procedure code from SQL Server? the following SP doesn't work - I get an error like: "Msg 245, Level 16, State 1, Procedure spGetDDL_SP, Line 14 Conversion failed when converting the nvarchar value " --- ALTER PROCED...more >>

I understand that SQL Server 2000 defaults to row-level locking and the query optimizer will upgrade that to page, or table level locks, when it thinks it's approporiate. However, I have found refernces to the OPTION clause of the SELECT statement that says I can tell the query optimizer it mu...more >>

Ok, I know this should be simple but I'm having a lot of trouble making this work... The file I'm trying to query is a historical order file. Any order entered or changed has a record, so if somebody calls in on Monday and orders 10 items of PM123 a record is inserted with an order_line_it...more >>

I'm adding invoicing capability to an existing app and before I built any tables, I have been doing a bit of reading on the need to store historical information for the invoice. It has been pointed out, for example, that after output, perhaps a customer's name or address might change and thus ...more >>

Could someone, please review my posting dated 2/13/2007 subject is 'SELECT Query in SQL Server 2000' and help me out....more >>

how to handle if select has error consider this scenario i have created one table create table test(testid int , description varchar(50)) i created sp create proc p_test as select * from list i have renamed table name as table 1 how t o handle this error insi...more >>

Sorry for this probably stupid question, but "one has go to ask to learn"... I'm trying to call a stored procedure using exec sp_executesql. It look something like this: CREATE PROCEDURE sp_myProc(@txt) AS ....do something simple here I then try to call cp_myProc like this: DECLARE @...more >>

Hi all i want to know is there any way thought which i can get the last accessed table from the database along with the time of access im using sql2000 Thanks for replying me ...more >>

select F1 from T1 cul minus select F1 from T1 cul where F2 = 100; This Query is in Oracle , I need common Query which will run on Both Oracle 9I and SQL Server 2000...more >>

Hi, While experimenting with CLR stored procedure, I discovered it won't populate the fields in the TableAdapter, like a normal stored procedure. Why is this? GetClientList = normal stored procedure GetClientListTest = CLR stored procedure Both contain the same SQL, "SELECT * FROM Clie...more >>

I'm getting an error "Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.". I've written a test app to reproduce this error and can reproduce it easily. In fact it happens twice as often as it is ...more >>

Since I have primary keys on all tables is it still recommended that I have clustered indexes on those tables as well? Thanks, Kevin ...more >>

I am getting this error: Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1. Here's the code: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROC [dbo].[sproc_SCMPostTicket] (...more >>

Hi, Here is the script i am having DECLARE @nSQL VARCHAR(8000) DECLARE @hdoc int SET @nSQl = '<?xml version="1.0" encoding="UTF-8" ?> <XML DocSize="123k" > <Category AppliedTo="Software Engineer" name="Location Code"><![CDATA[United States of America]]></Category> <Category AppliedT...more >>

Bonjour, Je recherche un logiciel pour générer de la documentation et naviguer dans le modèle de base de données. A je jour, le seul produit qui ressort en permanence est celui de Red Gate's, mais il doit bien en exister d'autres ????? Merci de votre aide. Cdt. Gislain ROCHE ...more >>

I'm having a problem with getting my execution plans to show when there are temp tables involved in the query. I have read that I can execute SET STATISTICS PROFILE ON inside the query and that will allow me to see my plan, but I still cant get it to work. Can anyone shed some light on this ...more >>