Forum Replies Created
Viewing 15 posts - 346 through 360 (of 683 total)
-
RE: Want to know date in time when table was updated
This information is not recorded by default. The only way would be if you have backups, and you can work it out by trawling through them.
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: getting last 6 months of data only from table with no date column
Hey, no worries Ken...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: getting last 6 months of data only from table with no date column
Is this a joke?
An alternative definition for the 'SillyDate2SQLDate' function is:
create function dbo.SillyDate2SQLDate(@SillyDate varchar(15)) returns datetime
as begin return '1 '...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: CASE Statement in Table Check constraint?
Yes, I believe De Morgan felt the same.
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: CASE Statement in Table Check constraint?
Well, if we're simplifying...
ALTER TABLE Claims
ADD CONSTRAINT CKTbl_Claims_DateClosed
CHECK (NOT (ClaimStatusID = 2 AND DateClosed IS NULL))
(okay, it's probably not much simpler - if at...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: CASE Statement in Table Check constraint?
That was just an example. Use your imagination!
ALTER TABLE Claims
ADD CONSTRAINT CKTbl_Claims_DateClosed
CHECK (ClaimStatusID <> 2 OR (ClaimStatusID = 2 AND DateClosed IS NOT NULL))
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Data Types to use GROUP BY, ORDER BY, WHERE etc. to be stored in variables
It's not clear to me, but maybe you want to create a dynamic order by?...
http://www.sqlteam.com/item.asp?ItemID=2209
If not, post some sample data and the result(s) you would like for it.
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Case sensitivity problem
Just use the COLLATE keyword. Here's a simulated example...
--data
declare @t table (v varchar(10) collate Latin1_General_BIN)
insert @t
select 'ABC'
--calculation
select * from @t where...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: getting last 6 months of data only from table with no date column
Clearly you need to sort out your underlying data, but something like this should do in the meantime...
declare @t table (id int identity(1, 1), v varchar(20))
insert @t
...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: CASE Statement in Table Check constraint?
You can just use some ANDs and ORs. E.g.
ALTER TABLE Claims
ADD CONSTRAINT CKTbl_Claims_DateClosed
CHECK (ClaimStatusID IN (0, 1) OR (ClaimStatusID = 2 AND DateClosed IS NOT NULL))
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
RE: Data type conversions
Nice work Tim.
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
RE: CHECK_SUM returns same value for diff. inputs
The only guarantee you have with these functions is that BINARY_CHECKSUM will always return the same value for 2 identical values, and CHECKSUM will always return the same value for...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
RE: SQL PROBLEM
Mirza - This looks like a dynamic pivot table requirement to me. The links and the code below should get you going in the right direction...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
RE: Data type conversions
> and oddly enough are classified numeric
This issue looks like it was a consequence of the 'dodgy' isnumeric function. This article provides an 'isReallyNumeric' function, which can sometimes come in...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
RE: sequencing a column with group by
Here's a 'not recommended' way:
--data
create table #tableA (a int, b VARCHAR(3), c VARCHAR(4))
insert #tableA
select 1, 1, 1 union all
select 1, 1, 1 union all
select 1, 1,...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
Viewing 15 posts - 346 through 360 (of 683 total)