Forum Replies Created
Viewing 15 posts - 3,706 through 3,720 (of 26,490 total)
-
RE: For loop container : Issue with date counters
And why are you storing a date value as a character string? It should be stored as a date data type.
-
RE: DateTime is less than minumum value supported by CrmDateTime
You may want to check the data type in the SSIS package pulling the data. If it is expecting a smalldatetime data type and the source isn't a smalldatetime...
-
RE: Syntax help needed for UPDATE Statement
drew.allen (6/2/2016)
mw112009 (6/2/2016)
Good,I was also asked to use the LTRIM(RTRIM( around the fields so that there be no spaces around. How can we handle that ?
[rant on]
If you...
-
RE: Who is successfully running VSS snapshots with any third party Backup software without any collisions?
Two things I'd do. One, schedule my SQL backups such that the timing does not interfere with the Nimble backups. Two, configure the backups such that if they...
-
RE: Get date range of last quarter
The following should help:
d e c la r e -- spaced to post from work
@ThisDate date = getdate();
select
@ThisDate,
...
-
RE: Create or update rows on the basis of time interval
And before we do your work (or homework) for you, what have you tried to solve your problem?
-
RE: DBCC CHECKDB JOB STOPPED EXECUTION
coolchaitu (6/2/2016)
Hi Gail Shaw,When we manually restarted the job after 1 hour,it did not encounter any log backup jobs. and it did consistency checks on all databases.
Then you are basing...
-
RE: DBCC CHECKDB JOB STOPPED EXECUTION
coolchaitu (6/1/2016)
Hi Jeff,It was management's decision. So, can we conclude that it stopped when it ran for the first time due to log backup job running at same time?
You may...
-
RE: Error while parsing a string with " & " as XML
You may want to read this article: http://www.sqlservercentral.com/articles/Tally+Table/72993/
-
RE: Beginning and End of Year, Month, Etc.
Zidar (6/1/2016)
It seems that a Calendar table would help big time. To learn more, you may want to check this post:🙂
Make it work for everyone:
http://www.sqlservercentral.com/blogs/dwainsql/2014/03/30/calendar-tables-in-t-sql/
-
RE: Beginning and End of Year, Month, Etc.
Does this help?
d e c l a r e -- spaced to post from work
@TestDate date = dateadd(day,-2,dateadd(week,datediff(week,0,getdate()) - 1,0));
with DayNumbers as (
select
...
-
RE: Beginning and End of Year, Month, Etc.
swansonm (6/1/2016)
Our weeks run Saturday through Friday. The month the week falls in is determined by Saturday's date.For example, the week containing 5/2 begins on 4/30. This...
-
RE: Performance / Query Tuning Question Regarding Missing Indices
I have also seen the Missing Index DMVs and DTA recommend a nonclustered index that if implemented duplicated the entire table in the index between indexed and included columns.
Take the...
-
RE: Are the posted questions getting worse?
Thanks all. I was able to figure it all out, brain was disengaged after lunch so a couple of them just did not look right to me at the...
-
RE: Join Issues - Data Inconsistency
Lynn Pettis (6/1/2016)
gfoxxy93 (6/1/2016)
It might be me, but I think two or three of those diagrams may be wrong. I'll have to set up some tests to verify.
Okay, I'm...
Viewing 15 posts - 3,706 through 3,720 (of 26,490 total)