Rating Thread / Thread Starter	Last Post	Replies	Views
extracting csv string and using in NOTIN clause Hi, I'm trying to pass a stored proc a list of values in a comma seperated string: ("3125,3126,3129...") The values represent an integer column in... Opa	04-18-2005 09:07 PM Steve Kass	1	45
Time Datatype ( 1 2 ) Hi! I have 2 field in my table that needs to store time only (it's a field that stores the timing a user can logon to the system). Is there any... wrytat	04-18-2005 07:20 PM wrytat	12	72
Query Help My data file looks like this: Period, MCO, HMO, MeciareMem, MedicaidMem, CommMem, TotalMem 2Q02, Aetna Aetna Health of CT, 0, 0, 37947, 37947 2Q03,... William	04-18-2005 06:13 PM CBretana	1	50
BUG REPORT: SQL Server ISNUMERIC() not reliable in all cases I have no idea how to submit this bug report to Microsoft, and I'm sick of searching the site and ending up in the same place all the time. So... Hyper	04-18-2005 05:57 PM Thomas	5	40
Table design question I'm designing a database that will contain customer, vendor and employee information. My goal is to eliminate the duplication of data and facilitate... Rumbledor	04-18-2005 05:55 PM Thomas	4	38
Very very newbie seeks help with procedure I shouldn't be trying this unsupervived :) but I want to learn. In the stored procedure below I want to add a new table refence. More specificly I... Neither rhyme nor reason	04-18-2005 03:45 PM Jens Süßmeyer	3	39
Check if job is running? Hi, I have a stored procedure that needs to start a job stored in sql server. How can I check if this job is already started before trying to start... Raterus	04-18-2005 03:30 PM Jens Süßmeyer	4	41
NOT EXISTS Query I have a query below that find a 'SV Redemption' and then picks it out if the 'SV Redemption' has a 'SV Redemption Reversal' after it. Is there a... tarheels4025	04-18-2005 03:21 PM Hugo Kornelis	1	37
how to detach master db Hi, how do I detach master db? what are the steps? Britney	04-18-2005 03:18 PM Jens Süßmeyer	4	33
List available SQL instances in a Server Hi, iam using this script to connect to the default instance of a SQL Server (7 or 2000) strcomputer = wscript.arguments(0) Set... Tinchos	04-18-2005 03:09 PM Tinchos	4	56
Re: How can I write results of a query to output file and save it to the disk Just create a regular script, only T-SQL commands; you can run this commands in QA, job task, or with OSQL.EXE command prompt utility. OSQL can save... Dejan Sarka	04-18-2005 03:07 PM Jens Süßmeyer	1	39
Help with insert query TblA TblB ------------------------------------------------- ColA int Identity ColB char(5) ColB... larzeb	04-18-2005 03:05 PM Alejandro Mesa	3	34
Create a string with carriage return and line feed Hello, Is it possible to create a variable that has carriage return and line feed embed inside. Say I have 3 fields: field1, field2, field3. I want... Ed Chiu	04-18-2005 03:03 PM Joe Webb	4	35
count Hi Can someone tell me what I am doing wrong here? I am not sure I am using count in the right context. Thanks. declare @ServiceID int declare... Jaco Wessels	04-18-2005 03:01 PM Hugo Kornelis	3	46
Converting Julian Dates In SQL Hey all, I already have an answer for this question, but I was just wondering if anyone else had another (better) way of working out Julian dates in... -Ldwater	04-18-2005 03:00 PM Steve Kass	5	42
Time Zone strategy I was wondering what those of you who have to deal with different time zones are doing in their code. Our SQL Server is located in the mountain... Ben Amada	04-18-2005 02:56 PM Louis Davidson	4	40
How to make OrderBy by Parameters Hello All, I need to make a select in a table, but i need to do a order by by parameter. Exemple: SELECT * FROM CUSTOMERS ORDER BY @COLUMN This... Dexter	04-18-2005 02:08 PM Alejandro Mesa	3	34
SQL Update Statement Help The below SQL works well in updating the Price of an Order Item belonging to an Order. However, the following CASE statement works but doen't... WhiskyRomeo	04-18-2005 01:43 PM WhiskyRomeo	4	40
how do I clear a database connection I am programmatically trying to terminate the connection to a database that was connected and attached by another program (I have... Weisbug	04-18-2005 01:39 PM Jens Süßmeyer	2	52
Null Dates I am trying to write an SQL query that will only select null dates. At the current time in the designer pane it will not let me have that... terry beckman	04-18-2005 01:33 PM Keith Kratochvil	1	39
Relathionship for two databases Is it possible to create a relationship between two tables in different databases or between a table and a view which is based on a table in... Vik	04-18-2005 01:10 PM Alejandro Mesa	2	78
Trigger to run another program on another server? Ok, here is the general gist of what I am trying to do and keep in mind; it might not be the best solutionâ€¦ I am open to new ideas, suggestions or... Warren	04-18-2005 12:57 PM Joe Webb	4	45
Deadlock on Update Statement (NOLOCK) I have the following updates statements in my stored procedure which caused a deadlock. Should I take the (NOLOCK) statement out of the... Joe K.	04-18-2005 12:56 PM Geoff N. Hiten	2	36
Transaction Log DROP TABLE I have a table that needs to get generated on a regular basis and then get DROPed. My question is, on a DROP TABLE, does the transaction log record... JP	04-18-2005 12:28 PM Anith Sen	2	31
Referencing a variable set in an EXEC statement I have code like this: DECLARE @CurrentValue nvarchar(1000) EXEC('SELECT @CurrentValue = min(Column) FROM Table') PRINT @CurrentValue When I... MatthewR	04-18-2005 12:24 PM MatthewR	7	37
Inserting into an ErrorLog table from within a transaction??? Hey all, I have a question about ms sqlserver 7 that I was hoping for some help with... I want to create a transaction that will process a group of... Verizon User	04-18-2005 12:02 PM Tibor Karaszi	6	39
Considering only first arrival This only returns a single record. Is it supposed to work that way? "Alejandro Mesa" <AlejandroMesa (AT) discussions (DOT) microsoft.com> wrote Dave S.	04-18-2005 12:02 PM Dave S.	4	36
ODBC Call To sp_prepexec Failing Hi all, I'm working on creating a ms-sql database that will work with an existing third-party application. As such, I have full control over the DB... GeoffB	04-18-2005 11:50 AM GeoffB	6	67
Intricate SQL Statement Hi there at the forum, I have a table with the following structure CREATE TABLE . ( (20) NOT NULL , NOT NULL , (64) COLLATE... NBrake	04-18-2005 11:41 AM David Portas	1	35
Transpose data Hi I am busy transposing data , that look like this 1 - 1 1 - 2 1 - 3 to 1 - 1 ; 2 ; 3 I have it working so far. Mal .mullerjannie@hotmail.com>	04-18-2005 10:54 AM Mal .mullerjannie@hotmail.com>	2	40
DateTime Performance Hi all, I have a table below, with approx 2 million rows. I have a clustered index on CLI, and a foreign key constraint on FileID and CarrierID.... steve	04-18-2005 10:53 AM Steve Kass	9	38
record sequence? I add 3 records into a table, the sequence is record 1, 2, and 3. When I use the Query Analyser to query the table, it shows incorrect sequence,... Joe	04-18-2005 10:53 AM Joe	6	42
LINKING TWO TABLES WITHOUT UNIQUE CONSTRAINT I have a Contracts table that has a contractNumber and ContractCode which is the first 4 digits of the ContractNumber. I have a serviceRates table... Dan Slaby	04-18-2005 10:45 AM Dan Slaby	2	40
TRIGGER question I currently have stored procedures, but using a trigger instead, would actually benefit consistency. This way, all my SQL code could safely use... Lisa Pearlson	04-18-2005 10:45 AM --CELKO--	5	35
Re: results of view Can you post a reproduction script here? Perhaps the view has an old-style outer join (*=) ? -- Tibor Karaszi, SQL Server... Tibor Karaszi	04-18-2005 10:44 AM POKEMON	5	36
Identify if SQL Job is Running I am trying to identfy in a SQL statement if a sepcific SQL job is running or not. I dont care what step is it on. Ex. I have a job that is... JC	04-18-2005 10:22 AM Alejandro Mesa	1	34
Autocommit and Transactions. Hello, I need help with some StoredProcedure execution and Transactions. Here is the scenario: 1) I set Autocommit to OFF 2) I Prepare and Execute... Sami	04-18-2005 09:18 AM Sami	2	36
Formatted Text Options - please help Hi all, We're designing a db application for SQL Server 2000. Some of the data will be of bibliographical entries. This data will be displayed in... Paul Dussault	04-18-2005 08:43 AM Paul Dussault	0	39
Dates Query Hi We have a work schedule table in our database that comprises of an Employee ID, a Start Date/Time and a Finish Date/Time. We are trying to... Chris	04-18-2005 08:38 AM Chris	5	37
Batch Processing /** l'm trying to improve my batch processing routines by creating a generic method which l can apply on most of my jobs.Reason Being l'm working... Raymond M via SQLMonster.com	04-18-2005 08:27 AM Andrew J. Kelly	1	35
Calling Stored procedures via the Job Agent - Please help! Hi all, My colleague and I are struggling with a rather annoying problem. The situation is as follows: We've two database servers (one primary and... A. Wiebenga	04-18-2005 08:13 AM Alejandro Mesa	1	36
array in store procedure How to send an array list as an input variable into store procedure? I have a list of UserName witch I would like to store into table through store... Hrvoje Voda	04-18-2005 08:12 AM Frank Kalis	5	39
Question regarding Identitiy field Guys, I have a identity flag set on a column. When i am testing the system, inserting records the identity goes all the way to 60 and so on. I need... Manny Chohan	04-18-2005 07:35 AM Dan Guzman	9	34
How to retrieve values from one db to another db Hi Could someone please give me the correct TSQL statement, for the below "pseudo". USE db_a INSERT INTO tbl_1 VALUES(USE db_b SELECT * FROM... Mr. Smith	04-18-2005 07:34 AM Sambathraj	6	39
Obtaining all the dates Dear all, According to a date introduce I would need to obtain all the periodDesc of the following table: CREATE TABLE . ( NOT NULL , (3)... Enric	04-18-2005 07:33 AM Enric	6	40
A cursor with the name 'MyRS' already exists Any help appreciated on this one as I have scoured the internet and got no joy! I have a complex set of triggers and stored procedures that should... Andy A38	04-18-2005 07:11 AM David Portas	2	51
Updating and Inserting using datasets I have problem in that I admittedly, I do not understand how Sql Server 2000 and datasets work. I have an ADO.Net dataset in my C# app that contains... Robert	04-18-2005 06:51 AM CBretana	1	34
Password encryption and decryption Hi there, Currently I working on a project that requires users to enter a username and password before they can use one of our internal... Padmini	04-18-2005 06:02 AM Padmini	3	48
Concatenation of strings between multple records Hi everybody! I have a table storing clients' phone numbers. It has two columns and looks like this: ClientKey ... Kyrill Fomichev	04-18-2005 05:39 AM Uri Dimant	6	37
what's wrong ? CREATE PROCEDURE UsersGroupsIDInsert @UserName nvarchar(50), @GroupID int AS Create Table #UsersID(UserID int, GroupID int) Insert Into #UsersID Hrvoje Voda	04-18-2005 05:39 AM David Portas	2	39

Page 950 of 1545

950

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off