Viewing 15 posts - 8,776 through 8,790 (of 13,876 total)
krypto69 (1/15/2015)
I'd prefer to do it all in SSIS, but it's not a requirement.
Is there a way to do use an external file splitter and call it from...
January 16, 2015 at 12:26 am
Do you have to do this in SSIS, or could you create the (big) file as usual and then use some other tool to split the file? Are the files...
January 15, 2015 at 12:29 pm
Prudhvi _SQL (1/15/2015)
SELECT CAST(CAST(datefield AS DATE) AS DATETIME)FROM datetable
Why stop there?
How about
select cast((stuff(stuff(convert(char(8), datefield, 112), 5, 0, '-'), 8, 0, '-')) as datetime)
?:hehe:
January 15, 2015 at 12:24 pm
Try:
Select dateadd(day, datediff(day, 0, datefield), 0) as datefield
from datetable
Hope this helps.
Same execution plan for my solution, though yours does return the zero time component & is therefore a more...
January 15, 2015 at 10:09 am
TSQL Tryer (1/15/2015)
2013-05-10 08:15:24.000
I want it to just return - 2013-05-10 00:00:00.000, so the time...
January 15, 2015 at 9:45 am
Has the column IDENTITY() definition changed in the table's DDL?
January 15, 2015 at 4:31 am
I probably made this a little harder than what it could have been
Let me remove any doubt: yes you did! 🙂
But it works and that's great. Should you decide...
January 15, 2015 at 12:13 am
sm_iransoftware (1/14/2015)
We need to run Always on , on our sql servers.
Is there any upgrade or benefits on sql server 2014 about Always on ?
Or
Should I Upgrade to 2014...
January 14, 2015 at 5:23 am
Just a standard FOREACH loop should be sufficient for this.
If you configure the FEL something like this[/url], you will see that, for every file processed, the full file path can...
January 14, 2015 at 12:18 am
scottichrosaviakosmos (1/12/2015)
question is how to get the desired output.
What is the desired output?
January 13, 2015 at 12:12 am
DonlSimpson (1/9/2015)
It's interesting that neither of these:
substring('aeiouy', cast(rand() * 6 + 1 as int), 1)substring('aeiouy', cast(ceiling(rand() * 6) as int), 1)
exhibit the same problem.
There is no (implicit or explicit)...
January 9, 2015 at 9:11 am
SQLSACT (1/9/2015)
I came across the following T-SQL query in an article I was reading.
Can someone please explain what type of query this is?
Is this some type of correlated...
January 9, 2015 at 3:51 am
Thank you Jeff, that is an outstandingly good explanation.
Thanks also for the TOP (n) trick to force the generation of a query plan. I wish I'd known that before.
For fun,...
January 9, 2015 at 12:47 am
stucker (1/8/2015)
Well I'm such a newbie I thought SSCertifiable was your screen name. Sorry Phil LOL. And thanks again.
Haha, no problem :hehe:
January 8, 2015 at 12:19 pm
Change it back to
select COALESCE(SUM(WD.WRKD_MINUTES), 0)
and modify the final row:
) < 2400
select E.EMP_ID
,E.EMP_FULLNAME [EMPLOYEE NAME]
,(CONVERT(varchar, DATEADD(DD, - 6, GETDATE()), 101) + ' - ' + CONVERT(varchar, GETDATE(), 101)) as...
January 8, 2015 at 11:32 am
Viewing 15 posts - 8,776 through 8,790 (of 13,876 total)