Viewing 15 posts - 11,731 through 11,745 (of 15,381 total)
Agreed that the formatting was a bit challenging but a great question. Thanks Lynn!!!
June 6, 2012 at 7:06 am
villanueva.jonel (6/5/2012)
I have to clear my requirements.
I want to pullout records based on date and time(hour).
In my samples i have date range from 2012/06/04 and...
June 6, 2012 at 6:54 am
Tripz (6/5/2012)
I removed all the 3 functions and updated the query accordingly and executed it. it is taking 10 sec to execute now.
Thank you for all the help
I am trying...
June 6, 2012 at 6:46 am
My buddies and I have tickets to the Victory Suite for tonight's Open Cup match at Livestrong Park. The Victory Suite is usually reserved for cancer survivors (and thankfully their...
June 5, 2012 at 3:12 pm
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
Viewing 15 posts - 11,731 through 11,745 (of 15,381 total)
