Viewing 15 posts - 19,606 through 19,620 (of 26,490 total)
adam spencer (7/23/2009)
July 23, 2009 at 1:01 pm
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...
July 23, 2009 at 12:16 pm
inliten (7/23/2009)
I want to concatenate fields from a table into a combo box. I entered the following SQL Select statement:
SelectCommand="SELECT Project + ' ' + Task + ' ' +...
July 23, 2009 at 11:29 am
And that is probably why it never gained much popularity.
July 23, 2009 at 11:23 am
jcrawf02 (7/23/2009)
Or, if I may be allowed to get crazy here, why do we need a damn keyboard...
July 23, 2009 at 11:15 am
head_contusion (7/23/2009)
Second, when an issue is solved, how do I mark the issue as closed/solved?
You don't here on SSC. Many in this community believe that there is...
July 23, 2009 at 11:07 am
adam spencer (7/23/2009)
July 23, 2009 at 10:50 am
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...
July 23, 2009 at 10:45 am
Also, this query will out perform the cursor solution over a large result set:
SELECT
A.POLICYNr,
A.COV_I,
A.PREMIUM_I
...
July 23, 2009 at 10:36 am
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...
July 23, 2009 at 10:28 am
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?
July 23, 2009 at 10:19 am
Trooper (7/23/2009)
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...
July 23, 2009 at 10:05 am
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...
July 23, 2009 at 9:46 am
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...
July 23, 2009 at 9:21 am
Show us your procedure and well show you how it works.
July 23, 2009 at 8:57 am
Viewing 15 posts - 19,606 through 19,620 (of 26,490 total)