DECLARE @ETD varchar(20), @ETDvar datetime, @TimeData varchar(1)

SET @ETD = '2010-01-01Y' --Last Year

IF SubString(@ETD,11,1)='Y'

SET @ETDvar = SubString(@ETD,1,10)

SET @TimeData = SubString(@ETD,11,1)

SELECT ETD

FROM IXT_OceanShipments

WHERE CASE @TimeData

WHEN 'Y' THEN (ETD >= @ETDvar) AND ETD...

I have a drop down that's populated from a recordset that I create. Below is the data. The [Abbrev] field is submitted.

Abbrev - Descrip

2010 - Last Year

2011 - This Year

201101...

DECLARE @ETD datetime

SET @ETD = '2011'

SELECT ETD

FROM IXT_OceanShipments

WHERE (ETD >= @ETD)

ORDER BY ETD

As predicted by Jeff, I ran into problems as we increased records. Formalities: SQL2005. ETD is formatted as:...

The column ETD is datetime. The variable submitted from the website is varchar(50) (I was lazy and should have limited it to varchar(8). ETD is formatted as '2011-08-08 00:00:00.000'

"00:00:00.000" will...

That was it!

Thanks!

SELECT

column_list

FROM

MyTable

WHERE

(@CaseID = 0

AND RMARequestedDate > DATEADD(DAY, 0 - @D, GetDate()))

OR...

>>Could not save the package The SaveToSQLServer method has encountered OLE DB error code 0x80004005<<

I'm getting that same error trying to deploy on my local SQL 2005.

Does anyone have...

Please clarify. Are you saying there's both SQL2005 32 and 64 bit versions?

I have this same problem and cannot get it to go away.

My SQL2005 Standard does not qualify it...

I was hoping to hide from view for those users. It's easier to tell them to login and link to all tables vs login and link to these 10...

Management Studio is on the client end. I have many users logging in with username [merchant] to access data I provide.

I want to hide the tables from those users on...

I finally got this figured out! I think I was trying too many solutions and mixing them altogether. The following page from the MS KB got me straight.

http://support.microsoft.com/kb/918760

1)...

This is really getting to be a pain! I found this link in the SQL Server Help.

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtsprotectionlevel.aspx

If I read this correctly, there's no way I can create...

I'm having problems deploying a package also. I'm trying to deploy to a shared SQL Server 2005 where I'm supposed to have access. However, I'm getting the following error. I...