You don't here on SSC. Many in this community believe that there is...

adam spencer (7/23/2009)

---

Lynn, haha!! u r excatly write , he is old school and keeps wishing we could still use COBOL. u hit that on the mark! Once i get...

HyperBac, even though located in Australia, is a very responsive company. At this point I recommend sending them an email detailing the problem you are having. Don't be...

Also, this query will out perform the cursor solution over a large result set:

SELECT

A.POLICYNr,

A.COV_I,

A.PREMIUM_I

...

To be honest, being cursor clueless was probably better. Cursors are evil, even if there are some very rare cases where they are the correct solution for a problem.

Where...

Having been using it for over a year without issues, I'm not sure.

Is there anything you may have left out in the steps your are doing?

Trooper (7/23/2009)

---

Hi,

I am in the process of trying out the tool 'Hyperbac for SQL server' to compress my database backups.

I was wondering if anybody used this tool earlier .

I...

Here is a delimited split function that does not use a while loop:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE function [dbo].[DelimitedSplit] (

@pString varchar(max),

@pDelimiter char(1)

)

returns...

More like this;

DECLARE Crs_Name CURSOR

FOR

SELECT

A.POLICYNr,

A.COV_I,

A.PREMIUM_I

A.COV_II,

A.PREMIUM_II,

A.PROGRAMCODE

FROM APLICATION AS A

FOR SELECT --<OPEN Crs_Name

DECLARE

@POLICYNr AS CHAR(12),

@COV_I AS MONEY,

@PREMIUM_I AS MONEY,

@COV_II as MONEY,

@PREMIUM_II AS MONEY,

@PROGRAMCODE AS CHAR(2) --EXAMPLES 01,02,03

FETCH NEXT FROM CRS_Name INTO

@POLICYNr,

@COV_I,

@PREMIUM_I,

@COV_II,

@PREMIUM_II,

@PROGRAMCODE

WHILE...

Show us your procedure and well show you how it works.

The cursors you write in stored procedures are server side cursors. When you hear about client side cursors, they are talking about the application using a cursor to loop...

TAman (7/23/2009)

---

The result should be 2.

Which ones?: See below

Emp_ID Start_Entry End_Entry ...

There really should have been a third choice: It Depends. It really does, what data type is being converted to what data type?

Okay, half way there. What have you (or your friend) done to try and solve this particular problem?

If it isn't...