Viewing 15 posts - 13,756 through 13,770 (of 15,381 total)
I see you are new around here. Welcome. If you could post some ddl, sample data (insert statements) and desired output based on your sample you will likely get some...
October 11, 2011 at 12:17 pm
valeryk2000 (10/11/2011)
Actually after some experimenting I am convinced that null-containing records ARE included in the result set
Yes, that is what I showed you in my first post. Just because a...
October 11, 2011 at 12:12 pm
valeryk2000 (10/11/2011)
And (out of the topic!) how to place the code into that nice lookink box as you do?
There are a couple ways to do it. When typing, look over...
October 11, 2011 at 12:11 pm
Are saying you are partitioning by 5 fields but if it has a null it should make it part of some other group? Which group would it belong to? That...
October 11, 2011 at 12:09 pm
This do it?
where MyFieldThatHasNullsThatIDontWant is not null
October 11, 2011 at 12:00 pm
Not exactly sure what your question is but the following may help answer it for you.
with sampledata(Value, CanBeNull) as
(
select 1, 1
union
select 2, 1
union
select 3, null
union
select 4, null
)
select...
October 11, 2011 at 11:43 am
Cool. I still find on each new project that I wish I had known about such and such way of doing things before. That is actually a good thing. It...
October 11, 2011 at 10:11 am
pdonley (10/11/2011)
October 11, 2011 at 9:56 am
jared-709193 (10/11/2011)
Sean Lange (10/11/2011)
jared-709193 (10/11/2011)
Sean Lange (10/11/2011)
October 11, 2011 at 9:53 am
pdonley (10/11/2011)
No that's fine, that's the whole point of forums. If we all went about our merry way doing things our way all the time, no one would ever innovate.
I...
October 11, 2011 at 9:43 am
jared-709193 (10/11/2011)
Sean Lange (10/11/2011)
October 11, 2011 at 9:36 am
Just another point of view on your business objects creating your sql. What happens when the data structure changes slightly? You have to recompile and deploy all your applications that...
October 11, 2011 at 9:28 am
Just to take a totally different approach to this. Could you not have just run a trace? This would have shown you what the actual statements were. To solve the...
October 11, 2011 at 9:21 am
I would have to agree with John. Auditing belongs in the database. If it is in your application how can you create your audit trail when the data is updated...
October 11, 2011 at 9:16 am
The other question is WHY would you want to take something out of sql server and move it to Access??? You are going backwards on performance and scalability.
As Kraig said,...
October 11, 2011 at 7:54 am
Viewing 15 posts - 13,756 through 13,770 (of 15,381 total)