Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

How about something elementary like

"Select the number which is the smallest number expressible as the sum of two cubes in two different ways"

Options:

1) 1024

2) 1729

3)...

ThomasRushton (9/16/2016)

---

Sean Lange (9/16/2016)

---

BWFC (9/16/2016)

---

jasona.work (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream....

I...

Assuming in both instances that ReportDate is today's date, or the date the report is being run for.

SQL:

dateadd(month, datediff(month, 0, @ReportDate) - 1, 0)

SSIS Expression:

DATEADD("mm",DATEDIFF("mm", (DT_DBTIMESTAMP)"1/1/2000", @[User::ReportDate]) - 1, (DT_DBTIMESTAMP)"1/1/2000")

In...

Normalise the data. You should never be added an extra field onto a table each time you have a new value. You should have two tables.

If,...

SSIS can't dynamically pick up new columns. You have to add the column manually and update the package. there's no other option.

AS above, why are you adding a new column...

I've got to be honest, but...

So effectively your looking at:

Day run: Sunday/ Top line day: Saturday/ Board day: Friday

Day run: Monday/ Top line day: Sunday/ Board day: Friday

Day run: Tuesday/ Top line day: Monday/ Board...

I'm really not sure what it is your asking here. CAn you give a full details of your requirements. Please supply DDL and insert statements for your tables.

Taking it literally...

I can see, sanjeeva, that you've edited your post after our two replies, but I'm not really sure what you've added. You're always best replying to people, rather than editing,...

Looking very quickly, you have a part of your code as follows:

OPEN db_getTaskSchFreq

FETCH NEXT FROM db_getTaskSchFreq INTO @TSF_CM_VITAL_TASK_SCHEDULE_ID,@FREQUENCY_TIME

WHILE @CM_VITAL_TASK_SCHEDULE_ID = @TSF_CM_VITAL_TASK_SCHEDULE_ID

BEGIN

PRINT @SCHSTARTDATE+1

END

--------

CLOSE db_getTaskSchFreq

That while loop in clearly incomplete, as once...

Phil Parkin (9/5/2016)

---

Thom A (9/5/2016)

---

Phil Parkin (9/5/2016)

---

I'm planning to use function to remove spaces, quotes and "JR" , is there any function already exists?.so I can reuse same else I...

Phil Parkin (9/5/2016)

---

Not...

How would you treat the string if someone had missed a character?

For example, would "dhana" and "dana" be a 80% match, or a 20% match (or even 75%/25% depending on...

It is Visual Studio 2010 you're looking for for SQL Server 2012. As far as I know as well, VS is not backward, or forward, compatible with SSRS. No idea...