Viewing 15 posts - 8,431 through 8,445 (of 13,876 total)
SKY986 (5/7/2015)
Thanks! I got an error saying the function requires 3 arguments?
Post your SQL please.
May 7, 2015 at 12:17 pm
select CO_Owner = iif(Ordinal = 0,NULL,CO_Owner)
May 7, 2015 at 11:09 am
yusufm 48726 (5/7/2015)
May 7, 2015 at 9:25 am
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
Viewing 15 posts - 8,431 through 8,445 (of 13,876 total)