😛 ah Jeff, i knew it right away that...

You can do it with a WHILE or you can utilize dynamic SQL to make each row a EXEC statement and execute it..

Kev, this is ultra fast method of splitinng the strings.. its called DelimitedSplit8k.. i currently lost the link to it.. search this site for that, u ll be amazed by...

Copy paste error bro 🙂

here is the corrected code:

-- solution 1

select FlightName , NumberOFsegmets = COUNT(SegmentID)

, (select top 1 inner_temp.DeparturePlace from temp inner_temp

...

Solution 1:

select FlightName , NumberOFsegmets = COUNT(SegmentID)

, (select top 1 inner_temp.DeparturePlace from temp inner_temp

where inner_temp.FlightName = outer_temp.FlightName

...

So lazy, are we ?? 😀

Try this:

UPDATE @TheTable

SET put_IT_HERE = NTILE(2) OVER(PARTITION BY Type_Here ORDER BY ( CASE WHEN Tab_id%2 =...

No Lutz, i dont have.. sorry.. i couldnt remember the...

How about this?

select * , Rn = NTILE(2) OVER(PARTITION BY Type_Here ORDER BY ( case when Tab_id%2 = 0 THEN 1

else 0 end ) ) From @TheTable

order by Tab_id

Whts your expected result out of your sample data?

LutzM (3/30/2011)

---

Something like this?

SELECT t.name AS table_name,

c.name AS column_name,

y.name AS column_type,

...

Two ways (there may be more ways :-))

1. Using the INFORMATION_SCHEMA Views such as information_schema.columns, information_schema.tables

2. Using sys.objects, sys.tables and sys.columns SYSTEM views. JOIN these tables to get what you...

ROFL :hehe: :hehe:

decimal value (30,9) = A value that will have 30 digits in total ( numbers before point and after point , but excluding the character "point") ; AND there can...

😉

How about this?

SELECT

inv.Name,

inv.Domain,

inv.[User],

inv.127.0.0.1,

MAX( CASE WHEN arp.Name LIKE '%Office%' THEN arp.Name END) AS OfficeName ,

MAX( CASE WHEN arp.Name LIKE...