Viewing 15 posts - 7,741 through 7,755 (of 10,144 total)
mohanaraj (6/28/2010)
...I want to insert the record in to a table using bulk insert method fro that I use the below...
It's good practice to use a staging table...
June 28, 2010 at 7:21 am
Grouping by customer; get min date, max date, row count (transaction count).
Dividing the difference between the two dates by the row count will give you the average interval between sales.
June 28, 2010 at 4:27 am
Dave Ballantyne (6/28/2010)
Jeff Moden (6/27/2010)
Hmmmm.... in this day and age it seems to me that they could show a replay and have the audience vote on it in seconds.
Quick ...
June 28, 2010 at 2:27 am
SELECT AcctNo, RowID = IDENTITY(INT,1,1)
INTO #Temp
FROM (
SELECT 123 AS AcctNo UNION ALL
SELECT 123 UNION ALL
SELECT 124 UNION ALL
SELECT 125 UNION ALL
SELECT 126 UNION ALL
SELECT 126 ...
June 25, 2010 at 9:45 am
Beratung (6/25/2010)
June 25, 2010 at 8:29 am
/****** Drop Table If It Exists ******/
--if object_id('#RiverRd_Precip_15') is not null
drop table #RiverRd_Precip_15
/****** Create Table ******/
CREATE TABLE #RiverRd_Precip_15 (
[T_TIME] datetime,
[T_DATA] float
)
/****** Insert Data Into Table ******/
INSERT INTO...
June 25, 2010 at 7:21 am
Is it always the last hour, the last 3 hours, the last 6 hours which you want to retrieve?
As a single row?
For each site?
June 25, 2010 at 7:07 am
Ryan
The column 'Arrears' is generated by a CASE in the inner query.
CASE WHEN TEN.[curr-balance] >0
THEN TEN.[curr-balance]
ELSE 0 END AS 'Arrears'
There are two ways...
June 25, 2010 at 5:04 am
What exactly is meant to be output to column 3? What datatype is T.ORTRXAMT?
DECLARE @ORTRXAMT DECIMAL(10,2)
SET @ORTRXAMT = 999.99
SELECT TRXAMOUNT =
CAST(
RIGHT(
LEFT('0000000000' + CAST(@ORTRXAMT *100 as varchar(50)), LEN('0000000000' + CAST(@ORTRXAMT...
June 25, 2010 at 4:31 am
tosscrosby (6/24/2010)
Chris Morris-439714 (6/24/2010)
Trey Staker (6/24/2010)
Captain and TennilleShe was cute, in a kooky kinda way.
The kid or Tennille?
She was cute. Oh boy I worry about you sometimes 😉
June 24, 2010 at 10:14 am
Trey Staker (6/24/2010)
Captain and Tennille
Funny - I remember their stuff from the mid-70's - soft, folksy, musical. So did the kid who recognised her at the Floyd concert, about 1/3...
June 24, 2010 at 9:37 am
Why not convert it into a view?
You could also resolve out all the UDF's to improve performance - since you'd be left with a single code chunk.
You could also remove...
June 24, 2010 at 8:04 am
Viewing 15 posts - 7,741 through 7,755 (of 10,144 total)