Viewing 15 posts - 1,561 through 1,575 (of 2,171 total)
DECLARE
@rInv TABLE (RoomInventoryID int, Rate numeric(10,2
July 3, 2007 at 12:08 am
WHERE crt_expiration_date < DateAdd(day, datediff(day, 31, current_timestamp), 0)
July 2, 2007 at 3:47 pm
Have you tried this?
CREATE
TABLE #TMP
(
RecID INT
July 2, 2007 at 3:45 pm
No, because MonthX is denoted how many months back the data is.
Look at the sample data. THe data for June is in column Month1, and the data for January is...
July 2, 2007 at 12:52 pm
Here is a nice function that works for up to 8 characters!
CREATE
FUNCTION dbo.fnFirstDifference
(
@FirstString
July 2, 2007 at 12:11 pm
DECLARE
@myTable TABLE
(
DataDate
DATETIME,
TotalCount
INT,
Count10s
INT,
July 2, 2007 at 10:59 am
I have used it in a Call Center application. The company just wouldn't accept the possibility that an agent phoned a lead on the same street twice or more sequentially.
The lead lists...
June 29, 2007 at 2:31 am
something similar to this
declare
@sample table (id tinyint, [group] char(
June 28, 2007 at 12:46 am
It depends on the SET DATEFORMAT setting.
If unsure, always use ISO date format YYYYMMDD or YYYY-MM-DD.
In your case, since SQL Server cannot interpret last string as ISO, it tries MDY...
June 27, 2007 at 9:15 am
declare
@sample table (year char(2), incdno tinyint
June 26, 2007 at 2:39 pm
Post some sample data for both tables. Also provide expected output.
June 25, 2007 at 2:41 pm
Yes, of course you can.
Did you receive an error when you tried?
If unsure, you can always start a transaction, execute statement, read uncommitted records and if satisfied, commit transaction.
June 25, 2007 at 1:08 pm
Well done!
But beware that ISNUMERIC is not always trustworthy.
select
isnumeric('1E1'), ISNUMERIC('1D1')
both returns 1.
That's why I wrote my...
June 25, 2007 at 11:12 am
Please post your query.
A correlated subquery with count may return no records, but the result should be zero in that case.
June 25, 2007 at 11:08 am
Viewing 15 posts - 1,561 through 1,575 (of 2,171 total)