Viewing 15 posts - 586 through 600 (of 625 total)
GSquared (1/26/2011)
The definition of relational databases and the normal forms for them is what I'd start with.What kind of numeric and text data, and what difficulty does it create?
Hello,
You can...
January 26, 2011 at 3:19 pm
See this thread. http://sqlblog.com/blogs/andrew_kelly/archive/2008/02/27/when-getdate-is-not-a-constant.aspx
You may get different results by referencing getdate() multiple times.
January 26, 2011 at 1:39 pm
Putting aside ISNUMERIC and its issues I still don't understand why a CONVERT would work when selecting a field but not in the WHERE clause.
Is it possible that the comparison...
January 26, 2011 at 12:42 pm
Can LIKE '%0-9%' be adapted if my data is like the following?
100.00
75.99
99.00
January 26, 2011 at 11:25 am
drew.allen (1/15/2011)
Doesn't the following give you want you want?
ORDER BY Sort, TypeIf not, something similar should give you the desired results.
Drew
Yes it does. My apologies. I have overlooked the obvious....
January 18, 2011 at 3:22 pm
CREATE TABLE Example
(
MemberID varchar(50) NOT NULL,
Email varchar(50) NOT NULL,
UNIQUE (MemberID, Email)
)
SQL server will generate an error message but it won't be a particularly friendly message. How to handle error...
December 29, 2010 at 8:50 am
Can you add the tab manually?
Try moving the file local to eliminate ony network permission issues.
See this:
http://samuelhaddad.com/2009/03/31/overwriting-an-excel-file-destination-using-ssis/
December 23, 2010 at 2:21 pm
All, thanks for providing code samples and suggestions. This is one of those situations where the code is working, the user is happy, but I have a feeling I can...
December 13, 2010 at 2:50 pm
Chrissy321 (12/13/2010)
Edward Boyle-478467 (12/12/2010)
Try providing the result from the function as a Cross ApplyCross Apply(Select Result=dbo.Function(Parameter1,etc)) b
At least the code is cleaner.
Alas no. Its six table with case and coalesce...
December 13, 2010 at 2:43 pm
ChrisM@home (12/12/2010)
Can you post the whole view definition, Chrissy?
No my employer does not allow this which is why I post pseudo code and only hope for for pseudo answers.
December 13, 2010 at 2:14 pm
Edward Boyle-478467 (12/12/2010)
Try providing the result from the function as a Cross ApplyCross Apply(Select Result=dbo.Function(Parameter1,etc)) b
At least the code is cleaner.
Alas no. Its six table with case and coalesce logic.
December 13, 2010 at 2:09 pm
Let me please amend this by saying I can use CTE since I am working in a 2005 environment but the proposed function would be referencing a linked 2000 database....
December 8, 2010 at 7:06 pm
Hi George,
Its not working because you file is quite non-standard. Best bet is to get the file sent as straight csv or straight fixed width and with consistent use of...
November 26, 2010 at 2:41 pm
Hi,
See the BOL subject sp_send_dbmail specifically 'sending an HTML e-mail message'. This will show you how to return multiple records and then insert into each record into one html table...
November 26, 2010 at 12:10 pm
Viewing 15 posts - 586 through 600 (of 625 total)