Luis Cazares (1/27/2015)

---

If it's a string column with underscores between each part of the date. This could be an option.

SELECT columns_to_return

FROM dbo.XYZ

WHERE date_column > REPLACE( CONVERT(...

I too like the column on the left and expression on the right. I also like to use the year argument to know I am interested in one year back,...

I thought something like the following may be helpful as well , based on your requirements of course...

select postalCode = Case when patindex('%[0-9]%',postalcode) > 0

...

keshav_nitrkl (1/23/2015)

---

Hi ,

My report is having three fields : NAME || Level || ID .I have a single dataset and a filter to my dataset. The dataset filter should work...

Is this the case also on your copy of the environment?

declare sorder cursor for

select SRREFERENCE

--,@updateflag = SlaUpdate

from inserted

open sla

FETCH NEXT FROM sla INTO @salesorder

WHILE @@FETCH_STATUS = 0

BEGIN

Would this cursor not only gather one row? (I assume you meant that...

Good point on the results to text. I have the habit of throwing the results to grid, doing a click on the select all corner of the results tab, copying...

EXEC SP_HELPTEXT 'schema.viewName';

This formats the output across multiple lines rather than just one. I find it way handier when copying long definitions to the SSMS window.

phil.doensen (1/15/2015)

---

You should also do explicit database log backups (as well as normal backups) or make sure your recovery model is set to "simple" or your log file will grow...

I have not seen a mention of the Data Flow task. That is SSIS's bread and butter item for moving data around. Since you mention about 4000 rows per batch...

I think the business intelligence products (SSIS , SSAS , SSRS ) are a huge plus if you are looking at the warehousing side of things and not...

I think the OP may just want a general illustration , may not be solving anything in particular. Here is another method :

declare @t table

(

ID int

...

The screen shot shows your initial size for the first file at 155GB, not 100GB.

If this picture is incorrect I can suggest tinkering with the data management views to detect...

You could go the way of variable expressions here with a data flow within the for loop container. Unless I am missing something you could:

variable,

type,

expression

-----------------------------------

StaticFolderNum,

int32,

no expression...

For the plan that still does not work, did you try changing the "Local Server Connection" in the maintenance plan to a custom one with the account used being Windows...