Viewing 15 posts - 601 through 615 (of 5,504 total)
Can you please provide some ready to use sample data and your expected result?
For a guideline how to do that please see the first link in my signature.
This will not...
February 19, 2012 at 12:58 pm
A google search for "connection is busy with results for another hstmt" indicates there's an issue with more than one acive cursor per connection:
This error generally happens because an ODBC...
February 17, 2012 at 3:50 pm
What makes you think this query would not work?
Did you gave it a try?
If so, what errors did you get?
February 17, 2012 at 12:10 pm
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 ...
February 17, 2012 at 10:44 am
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...
February 17, 2012 at 10:33 am
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...
February 16, 2012 at 3:50 pm
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>'
)
February 15, 2012 at 1:13 pm
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...
February 14, 2012 at 4:38 pm
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...
February 14, 2012 at 4:14 pm
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...
February 14, 2012 at 2:25 pm
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...
February 14, 2012 at 11:16 am
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:...
February 14, 2012 at 10:47 am
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).
February 13, 2012 at 3:17 pm
Dave Brooking (2/13/2012)
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...
February 13, 2012 at 2:18 pm
It's just been a typo. No reason to apologize twice. 😀
February 13, 2012 at 2:01 pm
Viewing 15 posts - 601 through 615 (of 5,504 total)