Hi I want to achieve the following transformation of data using a stored procedure. Source col1 col2(varchar) ------------------------- 1 1.1 1 1.2 2 2.1 2 2.2 2 2.3 ================= De...more >>

Environment: Server1 (Local) OS Windows 2000 Server SQL Server 2000 Server2 (Remote) OS Windows 2003 Server SQL Server 2000 (Both with most recent service packs) Using Enterprise Manager, we have set up the Link Server (LINK_A) in the Local Server 1 to connect to Server 2. The SQL ...more >>

Greetings everyone! Is there a way to stop query analyzer from processing remaining query statements? Let's say i have the following query in query analyzer: query statements if condition begin query statements stop the query end query statements if condition begin query ...more >>

create from dbo.fromExample as from dbo.Customers c join dbo.Invoices i on c.CustomerID = i.CustomerID now you can use it as follows: select c.CustomerID, i.InvoiceNo from dbo.fromExample I find I reuse FROM clauses alot and reusing a "base query" requires writing a very large and c...more >>

I am construvcting a number of databases, some of which contain sensitive data and most of which do not. I am attempting to handle the security issues involved in protecting sensitive data in part by putting it in its own database. If the sensitive data is in a database called d_SensitiveData,...more >>

I am new to SQL Server, and migrating part of an Access application to SSE. I am trying to insert a comma delimited file into SSE 2005. I am able to run a BULK INSERT statement on a simple file, specifying the field (,) and row (\n) terminators. I can also do the same with a format file. H...more >>

Sql server 2000 -> sql query analyzer select datename(dw,'01-01-2006') returns sunday Now I do: set language danish select datename(dw,'01-01-2006') returns sonday. But it should be søndag. Same goes for saturday/lordag/lørdag Tried substring'ing and ascii'ing/unicode'ing and it is ...more >>

Hi Guru, When I ran my adhoc script below it generated only 45000 reads or 4 seconds but when I wrapped it into procedure it took about two minutes or millions of reads. The parameters calling both adhoc and proc are indeed the same. I'm pretty 99.9% sure that the proc does not recompile beca...more >>

I am trying to bcp import a text file into a SQL Server 2000 database. The text file is coming out of a java application where order information is written to the text file. Each record is on it's own row, so the last item in each record has a new line character at the end of it to create the ne...more >>

I have following problem: table includes times for startup and end of operation as datetime field related to daily shift operations: dateid date starttime endtime 458 2006-12-29 22:00 23:15 458 2006-12-29 00:15 01:30 459 2006-12-30 20:00 21:10 459 2006-12-30 22:15...more >>

Hi All, I am new to this group and this is my first doubt i am facing at present. I am doing data migration. In this sequence i need to alter few views. Alter in the sense, inside the existing query of view i want to include one more column. I want to do it inside one single script. If...more >>

Hello, I have a table that has a UserUpdated field which has a default value of SUSER_SNAME(). This works great when the record is created, but I'd like to also update this value when the record is changed. If I understand things correctly, I'll need a trigger to do this, but I've never c...more >>

Hi, I have an issue with my replication at the moment. I will try to describe the scenario accurately. I am using MS SQL 2000 SP4 with Merge Replication. Subscribers connect to the publisher to upload/download changes. I have a trigger set up on one table which updates another, here is an e...more >>

is there any documentation generating tool for SqlServer? (like pldoc for Oracle)? ...more >>

Hi, I have a date/time field in a SQL2000 database, and what I would like to do is to filter on a specific part of the field, for example the time or hour. Supposing I have a set of data for the last 5 years and would like to filter out any records which are outside working hours i.e. I would...more >>

My co-worker, no idiot, says that the tooltip in the system tray for the SS2000 icon usually shows the computer and server, but once in a while shows the password (two slashes and the password). Is this a known bug of some sort? It really shouldn't be showing his password. It's likely the deve...more >>

Does anyone know the best way to become proficient in SQL/.Net development. I'm interested in, the fastest way and cheapest way, but at the same time I'd like to develop real skills. Any suggestions? Let's say I'm starting from scratch (not exactly but would like to know anyway). Thank you,...more >>

Happy New Year everyone! I would like to capture CPU Utilization % using TSQL. I know this can be done using PerfMon but I would like to run TSQL command (maybe once every 5 minutes) and see what is the CPU Utilization at that instant so that I can insert the value in a table and run reports b...more >>

I've got a file I need to load into a table. The file contains modifiers to a fast food order. For example, if you ordered a burger and asked for no onions, the no onions request would be in the modifier file. So, the problem is there are "fake" duplicates in the file. What I mean is this:...more >>

Hi all, I am creating a search table where the keywords field is made up of several text fields and this is causing me some problems. I can concatentate the text ok but i can't seem to concatenate matching records here is the cursor loop. I'm not a fan of cursors but also didn't see another way ...more >>

A few weeks ago a client asked me to add a column to a table so I created this script: ALTER TABLE dbo.tblIndividual ADD fldRenewalStatus BIT NOT NULL CONSTRAINT fldRenewalStatus_Default DEFAULT 0 Now they want to change it from a BIT to an INT, to store an enum. Fair enough. However, no m...more >>

Dear experts, If I have a number of related groups of data (e.g., stock prices for different stocks) is it better to put them into many tables (e.g., one table per stock) or into one big table (e.g., a single table where one column is the stock id other columns are the price and other data)? ...more >>

Hi group, i'm having a problem with custom ordering in a SP. My code is the following: CREATE PROCEDURE [dbo].[PersonasSelectAll_P] @fromRow int, @toRow int, @expresionOrdenamiento int = null AS SET NOCOUNT ON DECLARE @TotalFilas int Select @TotalFilas = count(*) from [Personas]...more >>