Bruce W Cassidy (8/4/2009)

[font="Verdana"]Here's a suggestion: we could come up with a...

It would be something like this (I might not have it perfect):

[bit_val]==False ? Null(DT_BOOL) : [bit_val]

If the datatype of the bit column is bool you may have to do a...

I don't know if you can do this with FP 2.6, but using the OLEDB provider you may be able to do a select statement as your source and explicitly...

What OS (XP, Vista, Server 2003, Server 2008)?

Perhaps if you posted actual table structures so your example matches your original explanation we might be able to help. Please read the first article linked in my signature...

SQL Server doesn't care about white space so yeah you can do that with any function as long as the CASE or inner function returns the right data type for...

Here are some resources about why you should not shrink:

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/07/27/oh-the-horror-please-stop-telling-people-they-should-shrink-their-log-files.aspx

http://blogs.msdn.com/buckwoody/archive/2009/07/01/sql-server-best-practices-auto-shrink-should-be-off.aspx

http://www.sqlskills.com/BLOGS/PAUL/post.aspx?id=a2b9f8a7-ec99-43a5-b365-40143cbb9180

http://www.sqlskills.com/BLOGS/PAUL/post.aspx?id=08f8fcc0-8ec7-4403-8257-2d6bf6293e73

http://www.sqlservercentral.com/articles/64582/

No attachment.

Do you have a DDL trigger defined that should have caught this and didn't?

You should have a row in the Default Trace for this. IT would show as...

Check out joins in BOL. You need an INNER JOIN.

JC,

I wouldn't use CAST, I'd use either the LEFT() or SUBSTRING() function. This will work:

DECLARE @TestVal INT

SET @TestVal = 3

SELECT

LEFT(CASE @TestVal

...

You could have opened a big can of worms here. I have not had a lot of experience with ORM tools, I have used Linq To SQL in a...

Duplicate post. Please reply here.

You have 3 options:

1. Select the Allow Nulls checkbox on the Parameter setup page. This will put a checkbox next to the parameter that the user will have...

Elliot definitely gave you some good advice. My experience has been that you need to find a mentor and the best way to do that is to get to...

To the Artist formerly known as . formerly known as Bob Hovious,

I did read the article and, like I said, I reserved my judgement until reading the article. I...