Search Results | SQL Server Performance Forums

DTS fail when copying a table from one dB to another dB.

Thread by: tmarko, Jan 28, 2008, 1 replies, in forum: SQL Server DTS-Related Questions

The destination table is empty and I copy using DTS the corresponding table from an other dB. (Both databases looks the same . One is a test dB the...

Left join problems

Thread by: tmarko, Jan 21, 2008, 7 replies, in forum: General DBA Questions

select CUR.CUR_id,TIM.TIM_id, CASE WHEN CUH_averageHisto IS NULL THEN CUR.CUR_average ELSE CUH_averageHisto END from TIM_TP TIM left join CUH_CH...

SubQuery question, extract first value that differ from previous value?

Thread by: tmarko, Nov 26, 2007, 3 replies, in forum: General Developer Questions

SELECT KRR.KRR_COM_id AS CompanyId, CUR_code AS CurrencyCode, AKA.AKA_MED_id AS MetadataId, AKA.AKA_TIM_id AS TimeId, AKA.AKA_keyValueY AS TimeYear...

problems with duplicat values

Thread by: tmarko, Oct 6, 2007, 1 replies, in forum: General Developer Questions

I want to only select one row for each CONSENSUS_RECOMMENDATIONS.ORIGDATE. So if the column CONSENSUS_RECOMMENDATIONS.ORIGDATE consists of several...

Last row ROWCOUNT

Thread by: tmarko, Feb 20, 2007, 7 replies, in forum: General DBA Questions

I'm using SQL2000 I would like to create a SP that take a variable @NrRows so I need to use ROWCOUNT instead of TOP, but I want to only return the...

CASE WHEN NULL ?

Thread by: tmarko, Feb 1, 2006, 16 replies, in forum: General Developer Questions

I have the following IF clause How can I trasform it easily into SQL with CASE WHEN IS NULL? The combinations are quite a few (24)? and I cannot...

Select unique max value

Thread by: tmarko, Sep 30, 2005, 3 replies, in forum: General DBA Questions

I will try to explain my problem: In a table for companydata. Each company has several rows (lots of data for the same company). Each row has until...

XML and SQL server 2000

Thread by: tmarko, Dec 19, 2004, 3 replies, in forum: T-SQL Performance Tuning for Developers

Anyone who can give good advise in using XML in a SQL server 2000 dB. Microsoft is pumping out there mantra about XML. But is it at all so good to...

AND in a WHERE clause

Thread by: tmarko, Nov 22, 2004, 4 replies, in forum: T-SQL Performance Tuning for Developers

I have a 2 column tabel, with column name Person_id and Comp_id I would like to select the Person_id(s) that satisfy criterias like the following...

Using GetRows and Fields parameter Problems (ADO

Thread by: tmarko, Sep 20, 2004, 1 replies, in forum: Non-Transact SQL Developer Performance Tuning

I want to use GetRows to fill an array from an ADO recordset Arr =RS.GetRows But I also would like to specify which Fileds from my recordset to...

Delete Field in an ADO recordset?

Thread by: tmarko, Sep 15, 2004, 10 replies, in forum: General Developer Questions

I tried to use the following syntax RS.Field.Delete("Name of Field") and RS.Field.Delete 1 without success. Both give med following error in...

Extract data from tabel [RESOLVED]

Thread by: tmarko, Jul 21, 2004, 5 replies, in forum: General DBA Questions

I have a problem when I want to extract all data from a tabel in my SQL 200 data base. Some columns allow up to 900 caracters. How should I be able...

Mapping nearest date

Thread by: tmarko, Feb 26, 2004, 7 replies, in forum: General Developer Questions

select KRR_id,KRR_CurrencyId,KRR_publishedDate,CUR_changedDate, CUR_average,CUR_id,CUR_code,DateAdd(day,-1,CUR_ChangedDate) from KRR_keyratioReport...

How to save only a full year in datetime type?

Thread by: tmarko, Feb 10, 2004, 5 replies, in forum: General Developer Questions

Hi! My users would like to be able to choose if they want to save a full year like 2004 or 2004-02 or 2004-02-10. I was thinking of saving this in...

Replace NULL with 0 in aquery

Thread by: tmarko, Jan 22, 2004, 20 replies, in forum: General Developer Questions

I use dynamic SQL in stored procedure to calculate values and update a table SET @SQLStatement = 'UPDATE CAV_CalcValues ' SET @SQLStatement =...