Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 It's Monday and I'm in one of those moods

Author  Topic 

jongregg
Starting Member

31 Posts

Posted - 2002-04-08 : 10:06:18
The expression - "You can't fit a square peg into a round hole". Not exactly true if you've got a big enough mallet.

In programming terms, what is the mallet?

I would equate it to the varchar type.

Any other suggestions?

Jon


robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-04-08 : 10:10:48
quote:
"You can't fit a square peg into a round hole". Not exactly true if you've got a big enough mallet.


I am strangely turned on by this......need...therapist...now

Is varchar giving you the shits? Come, talk to us. Tell us what's troubling you. We're here to listen and help.

Go to Top of Page

jongregg
Starting Member

31 Posts

Posted - 2002-04-08 : 10:19:50
I've given up smoking and currently chewing on nicotine gum. My mind wanders off at tangents.....

My mallet is at the 8000 maximum. I need a bigger mallet. What can I do?


Go to Top of Page

leeholden
Starting Member

34 Posts

Posted - 2002-04-08 : 10:25:11
Bring on the SQL Variant Yukon.

Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-04-08 : 10:46:20
You need to store more than 8K in a column? What about text?

Go to Top of Page

jongregg
Starting Member

31 Posts

Posted - 2002-04-08 : 10:59:42
Hmmmmm....Good question? this has sprung up from a problem I had a while ago. I am creating dynamic sql views based on data in a table but the sql to create the view was > 8000 characters so I couldn't execute the SQL statement.

I was lucky in that I managed to redefine the view into two separate views where each was < 8000 characters, but I was just kinda wondering if there is a solution to the problem.

If you are wondering why a view statement could contain more than 8,000 characters, I'm producing a cross-tab report based on 50 entries for each record (Does that make sense!?!?!)

Ah...Nicotine. The most dangerous drug known to man.

Jon


Go to Top of Page

ToddV
Posting Yak Master

218 Posts

Posted - 2002-04-08 : 11:14:02
I once did this by storing the Sql in a text column in a temp table. After all the code was there I set up a loop to populate multiple variables and the executed the concatenation of the variables. Probably not a real good solution, but it worked. Alternatively, I guess you could wirte the sql out to file and use osql to execute it.

Go to Top of Page

Nazim
A custom title

1408 Posts

Posted - 2002-04-08 : 11:23:09
Speaking About Cross tab did you checked this master stroke from Rob http://www.sqlteam.com/item.asp?ItemID=2955

quote:

I'm producing a cross-tab report based on 50 entries for each record (Does that make sense!?!?!)



--------------------------------------------------------------
Go to Top of Page

jongregg
Starting Member

31 Posts

Posted - 2002-04-08 : 11:28:43
Excellent. I shall remember that for the future.

Cheers
Jon

"Text - a bigger mallet than the varchar!"




Go to Top of Page
   

- Advertisement -