It's Monday and I'm in one of those moods

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.

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?

leeholden
Starting Member

34 Posts

Posted - 2002-04-08 : 10:25:11

Bring on the SQL Variant Yukon.

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?

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

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.

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