adam spencer (7/23/2009)

---

error Msg. 'Missing keyword near select' -I asume its the second select, tried with a semi colon after the from , i tried to use a table Alias...

Jack Corbett (7/23/2009)

---

jcrawf02 (7/23/2009)

---

I was looking for a rotary dial phone a while ago as a nostalgia item, and couldn't find any. They have lots that *look* like rotary, but...

inliten (7/23/2009)

---

Hi,

I want to concatenate fields from a table into a combo box. I entered the following SQL Select statement:

SelectCommand="SELECT Project + ' ' + Task + ' ' +...

And that is probably why it never gained much popularity.

jcrawf02 (7/23/2009)

---

So how come they don't sell PC's with ergo keyboards to start?

Or, if I may be allowed to get crazy here, why do we need a damn keyboard...

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.