Viewing 15 posts - 48,136 through 48,150 (of 59,064 total)
Ok... here it is... had to look. Copy the query I gave you and paste it into the SQL pane of the query designer. Make sure the table...
September 21, 2008 at 6:54 pm
Heh... Sorry, I wouldn't know. I don't use query designer to design queries. What I gave you is the "core" of the query that you'd end up with.
September 21, 2008 at 6:42 pm
SELECT sot.*
FROM dbo.SomeOtherTable sot
INNER JOIN dbo.TheValues tv
ON sot.TheData = tv.TheData
WHERE tv.[Desc] = 'ComPeriod'
September 21, 2008 at 6:26 pm
Being that the company you're talking about appears to be nearly ignorant of SQL in general and probably would not have used any advanced features, my suggestion would be to...
September 21, 2008 at 6:11 pm
Sorry... that formula makes no more sense than the origianl post. Please see the link in my signature...
September 21, 2008 at 6:02 pm
psangeetha (9/19/2008)
select * from sales where (sales_id = 1123013 AND sales_in_no >= 199901 AND sales_in_no <= 199701)
This is the output I get from the execution...
September 21, 2008 at 5:54 pm
Yes... please see the following link which is a bit of a "how to" along with some things to avoid when doing this type of concatenation.
September 21, 2008 at 5:51 pm
Very cool. Thanks for the feedback. If you get the chance and your not violating any company agreement, could you post your final query? It might help...
September 21, 2008 at 5:43 pm
Not 100% sure, but I don't believe that's what the OP is looking for. I believe they want to go someplace through T-SQL to figure out what the max...
September 21, 2008 at 5:37 pm
Heh... my problem is that I don't use things like SSIS or DTS because I do it all in T-SQL. My appologies.
September 21, 2008 at 5:34 pm
Cool... thanks for the feedback. Were you able to sucessfully incorporate the patient ID or do you still need any help?
September 21, 2008 at 5:32 pm
Perfect. Thanks for the feedback, Tk...
September 21, 2008 at 5:30 pm
You bet. Thanks a bunch for the feedback. 🙂
September 21, 2008 at 10:32 am
You don't need explicit loops to do this... just the correct type of WHERE clause. This will find all rows in SomeTable that have special characters in SomeCol...
SELECT...
September 21, 2008 at 10:06 am
With the info given, there's no need for a loop.
SELECT RANK() OVER(PARTITION BY ID ORDER BY BudPerc DESC) AS Rank, *
FROM Table1
WHERE ID BETWEEN 1 AND 10
The...
September 21, 2008 at 10:01 am
Viewing 15 posts - 48,136 through 48,150 (of 59,064 total)