Viewing 15 posts - 4,921 through 4,935 (of 5,109 total)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.All works for me... 😉
I...
September 16, 2016 at 6:05 am
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...
September 15, 2016 at 3:54 am
coool_sweet (9/14/2016)
what should i do
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,...
September 14, 2016 at 9:23 am
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...
September 14, 2016 at 8:49 am
mytesting9 (9/14/2016)
When I runMsg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.il_SplitDelimitedStringArray'.
and it does not provide me solution yet .Pls help .
I've got to be honest, but...
September 14, 2016 at 7:56 am
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...
September 14, 2016 at 6:47 am
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...
September 14, 2016 at 5:00 am
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,...
September 13, 2016 at 8:40 am
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...
September 13, 2016 at 4:36 am
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...
September 5, 2016 at 9:01 am
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 will start fresh one.
Not...
September 5, 2016 at 8:39 am
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...
September 5, 2016 at 7:35 am
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...
September 1, 2016 at 9:50 am
In a development, or production, environment you should really be running the SQL Services under a proper network login. They don't need to be the same across the board (Agent...
September 1, 2016 at 9:40 am
Seems Spiff beet me to it before I finished!
September 1, 2016 at 7:48 am
Viewing 15 posts - 4,921 through 4,935 (of 5,109 total)