You need to change your WHERE clause to something like this:

WHERE

d.VendorRelationStatus = ’On Hold’

AND d.ContractEndDate > getdate()

OR (d.VendorRelationStatus = 'Active'

AND d.ContractEndDate >= dateadd(d, +360, getdate())

)

This WHERE clause now says,...

When using table-valued functions you need to use the APPLY operator. Your example query should look like this:

select FP.* from dbo.pbaseid as PBI CROSS APPLY Fport(PBI.pbaseid,'us',1,'12/31/2013') as FP;

GrassHopper (3/4/2014)

---

My Select works fine, but when i added hte update to it, it updates the DomainRoot with the same value for all records. I am missing something but...

I think you can replace both scripts with the File System Task in SSIS. The first one would be a delete task and it won't do a delete if...

I think one of these should work for you:

DECLARE @clientDomains TABLE

(

DomainName VARCHAR(1000)

);

DECLARE @DomainShortList TABLE

...

Not recommended for use in production, but used for dev/test you run:

DBCC DROPCLEANBUFFERS()

to clear the cache to simulate having to read everything from disk.

As Sean has said, they aren't tabs, they are carriage returns (CHAR(13)) If they were tabs you wouldn't get multiple rows, you'd get multiple columns in excel.

There...

This isn't really the way SSRS is designed to work. There are a couple of ways you could possibly do it, but I haven't tried, nor would I recommend either....

Sounds like you may have an issue with the scope. So you probably need something like SUM(TotalTurnover.Value, [Group Name]). Check out BOL, http://technet.microsoft.com/en-us/library/dd283120(v=sql.105).aspx

Issues with different white space characters is a pain. You just need to use the CHAR/NCHAR function in the REPLACE, like this:

DECLARE @data NVARCHAR(MAX) = 'EXEC Proc_gen' + CHAR(9)...

I think you need to look at FailPackageOnFailure and/or FailParentOnFailure properties at the package level.

Yes, you need either PATINDEX or LIKE in order to do what you want. You'd need to test to find out which one will perform better.

That value is larger than the max value for BIGINT so you need to use a different datatype like this:

SELECT Cast(('20140304800084500001') AS DECIMAL(20, 0))

Great. Glad it looks like we were able to piece together something that helped.

So if, I'm understanding better you need something like this:

DECLARE @d DATETIME;

SET @d = '3-1-14';

DECLARE @sales TABLE

(

period TINYINT ,

...