Forum Replies Created
Viewing 15 posts - 496 through 510 (of 683 total)
-
RE: Query to retrieve row level value as Column wise
This might be useful...
http://www.sqlteam.com/item.asp?ItemID=2955
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: 3 Min Values (7 Column Outcome Required)
Post the update in the first post...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=274064
...please don't create a new thread in this situation.
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Need update statement for the following
Duplicate post...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=275152
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: How to filter out unwanted data
Same question here...
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65167
...and here...
No clarification of the problem on any of them yet...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Need Update Statement for the following
Something like this?
--data
declare @door table (door_id int, door_status bit)
insert @door
select 1, 0
union all select 2, 0
union all select 3, 1
union all select 4, 1
union all...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: adding a column where data required is "next row date field"
Hi Phil (and Vladan),
Vladan's solution looks good to me (I actually did it the same way and then saw that he had beat me to it!).
I'm not sure the result...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Row To Column
Hi Minh Vu (and all),
It looks like your example isn't a sufficient representation of your problem. Can you 'enhance' it for us please?
Here's one trick that might be useful (it's...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Date comparision issue Help !! Urgent
Hi all,
For my own amusement, I took a look at some end points for a few of the methods...
--data
declare @t table (d datetime)
insert @t
select '20060424...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: [Urgent] :positioning the results in 7 columns
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65115
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Nested case statements
Yes, it's possible. e.g.
select
id,
case when id between 1 and 7 then
case when id = 1 then 'one' when id = 2 then 'two'...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: If condition is not working properly
Objective view you say?...
create view objective as select 'poor joke' as 'objective view'
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: How to Retrieve the columns...
You have to list all the columns. You can just type them out, but I'm guessing it's that you want to avoid.
There...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: 3 Min values Query
Hi Jawad,
Here's one way. Note that it does not cope with ties. Let us know if it needs to.
--data
declare...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Week number of the month
Was there something wrong with what I posted? Here, I'll make it easier for you...
I agree with Noeld that it's better to put...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: problem with a view, its not bring back rows with null in it
Pieter - As I say, I can't get my head around your situation without some sample data. I guess if it's working for you, then don't worry.
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
Viewing 15 posts - 496 through 510 (of 683 total)