LutzM

Forum Replies Created

Viewing 15 posts - 601 through 615 (of 5,502 total)

RE: T-SQL Query help for extracting data between special chars

What makes you think this query would not work?
Did you gave it a try?
If so, what errors did you get?

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

February 17, 2012 at 12:10 pm

#1448725
RE: Select ALL the text from a text data type

Would it help to convert it to xml instead of dealing with the text data type (which is deprecated anyway, so you should consider using xml or varchar() instead...)
Declare ...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

February 17, 2012 at 10:44 am

#1448655
RE: T-SQL Query help for extracting data between special chars

It looks like you're looking for a split string function and a CrossTab solution.
One solution could look like this:
DECLARE @tbl TABLE
(
ID INT,
[PATH] VARCHAR(30)
)
INSERT INTO @tbl
SELECT 11...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

February 17, 2012 at 10:33 am

#1448649
RE: reading html

If your initla post was too simplistic, please provide a more descriptive version of what you're looking for. Your latest reply still indicate that REPLACE would be the way to...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

February 16, 2012 at 3:50 pm

#1448208
RE: reading html

Would a rather standard REPLACE help?
SELECT
REPLACE (
'<body><p><a code1="111111"</a></p></body>' ,
'<a code1="111111"</a>' ,
'<a code1="111111" code2="222222"</a>'
)

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

February 15, 2012 at 1:13 pm

#1447519
RE: SQL Client Access Licence requirements

Since "MS" is a rather large group: do you know a person or a group we could contact?
(The local rep we've asked didn't leave the impression that such specific licence...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

February 14, 2012 at 4:38 pm

#1447096
RE: SQL Client Access Licence requirements

Regarding your original question:
I read the licence term exactly the same way as you do with one exception: when you mention "SQL", you're not referring to SQL Express...
Especially the mail...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

February 14, 2012 at 4:14 pm

#1447090
RE: Help with a float value

Hmm... When running the following code the correct result will be returned in both cases.
can you post a similar sample code with a value that would allow to duplicate the...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

February 14, 2012 at 2:25 pm

#1447062
RE: SQL, VMs, and Backups... Oh my...

Whenever there's a VM snapshot involved, keep in mind you'll loose any MS support!!
For details please see http://support.microsoft.com/kb/956893/en-us
Quote:
Virtualization Snapshots for Hyper-V or for any virtualization vendor are not supported to...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

February 14, 2012 at 11:16 am

#1446983
RE: IT Budget

There are many tools out there for many different tasks. Some are more reliable than others, some are considered "better" than others (but that's usually just personal preference).
The question is:...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

February 14, 2012 at 10:47 am

#1446966
RE: Help with query

You reference e.ProductName__c but this column is not part of your subquery.
Either the column is included in the subquery or should be referenced based on Customers.dbo.Lead (l.ProductName__c).

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

February 13, 2012 at 3:17 pm

#1446557
RE: Getting Most Recent Date

Dave Brooking (2/13/2012)
Would the windowing version of the MAX function be useful here?
Replace the line
MAX(AP_Ex.Ap_Expt_Date) AS CRN_SIS_AD_AP_Ex_Ap_Expt_Date
with
MAX(AP_Ex.Ap_Expt_Date) OVER (PARTITION BY AP_Ex.Student_ID) AS CRN_SIS_AD_AP_Ex_Ap_Expt_Date
and remove the...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

February 13, 2012 at 2:18 pm

#1446510
RE: Getting Most Recent Date

It's just been a typo. No reason to apologize twice. 😀

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

February 13, 2012 at 2:01 pm

#1446503
RE: Getting Most Recent Date

Edit: no longer relevant 😀

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

February 13, 2012 at 1:49 pm

#1446495
RE: Getting Most Recent Date

masonvann (2/13/2012)
Thanks, Lutz. I think I understand - One result set per Student_ID as long as the other rows match in every column except AP_Ex.Ap_Expt_Date. If you don't mind another...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

February 13, 2012 at 1:34 pm

#1446483

Viewing 15 posts - 601 through 615 (of 5,502 total)