Viewing 15 posts - 11,731 through 11,745 (of 15,377 total)
IgorMi (6/5/2012)
Hi,It is like the other inserts.
Example
The table:
CREATE TABLE [dbo].[UrlSet](
[Tip] [smallint] NOT NULL,
)
The insert:
Insert Into UrlSet(Tip,url)
Values (1,'<Urls NavigationGroup="1">
<Item ItemUrl="~/About.aspx" />
</Urls>')
I don't know what your other inserts...
June 5, 2012 at 2:16 pm
With over 400 points you know what is coming...
We need some details here. You want to insert what into what table? What does the table look like?
DDL, sample data (maybe...
June 5, 2012 at 2:08 pm
Alexander Suprun (6/5/2012)
Sean Lange (6/5/2012)
Alexander Suprun (6/5/2012)
Sean Lange (6/5/2012)
Tripz (6/5/2012)
my UserPreferences i.e bbbb has comma separated region ids and category ids, that is the reason to use fn_split function
I...
June 5, 2012 at 1:20 pm
Alexander Suprun (6/5/2012)
Sean Lange (6/5/2012)
Tripz (6/5/2012)
my UserPreferences i.e bbbb has comma separated region ids and category ids, that is the reason to use fn_split function
I understand the point of...
June 5, 2012 at 12:56 pm
Tripz (6/5/2012)
Table bbbb is nothing but t_UserPreferencesand table cccc is nothing but resumes
So bbbb is the same as t_UserPreferences?
What about t_regions?
my UserPreferences i.e bbbb has comma separated region ids...
June 5, 2012 at 12:44 pm
Cliff Jones (6/5/2012)
L' Eomot Inversé (6/1/2012)
Cliff Jones (5/30/2012)
I like a home brewed double chocolate stout made using a kit from the Home Brewery.
Is Jimmy Carter still a hero to American...
June 5, 2012 at 11:11 am
Lynn Pettis (6/5/2012)
From OP's second post:
OK so we did have indexes (although at first glance they don't seem to help much here). The rest of everything I said is still...
June 5, 2012 at 10:39 am
We still need definitions for
t_UserPreferences
t_regions
And we still need sample data and desired output.
There are lots of things that can be done to improve the performance of this. One thing you...
June 5, 2012 at 10:36 am
OK so to compile all of the details we have so far into a single post, here is the ddl as you have posted.
CREATE TABLE [dbo].[aaaa] (
[ID] [int] IDENTITY(1, 1)...
June 5, 2012 at 10:32 am
hunmunnar (6/5/2012)
I have scenario where table field names are in short terms.
Field actual name is extracted using another table.
Please provide an sql query to view data such that short terms...
June 5, 2012 at 9:46 am
You will probably need a staging table to hold the original data. Use SSIS to import the data into a table in sql. Then you can parse each row into...
June 5, 2012 at 9:29 am
I agree too. The query posted matches exactly to the desired results you posted. Excellent job posting ddl, sample data and desired output!!! I wish more people would do that.
You...
June 5, 2012 at 9:11 am
ACinKC (6/5/2012)
June 5, 2012 at 8:37 am
nu_bie (6/5/2012)
Sean Lange (5/31/2012)
June 5, 2012 at 8:11 am
I googled that error message and there are tons and tons of people with different solutions to this issue. It seems there is an answer out there that will help...
June 5, 2012 at 8:01 am
Viewing 15 posts - 11,731 through 11,745 (of 15,377 total)
