Viewing 15 posts - 8,431 through 8,445 (of 13,876 total)
yusufm 48726 (5/7/2015)
spaghettidba (5/7/2015)
What's the problem? Not returning the data you expect?Can you please post:
- Table scripts
- Sample data
- Expected results?
See http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/ for directions.
it does not return any data on...
May 7, 2015 at 8:39 am
Try bringing it in as a decimal ... that is how Excel stores datetimes.
May 7, 2015 at 8:32 am
Same functions in both editions, no need to worry.
May 6, 2015 at 12:30 pm
For many of us "seasoned" people, I'm sure the concept and word are nothing new, but I think it could be a paradigm shift for the beginner.
Not just beginners....
May 6, 2015 at 7:15 am
Can you please advise how to get rid of this truncation error?
Why should you have to code around this?
Speak to whoever created the file and explain that it violates...
May 2, 2015 at 12:53 am
1) Have you checked that the statement is running in the right database?
2) Why not truncate the table rather than drop/create?
May 1, 2015 at 3:22 pm
xddevv (4/30/2015)
Once the file is deposited in the shared drive, there is no other process that uses that file.
I read other articles about permissions, but I think thatβs...
April 30, 2015 at 9:15 am
Is there a chance that some other process has the file open when the job runs? Are you editing it yourself? π
April 30, 2015 at 9:04 am
Try this
select t.Person
,UpdatedDate = max(isnull(t.UpdatedDate, getdate()))
from #Table1 t
group by t.Person;
April 29, 2015 at 6:06 am
select *
from dbo.T1 t1
cross apply (select Code = min(Code)
...
April 29, 2015 at 5:54 am
Koen Verbeeck (4/29/2015)
Phil Parkin (4/29/2015)
Unless you've paid over US$10,000 for a licence, you cannot use it as Enterprise on a production server.$10,000? That's a bargain π
I did say 'over', as...
April 29, 2015 at 3:22 am
Unless you've paid over US$10,000 for a licence, you cannot use it as Enterprise on a production server.
April 29, 2015 at 3:11 am
ankithimmatlalshah (4/29/2015)
I was assigned a work item wherein, I've a dataflow task on For Each Loop container at control flow of SSIS package. This For Each Loop container reads...
April 29, 2015 at 12:59 am
Viewing 15 posts - 8,431 through 8,445 (of 13,876 total)