Viewing 15 posts - 8,521 through 8,535 (of 8,731 total)
You're right Sean, I missed something.
EDIT: I need more coffee or to read more carefully.
August 29, 2012 at 9:03 am
I had the idea that the group by would do the sort. However, it might not be the safest thing to do it.
Your query gave me some incorrect results when...
August 29, 2012 at 8:31 am
I tested my last solution and won't give the exact results.
Try this instead:
;with MyRank (col1)
as
(
select 6 union all
select 5 union all
select 4 union all
select 3 union all
select 2 union all
select...
August 29, 2012 at 8:14 am
Another option:
;with MyRank (col1)
as
(
select 5 union all
select 4 union all
select 3 union all
select 2 union all
select 1 union all
select 1 union all
select 1
)
SELECT TOP 5 col1
FROM MyRank
GROUP BY...
August 29, 2012 at 8:07 am
You could return a 'Z' or a NULL
SELECT NextLetter = CASE WHEN ascii(@Letter) IN (122,90)
THEN NULL --What would you return here?
...
August 29, 2012 at 7:58 am
Please, don't go step by step.
You have 3 posts very similar and it seems to me that you're not giving us the entire problem.
If we're aware of the whole context,...
August 29, 2012 at 7:31 am
Have you tried a JOIN instead of the IN?
I've read there can be unexpected problems with cross-server queries.
SELECT --USE DISTINCT if there are multiple rows in vwCRMServiceProviderAccess
SP.[ServiceProviderGuid],
SP.[ServiceProviderTypeGuid],
SP.[ServiceProviderName],...
August 29, 2012 at 6:49 am
Indeed, the query is wrong and it won't take you near to the solution.
I suggest you to avoid that opinion and stay with Dwain's solution.
August 28, 2012 at 1:29 pm
Next time you should post on the correct forum. 😉
You could have avoided that Lynn hits his head with the desk.
Seriously, you can get better answers if you do so.
August 28, 2012 at 1:01 pm
Lynn, your solutions are great :-D. But this is the 7,2000 forum 🙁
I wonder if that helps the OP.
August 28, 2012 at 12:24 pm
Divide and Conquer.
Divide your html into 3 parts: headers, rows and closure.
OK, I misread. All you have to do is add an ISNULL outside the CAST.
However, the original suggestion is...
August 28, 2012 at 12:06 pm
Eugene Elutin (8/28/2012)
anuj12paritosh (8/28/2012)
HI ALLPLEASE PROVIDE SOME EASY WAY IF YOU KNOW
THANKS
The easiest way to achieve that will be switching to SQL2012 and using sequences.
All others ways will not...
August 28, 2012 at 9:50 am
Too complicated. Keep it simple.
create procedure dbo.STORED_PROC_NAME
(
@sstrg varchar(100)
)
as
begin
set nocount on;
--declare @strg varchar(100) = 'Catalog',
set @sstrg = '%' + REPLACE( @sstrg, '*', '%') + '%'
SELECT project_name
FROM groups
WHERE...
August 28, 2012 at 9:18 am
OK, so here's the dynamic query. Simple and effective. As you see, the real query is just hitting 2 tables, the Certs table is just used to create the query....
August 28, 2012 at 8:45 am
Viewing 15 posts - 8,521 through 8,535 (of 8,731 total)