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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 1, 2016 at 9:40 am
Seems Spiff beet me to it before I finished!
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 1, 2016 at 7:48 am
Viewing 15 posts - 4,921 through 4,935 (of 5,109 total)