Viewing 15 posts - 721 through 735 (of 921 total)
Working from your pseudo DDL rather than the schema in your pseudo SQL, perhaps you want just this:
SELECT d.DataId,
CASE d.DataCategory
WHEN 'Vendor' THEN v.VendorId
WHEN 'Customer'...
October 10, 2003 at 6:12 pm
The result set from a UNION is not guaranteed to be in any order, so, even if you could order the selects that are unioned, the order of the results...
October 10, 2003 at 5:59 pm
quote:
Since isNumeric returns a 1 for any REAL number and the original question was "how do I test for an INTEGER" you...
October 10, 2003 at 3:22 pm
quote:
...which I can appreciate, and so they don't allow for the getdate() function in the udf ...BUT passing it in as a...
October 10, 2003 at 1:39 pm
quote:
Ugh! Yeah that's where I'm headed I guess, but selecting from a table, or a view that is created to house...
October 10, 2003 at 1:21 pm
You can fool it by using a view:
CREATE VIEW v_GetDate
AS
SELECT GETDATE() Now
--Jonathan
October 10, 2003 at 1:00 pm
Can't you just add up the widths used and then return the maximum found? Something like:
SELECT MAX(DATALENGTH(Col1)) + DATALENGTH(Col2) + ...)
FROM TheTable
You'll need to just...
October 10, 2003 at 11:23 am
quote:
Thanks,Yeah, I can get the data out of one row with bcp, but I can't bcp only one row back [;-)].
...
October 10, 2003 at 10:01 am
quote:
Thanks its working in sql but what if I change to a access database. COALESCE doesn't seem to work in access.
October 10, 2003 at 9:36 am
quote:
Jonathan,Thanks, it worked for me. But is it compatable for all versions?.
All versions that...
October 10, 2003 at 8:04 am
quote:
You are probably right, but I need it to print from within SQL Server.Are there any additional tools we can use
October 10, 2003 at 7:13 am
SELECT *
FROM Table1
WHERE COALESCE(Col1, Col2) > 200
--Jonathan
October 10, 2003 at 6:06 am
You cannot disable transaction logging.
You give the size of the db but not of the table. How many rows and how many indexes?
Have you considered using bcp to copy...
October 10, 2003 at 5:56 am
The actual space used should be roughly equivalent. I think you are saying that the SQL Server data files that hold the BLOBs are larger than the sum of...
October 9, 2003 at 7:27 pm
Viewing 15 posts - 721 through 735 (of 921 total)