Viewing 15 posts - 586 through 600 (of 5,502 total)
The solution below is based on the DelimitedSplit8K fuction referenced in my signature expanded by an additional output column
Position = CHARINDEX(@pDelimiter,@pString,s.N1),
This allows to check for the number of...
February 23, 2012 at 5:14 am
Duplicate post. No replies please.
Discussion already started here
February 23, 2012 at 4:16 am
For a new line character you should use "\ n" without the space.
February 23, 2012 at 4:13 am
It depends if you're looking for an additional criteria:
WHERE CABWO_CABLE_WORK_ORDERS.WO_NO=[Please Enter WO Number] AND CABWO_CABLE_WORK_ORDERS.ISS_NO)=[Please Enter Issue Number] AND CABWO_WO_DETAILS.TITLE)=[Please Enter Title];
or an alternative criteria:
WHERE ((CABWO_CABLE_WORK_ORDERS.WO_NO=[Please Enter WO Number] AND...
February 23, 2012 at 4:11 am
The question what isolation level to use depends on the expected result for a given scenario.
In your case:
What should App2 return as amount while App1 update the amount column from...
February 23, 2012 at 4:03 am
I'd use the CrossTab method as described in the related link in my signature.
To apply the concep to your scenario, it would look something like
SELECT
MAX(CASE WHEN display_value='BROADCAST_2'THEN Param_value ELSE NULL...
February 23, 2012 at 2:28 am
Duplicate post. No replies please.
Discussion already started here.
February 23, 2012 at 2:21 am
I'd recommend to create the view at SQL Server level and tune that view. Once the view is tuned, link it to Access.
A few checks to consider:
Do you have a...
February 22, 2012 at 4:35 pm
Great you found the solution.
Would you mind sharing it so others might benefit? Remeber, it's a two-way street here 😉
February 21, 2012 at 3:29 pm
Edit: complaint no longer valid. Immediately fixed by the OP. Well done!
February 21, 2012 at 3:25 pm
I guess the OUTER APPLY approach will return the data you're looking for:
SELECT *
FROM #temp1
OUTER APPLY
(
SELECT TOP 1 *
FROM #temp2
WHERE ...
February 19, 2012 at 4:22 pm
What is the data type of EndDate and StartDate?
February 19, 2012 at 3:12 pm
Are you looking for a simple DATEDIFF() statement?
SELECT CableBoxID,DATEDIFF(dd,StartDate, EndDate)
FROM CableBoxTable
February 19, 2012 at 2:33 pm
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
Viewing 15 posts - 586 through 600 (of 5,502 total)