Viewing 15 posts - 10,906 through 10,920 (of 26,487 total)
I don't see any subqueries in the code provided, so I'm confused as to why you would get this error message on the simple update provided.
July 2, 2012 at 9:39 am
Bill Talada (7/2/2012)
declare @t table (UserName varchar(3), ids varchar(10))
insert into @t values ('Tom', '1,2,3')
insert into @t values ('Sue', '4,5,6')
select *
from @t t
cross apply dbo.BuildKeyTableForDelimitedString(t.ids)
If you are going to use a...
July 2, 2012 at 9:14 am
dwilliscp (7/2/2012)
Does SQL have something (like Pick) that will search a string, and then break the string apart by that char?For example... using the underscore
asdl;kfj_doske
fjdkls_lkjd
into..
asdl;kfj
doske
fjdkls
lkjd
Have you searched this site for...
July 2, 2012 at 9:09 am
Please read the last article I reference below in my signature block about Managing Transaction Logs. You really should not be shrinking you t-logs on a regular basis as...
July 2, 2012 at 1:07 am
rjbirkett (7/1/2012)
Thanks for helping me solve this. I did a LOT of reading, and made the changes. I also modified the code and created a...
July 2, 2012 at 12:29 am
Using the following sample data, what would your expected results be?
DECLARE @SAMPLE TABLE
(
ID INT NOT NULL,
ACCOUNT CHAR(4) NOT NULL,
ORGANIZATION CHAR(3) NOT NULL,
SUBGROUP CHAR(2) NOT NULL,
AMOUNT int NOT NULL
)
INSERT @SAMPLE
VALUES (1,...
July 1, 2012 at 2:22 pm
How do you decide which group to keep if there is an exact match between the sets on the duplicate criteria? Also, do you keep the group that is...
July 1, 2012 at 2:18 pm
yingchai (7/1/2012)
Lynn Pettis (7/1/2012)
July 1, 2012 at 11:29 am
WayneS (7/1/2012)
Lynn Pettis (6/26/2012)
Waiting for email updates...
July 1, 2012 at 11:27 am
What is the criteria for eliminating subgroups from the result set? Hard to give you an answer when we don't know the rules that need to be applied.
July 1, 2012 at 3:50 am
Just a few more things.
One, I would change the CTE as I showed in my last post and change the group by back to its original state.
Two, please ask any...
June 30, 2012 at 2:30 pm
There is another way to fix this as well.
This CTE can be modified as such and the group by changed back to the original code.
with SampleData as (
select
cast(MsgText as varchar(8000)...
June 30, 2012 at 2:18 pm
rjbirkett (6/30/2012)
June 30, 2012 at 2:14 pm
rjbirkett (6/30/2012)
Msg 306, Level 16, State 2, Line 102
The text, ntext, and image data types cannot be compared or sorted, except...
June 30, 2012 at 2:05 pm
I'm not sure what is going on here. I was able to process the data you provided with no modifications. All I did was insert it into a...
June 30, 2012 at 2:02 pm
Viewing 15 posts - 10,906 through 10,920 (of 26,487 total)