Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««3,8973,8983,8993,9003,901»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Monday, February 18, 2013 10:23 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:26 PM
Points: 23,009, Visits: 31,503
Really? Answer to what?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1421294
Posted Monday, February 18, 2013 10:34 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:58 AM
Points: 4,386, Visits: 3,394
Lynn Pettis (2/18/2013)
Really? Answer to what?

It is a koan, "What is the look of an empty string, centered?"
Post #1421299
Posted Monday, February 18, 2013 10:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:11 AM
Points: 5,568, Visits: 24,744
Lynn Pettis (2/18/2013)
Really? Answer to what?


Thanks ... I needed a laugh today


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1421300
Posted Monday, February 18, 2013 10:45 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:21 PM
Points: 1,210, Visits: 2,512
Lynn Pettis (2/18/2013)
Really? Answer to what?


I voted!


Jason Wolfkill
Blog: SQLSouth
Twitter: @SQLSouth
Post #1421302
Posted Tuesday, February 19, 2013 1:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:33 AM
Points: 7,050, Visits: 6,799
L' Eomot Inversé (2/18/2013)
David Burrows (2/18/2013)
L' Eomot Inversé (2/18/2013)
[quote]And then we have the same problem with double quotation marks inside the text;


Thanks Tom, I thought of that as well and I intended my post to be tongue in cheek, oh well .
I wasn't sure whether it was TiC or serious.
As already stated before any character used could be a problem as it could also be part of the data.
I like the idea of an ad-hoc delimeter.
Or maybe having a SET option to specify it.

SET would be a pain in the butt for this: suppose your varchar string needs to contain all 256 distinct 8-bit characters, with a delimeter specified as part of the constant you can split it into chunks and use + to join them together, with SET you would have to declare variables and concatenate them; so the variable delimiter as part of the expression, albeit something of a mess in the nastiest case, is less pain than using SET which in turn is less pain than using teh current system.
There is always the option of using QUOTENAME

I agree with your " ".
QUOTENAME doesn't work for 129 character strings (or anything longer), and anyway needs the argument to be a sting already so you can't use it to solve the problem unless you've already solved the problem without it. Or could we (a) define a topology on the universe of string expressions in such a way that an infinite sequence of incomplete string expressions each using QUOTENAME to try to refine its predecessor would have a single limit point which would be the right string and (b) define some finite notation to designate such a sequence - if we could achieve that (which I doubt) we would only have to fix the 128 character limit. Oh, and of course make it work for char and varchar as well as for nchar and nvarchar, so it wouldn't actually be QUOTENAME as char is forbidden there.


Nice reply Tom

Regarding SET I was referring to it's use in setting an option such as SET QUOTED_IDENTIFIER OFF
Like SET STRING_DELIMETER '\'
rather than repeating it ad-hoc

This still requires that the delimeter (or escape sequence) is not present in the data which is the crux of the problem.



Far away is close at hand in the images of elsewhere.

Anon.

Post #1421471
Posted Tuesday, February 19, 2013 1:31 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:51 PM
Points: 2,607, Visits: 17,910
Has anyone here had experience with DB recovery companies/consultants on a Sybase database? The DB is corrupted, backups are too (except for one 9 months old), and they want to salvage as much data as possible. It's not MSSQL, but I told them I'd ask my friends (yes, that's you!) if they knew anyone reputable with experience in the Sybase arena.

Thanks,
Chad
Post #1421833
Posted Wednesday, February 20, 2013 10:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:25 PM
Points: 6,146, Visits: 7,198
Hey folks, can I get some help here: http://www.sqlservercentral.com/Forums/Topic1421888-392-1.aspx#bm1421965

A very pleasant newbie... I just don't understand what he's trying to say. New eyes on the problem might make sense of what he's attempting.



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1422215
Posted Wednesday, February 20, 2013 11:01 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:53 AM
Points: 2,751, Visits: 7,161
Evil Kraig F (2/20/2013)
Hey folks, can I get some help here: http://www.sqlservercentral.com/Forums/Topic1421888-392-1.aspx#bm1421965

A very pleasant newbie... I just don't understand what he's trying to say. New eyes on the problem might make sense of what he's attempting.


He wants to create a report from two tables. He's getting his header info from one table and the body info from another. The queries are straightforward, it comes down to how he's creating the report.


--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Post #1422218
Posted Wednesday, February 20, 2013 3:55 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:53 PM
Points: 3,786, Visits: 1,084
Guys,

Have you realized that:

- there are over 1.6M members in this community as of today?
- we're getting closer to 39K posts on this thread?

Congratulations, everyone. Way to go!!!
Saludos,


"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan
Post #1422342
Posted Wednesday, February 20, 2013 4:05 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 12:05 PM
Points: 8,556, Visits: 9,047
Close to 39k? No, there's still 100+(39*24) to go.

Tom
Post #1422345
« Prev Topic | Next Topic »

Add to briefcase «««3,8973,8983,8993,9003,901»»»

Permissions Expand / Collapse