Kiara (10/28/2011)

---

J Livingston SQL (10/28/2011)

---

Ok...got the test data now (dev machince at work 🙂 )

have you any performance figs...you say your query is "slow"...based on the test data what...

Ok...got the test data now (dev machince at work 🙂 )

have you any performance figs...you say your query is "slow"...based on the test data what response times are you...

Hi Ki

I will try again with your test rig....earlier on I thought it was my PC playing up...until I saw Jeff's post.

think I will reboot and start over.

Jeff Moden (10/28/2011)

---

Nope. Good to go here. My only other question is how many rows does your test data jig create? I started it this morning in...

with no data/examples/require results to work on....

pure guess...have you tried LEFT OUTER JOINS?

+1...please, it would be much appreciated.

one way that may work for you, dependent upon the data.....

SET fax_number_varchar = CAST(fax_float as int)

Phil Parkin (10/23/2011)

---

I feel like I've stepped into a parallel universe. The language sounds like English, but I don't understand it.

Can you please try again to explain what you are...

just an idea :

USE [tempdb]

GO

CREATE TABLE [dbo].[TableXY](

[Y] [int] NOT NULL,

[XMIN] [int] NOT NULL,

[XMAX] [int] NOT NULL,

[RESULT] [int] NULL,

CONSTRAINT [PK_TableXY] PRIMARY KEY CLUSTERED

(

[Y] ASC,

[XMIN] ASC,

[XMAX] ASC

)

) ON [PRIMARY]

GO

INSERT INTO...

Have you researched SSAS (Analysis Services) as Ninja suggested?

! am learning a course on Data Warehousing. Any fact table in a data warehouse may be accompanied by aggregate fact tables...

does this work for you:

order by LEFT(name,1), ASCII(name) desc

hmmm...:-)

this is quite a speciic statement ...that is also clearly prescribed on the "Challenge" under

__________________________________________________________

http://beyondrelational.com/puzzles/challenges/101/find-the-longest-sequence-of-alphabets-in-a-string.aspx

1 . Restrictions

The...

is the OP question related to the following article:

http://www.sqlservercentral.com/articles/T-SQL+Challenges/76259/

??

To erhanduman ..the OP

I hope that we havent hijacked your original post to the extent that you are unable to find some ideas.....;-)

Performace Guard (Shehap) (10/15/2011)

---

You could proceed it using the below query :

create table #temptable (F1 int, [F2.1] varchar (20), [F2.2] varchar (20), [F2.3] varchar (20))

insert into #temptable (F1 )

select...