Database Newsgroups: SQL Server database programming

Grant Execute!

Mr Ideas Man - 4 Mar 2006 11:59 PM - 4 messages

Hi all, One of my workmates has acciddently changed the EXECUTE permissions for my main login. Is their a System stored procedure or something i can do to give Execute permissions on all stored procedures in my DB to a particular user, without having to do each procedure individually. ...

Compare Dates

Niclas - 4 Mar 2006 11:21 PM - 5 messages

Hi, I have a datetime SQL column wich contains a timestamp from when the row was added using the GetDate() function. I would like to retrive rows based on a comparsion of the date part of this value (discard the hours,minutes etc). ...

Getdate() in UDF column workaround

AkAlan - 4 Mar 2006 10:08 PM - 3 messages

I have a column that needs to display the number of Status hours between Start_Date and either Stop_Date or Getdate() if StopDate is empty. I am using an Access project as my front end and SQL Server 2000 as my back end. I have ...

Unique Values in View

Pablo Montilla - 4 Mar 2006 9:46 PM - 6 messages

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, I need to create a view that returns some data and a unique value for each returned row. What I've done is to concat each field in the view separated with a dot, but its clumsy and I don't like it. ...

help with tsql

ag <> - 4 Mar 2006 8:54 PM - 2 messages

I would like get this result (like bank statement) sample _______________________________ 12/5 previous 100 ...

Data Warehouse Load Hints?

gc - 4 Mar 2006 7:11 PM - 9 messages

(SQL 2000) So if we are loading large tables while no one else is logged in and no other processes will occur, should we provide hints for the table inserts and updates for a performance boost? If so, which hints? Can any ...

Passing an array to sql

a - 4 Mar 2006 3:04 PM - 3 messages

I haven't done sql in a year so I could use some help here. I've got a procedure below that uses the Function (listed under it here) that is supposed to parse a string and pass the parsed string as an array to sql. ...

[Venting]

Mike Labosh - 4 Mar 2006 2:22 PM - 3 messages

So I have this box with SQL Server 2000, Evaluation edition of SQL 2005 which has top be installed as a named instance because of the way that 2K & 2K5 co-exist on the same box, and then there are a couple silly apps I have ...

Please help with update in this scenario

KarenM - 4 Mar 2006 1:26 PM - 2 messages

I have a table - AccountBalancesBudget which as the following columns: Plant Month Year Amount So take an example of one scenario: Plant Month Year Amount =================== ABC,1, 2005, 2000 ABC,2, 2005, 1000 ABC,3, 2005, 1000 ABC,4, 2005, 1000 ...

SQL View into Active Directory

Liam Mac - 4 Mar 2006 12:14 PM - 1 message

Hi All, I have create a linked server into Active Directory which allows me to customize SQL views into active directory. I have got SQL view working perfectly except when I try pull in the description field from AD. When I doing include the description field i get the following error message: ...

Cache problem in Report Services

Raj - 4 Mar 2006 9:07 AM - 3 messages

Hi All, We developed 40 reports using Reporting services, all reports having parameters, data source for all reports are views. I am facing problem of may be cache. I am using url method to show reports, i wrote a ASP ...

Product qty in a given branch

Michael Wong - 4 Mar 2006 7:01 AM - 9 messages

Hi, I'm new to queries and I'm stuck with joins... I have the following tables, and would like to get the total of the products, given a BranchId: table Product ProductId: PK ProductName table Branch BranchId table Inventory ...

Deleting duplicate rows from a table without using temporary table

AlertAdmin - 4 Mar 2006 6:33 AM - 6 messages

Hi all , Can anyone tell me the query to delete the duplicates from a table CASE_COUNTRY Country CountryCode ...

http://www.eznom.net Free and Paid Hosting with cPanel or FTP Account

Eric - 4 Mar 2006 2:12 AM - 1 message

[link] Free and Paid Hosting with cPanel or FTP Account Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- [link] ...

To avoid redundancy in name

ganu - 4 Mar 2006 1:45 AM - 4 messages

Hi, can anybody tell me how to avoid redundany in name while creating a table in sql server 2005.For example let us take a table customer with two fields cno,cname and another table parts with fields brand and part ...

must I upgrade asp.net to 2.0 to access SQL 2005?

HK - 4 Mar 2006 12:12 AM - 7 messages

I have ASP.NET 1.1 websites. They will need to access a SQL 2005 database. Do I have to upgrade the whole web projects to ASP.NET 2.0 in order for them to access SQL 2005? If so, anyone have any good URLs for upgrading 1.1 ...

convert of code from access to sql server

san - 4 Mar 2006 12:04 AM - 3 messages

Hi give code is in access wann to convert into SQL Server help me plz SELECT PPCR_tbl_Form.PPCRID, PPCR_tbl_Form.StatusID, DateValue(IIf(DLookUp("PPCRID","QS_PPCR_Approved_Latest","[PPCRID]= " & PPCR_tbl_Form.PPCRID) Is Null,[MinRevDate],QS_PPCR_Approved_Latest.LatestApprovalDate)) AS FromDate, DateValue(IIf([PPCR_tbl_Form.StatusID] In ...

probelm of converting Dlookup in Sql Server

san - 3 Mar 2006 11:53 PM - 2 messages

Hi Please help me to convert this code of access in Sql Server SELECT PPCR_tbl_Form.PPCRID, PPCR_tbl_Form.StatusID, DateValue(IIf(DLookUp("PPCRID","QS_PPCR_Approved_Latest","[PPCRID]= " & PPCR_tbl_Form.PPCRID) Is Null,[MinRevDate],QS_PPCR_Approved_Latest.LatestApprovalDate)) AS FromDate, DateValue(IIf([PPCR_tbl_Form.StatusID] In (14,16,17),[MaxRevDate],Now())) AS ToDate ...

Help with CASE T-SQL

Owen Mortensen - 3 Mar 2006 11:22 PM - 3 messages

Anyone have much experience with SQL Server T-SQL CASE statement? I have some code that someone else wrote that looks like this: SELECT m.messageID, m.isTop, CASE @Mode WHEN 10 THEN m.subject ...

TRIGGER DATA

CSHARPITPRO - 3 Mar 2006 10:13 PM - 3 messages

I have written triggers for several our tables that detects inserts, deletes and changes. All of these changes are stored in a separate 'Audit' table. I would like for the user to see all the items in the audit table in the ...

Using IN

a - 3 Mar 2006 9:40 PM - 12 messages

I'm having trouble getting an IN clause to work. When I use a variable to feed the criteria to the clause, the IN fails (no rows affected). The variable is constructed with a string builder and looks exactly like the string that works, eg, @symbols = 'adrx', 'aes' . ...

Basic modeling question

Manso - 3 Mar 2006 9:38 PM - 4 messages

Hi, I have a simple design problem that I hope someone can help me with. Assume we have the following tables: Product --------- ProductID (PK) Name Order ------- OrderID (PK) Date Attachment -------------- AttachmentID Name Both table Product and Order can have one or more attachments. If I create ...

Multi-statement UDF vs. temp table

acx - 3 Mar 2006 9:37 PM - 1 message

Hi there, I have created this query: I have joined 3 inline table-valued UDFs and 1 multi-statement table-valued UDF. All the inline UDFs are executed in 1 second when run separately, table-valued UDF is executed in 5 ...

BOM

Quigs - 3 Mar 2006 9:28 PM - 1 message

Ok, so I'm trying to do a looping build of material. I have two tables, one with Parent Item and one with Child Item(s). I have linked the tables. I am getting good results the first time I run the simple query. Now, I want to ...

Update a part of a varchar field

pmud - 3 Mar 2006 9:25 PM - 3 messages

Hi, I have the ActivationDate stored in teh db in the format mm/dd/yy rather than mm/dd/yyyy . For eg, i have ActivationDates in the db as 10/12/05 rather than 10/12/2005. The reason it is like that is that we had imported ...

Rates

MAS - 3 Mar 2006 9:20 PM - 2 messages

Where can one can a general idea of the going rate for particular classes? ...

Need help with ASP.NET website administration tool! - Can't connect to the database when clicked o

Learner - 3 Mar 2006 8:58 PM - 2 messages

Hello, I am just trying to get some familiartity with ASP.NET website Administration Tool and set up few users and roles. I launched the tool and clicked on provider configuration link and it goes to the page that ...

PLEASE HELP... ERROR: "[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error.

RSH - 3 Mar 2006 8:43 PM - 1 message

We have a VB6 application using ADO to connect to SQL server 2005. The application amkes several connections to several databases through the execution. We keep getting the error: "[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network ...

help selecting

Michael Wong - 3 Mar 2006 8:41 PM - 3 messages

Hi, I have the following tables, and I would like to filter the categories to a specific department (and then supplier). Something like an intersection. How can I do it? I'm new to SQL, especially with joins, so are the ...

Error 8152

AkAlan - 3 Mar 2006 8:08 PM - 6 messages

I'm trying to add a record to a table and am getting Error 8152: String or binary data would be truncated. Here is my statement written with VBA in an Access project. Both datatypes are nvarchar Private Sub cmdCreateJob_Click() ...

single table query

mccorb - 3 Mar 2006 7:48 PM - 3 messages

First let me say that I am not an SQL expert but can usually navigate some pretty complex queries if I fight it long enough. However, this one has me baffled. I am sure I am overlooking somehting simple but not sure what that is. It only involves a single table. ...

Quick SQL Question - update a single row with multiple rows

Scott M. Lyon - 3 Mar 2006 7:41 PM - 5 messages

This is on SQL Server 2000 (if that matters, but I think this is just a T-SQL issue). I have two tables (tied together by a common key, in this example TableID), the first of which has many rows (for a given ID), and the second has just ...

How to define multi-valued and composite attribute

juventus - 3 Mar 2006 6:45 PM - 2 messages

Hello All, I want to implement an address field in a table. But, this address field is a multi-valued attribute. Also, I want to make it ...

Query master file and two entries of related file into a single re

richardb - 3 Mar 2006 6:42 PM - 6 messages

The master file holds the patients: PatUniqueID Name etc. ---------- ------ ---- 123AAA Smith 456AAA Jones ...

Using SELECT and IF statement

Pasquale - 3 Mar 2006 6:16 PM - 7 messages

I would to create a query SELECT structured so: SELECT <field1>, <field2>, IF <condition> BEGIN statement END ELSE statement, <field3> FROM <Table> The <condition> verifies the value of a parameter. ...

ISOLATION!!!

Vai2000 - 3 Mar 2006 5:36 PM - 9 messages

Hi All, I have a procedure that updates a row in multiple steps. First it inserts a record and gets the @@Identity and then using this ID goes and updates that particular Row in several steps. How can I prevent any other application doing a SELECT on this table with ...

Newbie - Query convert money

Chuck - 3 Mar 2006 5:15 PM - 2 messages

I have been unsuccessful at getting this to display the way I want it to. BOL says that convert(money, [expression] , 1) will display my sales figures as 1,234,567.89. However the results for my query ...

Convert seconds to Hours:Minutes:Seconds

Patrice - 3 Mar 2006 4:41 PM - 4 messages

Hi, I have a table column that stores time in seconds and I need to convert the total time for a given period into hours:minutes:seconds. My data source is a SQL table but the report delivery tool is Cognos, I was trying to do this ...

SOX Issue - Connect Sysdatabases with Sysusers

Catadmin - 3 Mar 2006 3:59 PM - 6 messages

I'm writing a stored procedure to use in Reporting Services. I'm working of SQL Server 2000 with the initial version of RS. I have to create a report (for compliance with Sarbanes-Oxley) which lists all Server logins & roles, regardless of whether or not they connect to a ...

Add one column in a table

Agnes - 3 Mar 2006 3:48 PM - 7 messages

I got ten database , and want to add one column in serveral tables. However, I need to add that column in the fifth column . Any easy script I can use ??thanks a lot ...

adding an identity column retrospectively

Griff - 3 Mar 2006 3:41 PM - 2 messages

I've inherited a database that has a series of tables that have primary keys that SHOULD also be identity columns, but don't. e.g. CREATE TABLE [dbo].[test] ( [id] [int] NOT NULL , [fieldA] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ...

EXPLAIN Verb

wnfisba - 3 Mar 2006 3:21 PM - 6 messages

I have a DB2 SQL background. Is there something similar to the "EXPLAIN" verb in Microsoft SQL Server that will allow me to analyze a SQL statement and determine its access path, etc., and determine how efficient the SQL is??? ...

Rename a text file

mecn - 3 Mar 2006 3:20 PM - 8 messages

hi, How do I rename a text file through Sql scheduled job? Thnaks ...

Express and AspNet_RegSql.exe

Marc - 3 Mar 2006 3:17 PM - 2 messages

Can the Asp Net exe sql script be used to add the aspnetdb database to an Sql Express? I am doing this for running the App Blocks. The error that comes back is "can not connect". Thaks, Marc ...

Obtaining Procedure Declaration

Kevin Bowker - 3 Mar 2006 3:17 PM - 4 messages

Where does SQL Server 2000 store the definition of stored procedures and views? Is there a system table that I can query and retrieve the definition, like it shows up when scripting from the QA Object Browser? ...

Is this statement vulnerable to code injection?

Michael - 3 Mar 2006 2:39 PM - 10 messages

I found a bit of code my comapny got froma third party group that I thought was vulnerable to code injection but I can't prove it since I can't figure out a way to hack it. I can point the boss to sources that ...

Select question

d4 - 3 Mar 2006 2:34 PM - 5 messages

I have the following in a table : Server Findings Added to Report ------ -------- --------------- S1 aaaa 2006-03-01 ...

Divide by Zero error

StvJston - 3 Mar 2006 2:31 PM - 3 messages

With the following sql I get a divide by zero error. Can somebody help me with the syntax to fix this? Thanks in advance SUM(CASE WHEN (p.SecondaryCapacity/p.SecondaryWatts) < (m.SecondaryEERSpec - (-1 * (@LowerSpec * m.SecondaryEERSpec))) OR ...

Cursor Declaration

Chris Allison - 3 Mar 2006 2:18 PM - 6 messages

Hello All! I am trying to declare a cursor and I keep on gettin the following error when I try and debug: Incorrect syntax near the keyword 'declare'. I am stumped and confused becuase I have even tried using the numerous exmaples ...

Deadlock Error

John - 3 Mar 2006 2:17 PM - 1 message

Hi, The .NET application with Sql Server 2000 is on live and one of the users constantly getting the deadlock error for the particular event. The error log details as follows Deadlock encountered .... Printing deadlock information 2006-02-27 13:41:39.53 spid4 ...

Stored Procedure Timeout

Joachim Prömmel - 3 Mar 2006 1:59 PM - 4 messages

Hello, I've got a problem with a stored procedure. Our Webserver (Win 2K, IIS5) calls a Stored Procedure on SQL-Server (Win2003, SQL2000 Std Ed) using ADO.NET. The Stored Procedure takes about 2 or 3 Seconds to run. ...

Calculating the days of the month?

Simon Harvey - 3 Mar 2006 1:53 PM - 5 messages

Hi everyone, Can anyone tell me how I could find out the number of days that there are in any given month using TSQL? I was hoping there was function I could use? Any help would be much appreciated Simon ...

Select Count Join Statement

Jeff - 3 Mar 2006 1:46 PM - 2 messages

I need a select statement where all "SystemName" are returned, and a count of how many documents are associated with (tied to) each "SystemName". The results desired would look like: 'System Name', 'Created By' , 'Creation Date', Count Exchange, Joe Smith, 03/03/2006, 3 ...

different result in Windows 2003 Server as in Windows 2000

Dev Main - 3 Mar 2006 1:43 PM - 5 messages

I receive different results with SQL Server on a Windows 2003 Server then on a Windows 2000 Desktop. I detached the Database on the Windows 2000 Machine and attached exactly the same database on the Windows 2003 Server, to make shure that the data are ...

have a way to change order-by of open cursor?

mtczx232 - 3 Mar 2006 12:27 PM - 5 messages

have a way to change order-by of open cursor? ...

Primary Key

Max André Bündchen - 3 Mar 2006 11:45 AM - 3 messages

Hi, I'm looking for a way to make a primary key control in a int column (in other words the app will manage the primary key value). What's the best way to make that in SQL Server 2005? Most important, there's a patter that allow many DB systems (like Oracle, DB2, ...

create temp table

SimonZ - 3 Mar 2006 11:32 AM - 3 messages

I have procedure for example: " CREATE PROCEDURE dbo.test0 AS CREATE TABLE #temp (izd_id varchar(40)) drop table #temp select * from products " When I execute this code on asp page: " set rsCpu=server.CreateObject("adodb.recordset") rsCpu.Open sql,locaConn(),1,1 ...

T-SQL debugger

Sharmila - 3 Mar 2006 11:15 AM - 2 messages

Hello NG, I am new user of SQL server. I wanted to debug a stored procedure. Refering MSDN I came to know about T- SQL debugger. I tried to debug, I am not able to proceed with it. After, assigning values to the parameters, I am not able to debug the stored ...

Query help

Chris - 3 Mar 2006 10:46 AM - 2 messages

I have the following query... SELECT PassengerSerialNo, PassengerName, Insurer, Price FROM (SELECT I.PassengerSerialNo, I.PassengerName, I.Insurer, I.Price, 'I' AS Source FROM dbo.InsuranceTransactions I ...

Updating table while importing

Amu - 3 Mar 2006 10:17 AM - 2 messages

Hi All, I have a table like the below table EmpNo Skills 1 C++ 2 Java ...

Terminal Services: get terminal machine netbios name, host_name() returns server

Ben - 3 Mar 2006 9:58 AM - 3 messages

Hi We have been using host_name() to return the workstation name. We now have two terminals on our network and find that Host_Name() only returns the server name. Is there a function that will return the terminal name? Thanks ...

loop through tables for UNION ALL

David Shorthouse - 3 Mar 2006 9:43 AM - 7 messages

Hey folks, I have a variable number of identically structured & similarly named tables for which I would like to expeditiously execute a UNION ALL in succession. e.g. "SELECT * from (x-2) UNION ALL SELECT * FROM (x-1) UNION ...

Result other stored procedure in a Select

Danny M - 3 Mar 2006 9:37 AM - 2 messages

I need to make reports with record counts over queries you can enter and save in a tool i made. Now to make a stored procedure i can use in crystal report i get a problem. The stored procedures i have. ...

CLR and fire event

Basic - 3 Mar 2006 7:47 AM - 5 messages

Is it posible to fire an event in sql 2005 DB when e.g. one record changes in the table and...main part ... respond to that event in some external c# service? ...

Week Order

niel - 3 Mar 2006 7:41 AM - 4 messages

We have a SQL statement that has the following statement. DATENAME(YEAR,"dbo"."Deal"."TradeDate"-2)+' Week '+DATENAME(WEEK,"dbo"."Deal"."TradeDate"-2) The problem with this is that it shows the data as follows. 2005 Week 19 2005 Week 2 ...

Stored procedure/trigger contain reference to a non-existing objec

Peter - 3 Mar 2006 7:21 AM - 7 messages

This question is for both SQL Server 2000 and SQL Server 2005. Are there any problem in creating/compiling a stored procedure/trigger if it contains reference to a non-existing object such as table or stored procedure? ...

Converting a MySQL multiple column subselect to SQL Server

chris_g - 3 Mar 2006 6:29 AM - 2 messages

I am adding SQL Server support to an application that currently uses MySQL 4.1. I have a table that looks like this in SQL Server 8.0: CREATE TABLE dbo.sales_estimates ( ID int NOT NULL, ...

"Selective" OR join

querylous - 3 Mar 2006 5:00 AM - 5 messages

Hi- I am trying to join 2 tables in such a manner: select i.itemcode, i.color, p.price from items i join prices p on i.itemcode = p.itemcode AND (i.color = p.color or p.color is null) ...

Subquery help

Ivan Debono - 3 Mar 2006 4:21 AM - 4 messages

Hi all, I have 4 tables (products, orders, order_details and stock). Products (columns: id, name). This table is a list of all products available. Orders (columns: id, date). This table is a list of orders for a particular date. Order_details (columns: id, order_id, product_id). Subtable of orders. Lists ...

SELECT statement with milliseconds

Terri - 2 Mar 2006 11:54 PM - 4 messages

I expect my select to return data. Why not? CREATE TABLE #Test ( testdatetime datetime ) INSERT INTO #Test (testdatetime)VALUES ('2006-03-02 14:29:24.000') SELECT * FROM #Test WHERE testdatetime > '2006-03-02 14:29:23.999' DROP TABLE #Test ...

accessing fake data inside an INSTEAD OF trigger

steven - 2 Mar 2006 11:34 PM - 4 messages

Hello, Is it possible to access inserted data through an UPDATE INSTEAD OF trigger if the condition of the query does not match any row in a table? For example : UPDATE myTable SET myColumn1 = 'abc' WHERE myColumn2 = 'xyz' If there is no row inside myTable matching the condition "WHERE ...

Hierarchically arranged attributes...mission impossible?

Daniel Manes - 2 Mar 2006 11:17 PM - 12 messages

Struggling over the design of a database. Basically, we have a long list of attributes. We've decided to arrange them hierarchically so users can find them more easily. The problem is, this doesn't seem very easy to implement! Let me try to explain what I'm talking about a ...

SQL Query Help

Andrew - 2 Mar 2006 11:15 PM - 3 messages

Hey all, Having trouble forming a SQL Query, could use the help of one of you Gurus. The table structure: TABLE [tbl_HCA_Inter_User_Status] ( [intStatusID] [int] IDENTITY, [intUser_Info_ID] [int], [intStatus] [int], [txtNote] [varchar] (4000), [txtUpda_By] [varchar] (50), [dtmUpda_Date] [datetime], [txtCrea_By] [varchar] (50), ...

SQL Server 2005 64 bit Linking to MS Access

JonathanG - 2 Mar 2006 10:59 PM - 1 message

I understand there is problems with it, but I have been unable to find any solutions on the internet. Does anyone know how to get around this limitation? Thanks in advance... Jonathan ...

SQL Server Manager

Barry - 2 Mar 2006 10:52 PM - 3 messages

If I stop SQL Server Manager and then restart it will the jobs that should have ran during the time period automatically start or do I have to start them manually? Thanks Barry ...

problem: select Max(date) which is less than actual Max(date) ?

Rich - 2 Mar 2006 10:51 PM - 14 messages

create table #temp( recID int, curDate datetime, expDate datetime) insert into #temp select 1, '11/1/05', '1/5/06' union select 1, '11/5/05', '1/13/06' union select 1, '11/12/05', '1/25/06' union select 1, '11/28/05', '1/25/06' union ...

Debugger Won't Step

Herb Ray - 2 Mar 2006 10:27 PM - 1 message

Howdy - - We are unable to debug stored procedures from Query Analyzer running on the same machine as the MSSQL service is running on. We get the massage "SP Debugging may not work properly if you log on as ...

sql server timestamp

eoghan.kenny - 2 Mar 2006 10:18 PM - 6 messages

Hi, I need a 100% reliable way to detect the last change to a row in a sql server 2000 table. So far I have created table A with a timestamp column. I need to know if there has been any change to the rows in table A. Therefore after ...

Left trimming little squares/spaces

MittyKom - 2 Mar 2006 9:38 PM - 13 messages

Hi All I have a table that is populated by an excel plugin. Some of the populated rows have spaces in front. In Enterprise Manager, they appear with little squares in front. I have been trying to LTRIM the whole column but there is ...

Select Count Join Tables

Jeff - 2 Mar 2006 9:35 PM - 2 messages

DML Below: I need a query that selects all of the tblsystem records (which will always be unique) and gives me a count of how many tbldocument records that are tied to each SystemName. So the query would return the results: ...

NOT EXISTS? Finding records without a correlating record in another table

KBuser - 2 Mar 2006 9:34 PM - 4 messages

I'm working with (essentially) two tables here. Magazine.(MagazineID, PK) and Ratedetail.(ratedetailID, PK)(magazineID, FK) I need a statement that returns all the magazineIDs that do not have a ratedetailid. I'm assuming not exists is what i'm looking to use, but ...

Access parameters within dynamic SQL

McGeeky - 2 Mar 2006 9:30 PM - 6 messages

I am exploring the use of dynamic SQL within a stored procedure and have run in to a problem. The dynamic SQL has no visibility of variables declared outside the dynamic SQL. Try this snippet which causes an error: declare @branch int ...

Parameterize table name without constructing dynamic query?

McGeeky - 2 Mar 2006 8:58 PM - 16 messages

Hi. We have a series of tables with exactly the same structure. The names of the tables all start with the same prefix but end with a number. Is there a way to write a normal query (not a dynamically constructed one) ...

How to do a USE statement inside a stored proc?

Juan Dent - 2 Mar 2006 8:28 PM - 2 messages

Hi, I have a general purpose stored proc that could be used in several databases. I need to tell it what database to work on. My first solution was to use the 'USE @DB' statement at the beginning of the stored proc, where @DB ...

Bulk Insert

Ellie - 2 Mar 2006 8:17 PM - 2 messages

Hi, I'm trying to use bulk insert to import a unformated text file into a table with 6 columns using the following code in query analyzer: BULK INSERT tblLocalizerTemp from 'c:\temp\textfile.txt' WITH (CODEPAGE='RAW', ROWTERMINATOR='\n') ...

Convert int seconds to legable time

Pat Brown - 2 Mar 2006 8:07 PM - 2 messages

I have a field that holds the number of seconds from midnight. I need to take this int value and turn it into a legable time. I also need to take input in 12:00 format and change back to int seconds to store in the db. ...

Max date in a row

Amit - 2 Mar 2006 7:35 PM - 5 messages

Hi, I would like to know how to find the max of 4 dates in one row. so if we have ssn, date1, date2, date3, date4 456123789 12/3/2005, 12/5/2005,11/8/2005,1/2/2006 ...

Constraints?

brenenger via SQLMonster.com - 2 Mar 2006 6:21 PM - 6 messages

I am importing data from a .csv. I have noticed that it copies this information over and over when I import the data. I only want it to update anything that is different and add any new lines in the .csv file. I have ...

Concatenate Lname and Fname Columns

pjscott - 2 Mar 2006 6:15 PM - 2 messages

I'm using Access 2002 and Sql 2000. I have a Lname and Fname columns that I'm try to concatenate. I'm trying to use Lname + ', ' + Fname in a View. But Lname is the things that displays. What am I doing wrong? ...

native sql function to encode binary data using base64

Uma - 2 Mar 2006 5:48 PM - 4 messages

I need to encode binary data using base64 before storing to MS SQL 2005. The select statement using FOR XML, BINARY BASE64 is not an option here, due to the presence of xml tags unabling the results to be stored in a ...

strange procedure not changing behavior in SQL 2005

SevDer - 2 Mar 2006 4:49 PM - 5 messages

Hi, I just made a change in the stored procedure to send back 1 more column. However why I try my application to get the data from that column, it fails to do so (.NET application) But when I goto Management Studio and run the same query, I get the response ...

Function Help

Kevin L - 2 Mar 2006 4:44 PM - 5 messages

I am using SQL 2000. I have a table with Shipping Transactions in it (below). Each record listed is a package, but the Amount shown is the total shipping cost for all packages within a Shipment (Tracking) I am trying to write a FUNCTION that will return the Total Shipment Amount ...

Mirroring on SQL 2005

checcouno - 2 Mar 2006 4:28 PM - 6 messages

When i try to configure 2 servers with SQL 2005 in mirroring, one primary and one secondary (standard edition) i've got an error. Something like that: "this is a dem version of mirroring.." I'm tranlsating from Italian, so sorry ...

User Type

mrprice - 2 Mar 2006 3:46 PM - 3 messages

I have a need to remove all objects from a database where the type is User. Is there a fast way to do this? Is there a way to get a list of these objects so I could use a cursor to remove them? ...

SQLServer DTS and temp tables

Guy - 2 Mar 2006 3:33 PM - 1 message

I've seen a lot of questions on temp tables and DTS packages, so I thought I'd include a link to my webpage explaining how to get the two working together. [link] ...

Have Fun

sina.818 - 2 Mar 2006 3:32 PM - 1 message

You can find many funny pictures and some great funny flash clips in here: [link] have fun and forget the problems man ...

Have Fun

sina.818 - 2 Mar 2006 3:31 PM - 1 message

You can find many funny pictures and some great funny flash clips in here: [link] ...

Pivot Rows to Columns Sql2000 ?

StvJston - 2 Mar 2006 3:27 PM - 2 messages

I'm attempting to display for reporting a resultset that produces results as shown in my example. DDL attached. Performance testing relates to model specifications as a baseline. Products are Qa'd based on the Specs. If a tested product has a any value higher than ...

ISNULL in creating VIEWS.

Jens - 2 Mar 2006 3:26 PM - 6 messages

In the old SQL server 2000, I can create a view like this.... CREATE VIEW dbo.MyView AS SELECT ISNULL(CAST(Server AS nvarchar(100)), '') AS Server FROM dbo.MyTable But this does not work in SQL server 2005 - how can I rewrite this so it ...

Simple: Assign a value to a Outout variable from a select statemen

Chris Allison - 2 Mar 2006 3:26 PM - 7 messages

HI I have a problem in setting the value of a output variable. I basically have a query that will return a single result and I want to put that result in a variable to perfrom some calcualtions upon. the following doesnt work. ...

Why does dateadd NOT like a negative integer?

Batch Insert into a Table

Query for table info....

Distributed transaction issue

CLR Tabel valued function returning quasi recordset

An easy query: how to retrieve TOP n values of each <other field here>

How to send mail programmatically from SQL2000

Default Values in Queries

Binary fields efficiency

Program Speed

inventory FIFO

use trigger

Help in scripting

Paging in MSSQL?

Check if a field exists before ADD a new column.

Sql Service is using more than 50% of the server resources.

TRIGGER, using TEXT in inserted/deleted

SQL-DMO/2005/The password does not meet Windows policy requirements

Table Variable and Dynamic SQL

Is subquery bad?

Bulk insert from errorlog

individual logins within a group login - how to detect?

visio

SQL Query help - please!!

Change Data type from Nvarchar to datetime

Upgrading a table from 2000 to 2005

Different Connections, Vastly Different Speed for Query

Generating the perfect Primary Key: Using CRC32? Using MD5?

Query help please

INSERT INTO TableB (SELECT * FROM TableA)

need assistance with project

Increased Datetime Precision

Need to build a query

Need help with building a query

SQL 2005 Failing Backups Because it Exits The Query Prematurely

Transfering data from one server to another

block comment???

Microsoft ADO and SQL Server 2005 with SSL certificate

Importing files - Access

Selecting a specific duplicate, sort of...

Stored procedure slow

default database

SQL Server 2005 - SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified on lo

syntax error

Deteted file still imports

updatable view question; one-to-one table relationship

SP Recompilation

Undocumented Bitmask Bits in master..sysdatabases?

Retrieve week # of the year

Query in CSV file

Cross SQLServer querying: Error 7399, 7359, 208

Add Column to a View

Query Analyzer Printing Margins

Varbinary(max) Column ----> Saving to a file

@@FETCH_STATUS

Using a UNC Job with SQL JOB

combine two columns

PATINDEX not working with "[" ?

importing excel column with multiple values separated by '/'

Using SUBSTRING with UPDATE

db rights

Dynamic SQL statements over 4000 chars

xp_cmdshell error handling

ntext problem

group by --- Aggregate

List of available servers

sp_executeSql doesn't use index

stored procedures

Error Handling

CLR user defined aggregate function (SS2005)

system restarting

Matching multiple columns from two tables

How to speed this up

SQL profiler

Stored procedure returns no value

SQL Server 2000 Vs 2005!

ACCESS PARAMETERS USING IN COMMAND

new line in bcp

EARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US

having example.

SQL Server 2000 DEVELOPER edition!

Copy file on network

multi from multi

CREATE ASEMBLY

instead of trigger

Stored Procedure Not Looping through Recordset

Generate Scripts Problem.

Calculating last date of the month

CHECK contraint

Programmatically altering object code

DROP ot TRUNCATE a table

select top @MaxRows

Update trigger with multiple rows in inserted and deleted

Update Query

Merge Different Data Types in Query

Bringing text into a database

How access 6.5 database using SQL 2005?

Attaching Database does not name database correctly

SQL Error -30108

Format a number to '00'

= vs <>

Get Results into one table

Help: Find the different records from 3 tables

How to sync data in multiple instances of a database?

sql query to excel file question

Help writing a querry

Comparing within a Self Join

Oracle SQL *Plus

Using an "IN" sub-query in an ADODB.Recordset Filter

problem creating Self Join query - is this the correct approach?

Scheduled export

error connecting to sql 2k from an app

SQL programming

Processes blocked on tempdb resources and can't rollback

Performance -- Plan Cost and Scan

COUNT(*) or COUNT(0)?

Returning a value from a stored proc...I'm not getting it

Saving a word Doc to a SQL table

-- Comment disables code?

capturing messages

Defalult collation

Query all tables containing a certain field

Problem Deleting Rows

.Newline converts to LineFeed

Using DMO ExecuteWithResults

Any way to find out who deleted my reports

self joins

Opinons on using Delete then BULK INSERT

In clause efficency.

Weird Stored Procedure Problem - stopping without any errormessage

Bulk insert and vb.net - URGENT

what requirements needed to develop the mobile applications

how to list perissions

to upload image in visual web developer express 2005

Quick Question on Transactions

return a predifined value in a select if the record did not exist

troubles with triggers

what date is missing from a range of dates

Complex Query help needed fast!

reset next identity value

Creating small index takes LONG time!

Help with an Update/Insert procedure

subquery with invalid column not returning errors

Help with a CASE statement.

not equal join?

send email from trigger

Assigning a unique ID

Scripting Profiler Traces

SQL automation

Check Constraint Expression

How do I update/insert entire tables

Unable to locate table

indexed view

passing values to a Trigger

how to only select rows with a given max(date)?

I need HEEEEEEELP !!!!

Database collation

selecting rows from a table excluding rows that are in inserted

SQL Server Query Question

increment in a sql query

Look_UP

Server: Msg 207 when querying against table with reserved names for column names

deleting records older than 180 days

Executing Integration Services Packages Through SMO

select with a column depending on the value of a other column(sum)

2005 foreign key query performance issue

Refreshing a User Defined Type

Look-UP

Coalesce increasing performance but Why?

Use database, based on servername

cleaning different formats

Unfamiliar date format

Help with de-duplication problem

behavior of command in the 'SQL Query Analyzer'

How to maintain the history of information in a table?

Move Data from DB's

where can i get SQL Server 2000 Reporting Serices

Import/Restore/Transfer, Only Updated/Changed/New Values Between Two SQL Server Over Dialup Connecti

Create a Table dynamically

Summing debits and credits

Connectivity in between SQL Server and DB2

Comparing all fields of two rows in few tables.

[newbie] INSTEAD OF trigger

Efficiency with INNER JOINs

Getting Top Rows

is my earlier post not clear or difficult to solve ?

alter table problem?

Sql Server 2000 and VB 6

Accessing database from User Defined Aggregate

UDF to determine if string is a uniqueidentifier ?

debugging stored procedure

delete a text file

Merging rows based on common key

Need help writing query

Interview a Database Administer for MBA Class

cannot insert data from one table to another

selecting a range of rows using a single select query

getting rows from a table using single select query

Group By problem, how to?

Using sp_ExecuteSQL

RE: newbie question on select

Altering column with index

Change collation on entire database

newbie question on select

.Net <-> SqlServer admin actions

Cannot Connect to SQL on Win2003 Server

left outer join multi-user problem when handling user editing conflicts

bigint or uniqueidentifer performance metrics?

Checking if column exists

Is this syntax correct: (',' + @country_code + ',' like '%,' + rtrim(member_country) + ',%'))

Really large integer constants - confused