ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,626 through 8,640 (of 10,143 total)

RE: Updating one table with records from another

Something like this should do the trick, Joseph:
INSERT INTO TableB ([column list])
SELECT ([matching column list from TableA] including GETDATE() AS DateUpdated)
FROM TableA a
LEFT JOIN TableB b
ON b.[four digit...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

March 27, 2009 at 4:23 am

#967275
RE: Grouping

Mark beat me to it - but here's a slightly different way:
-- make some sample data
DROP TABLE #sales
CREATE TABLE #sales (productname VARCHAR(20), turnover MONEY)
INSERT INTO #sales (productname, turnover)
SELECT 'redwine', 40...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

March 27, 2009 at 3:57 am

#967266
RE: Sort by Question

Is this what you're looking for?
-- make up some sample data
DROP TABLE #tbl_Listings
CREATE TABLE #tbl_Listings (Location VARCHAR(20), Price MONEY)
INSERT INTO #tbl_Listings (Location, Price)
SELECT 'RM10', 100000 UNION ALL
SELECT 'RM20', 200000 UNION...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

March 27, 2009 at 2:34 am

#967246
RE: how to convert a bigint value to datetime

bhuwnesh.kumar (3/27/2009)
In a table, datetime is stored in a column with type bigint. Values stored in this column are of 13 digits.
How these values can be converted to simple...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

March 27, 2009 at 2:19 am

#967244
RE: T-Sql rant

foxjazz (3/26/2009)
Have any of you seen the challace and viewed another way it looks like a face?
Or a cube drawn on paper, and how the perspective can change.
I liken doing...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

March 26, 2009 at 10:06 am

#966805
RE: Starttime of the next row have to be the endtime of the previous row.....

Blimey Gus, just as a matter of interest (and on a hunch after reading something Gail wrote some time ago) I set this up with a correlated subquery to compare...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

March 26, 2009 at 10:04 am

#966802
RE: Are the posted questions getting worse?

Luke L (3/26/2009)
Best part is one of the local wineries grow radioactive grapes for their wines, or so the story goes... Never tested it to see if it really glows...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

March 26, 2009 at 9:30 am

#966778
RE: Are the posted questions getting worse?

Grant Fritchey (3/26/2009)
Besides, I've operated nuclear power plants while inebriated (not my fault, my chief liked drinking partners) and nothing happened.
If anybody wants to know what Grant looked like...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

March 26, 2009 at 8:37 am

#966721
RE: Long running queries when using DISTINCT with Strings

Here's some sample data:
DROP TABLE #Question
CREATE TABLE #Question(
[ID] [bigint],
[UserID] [bigint] NULL,
[VisitorID] [bigint] NULL,
[Text] [varchar](20) NULL,
[TimeStamp] [datetime] NOT NULL,
[ViewCount] [bigint] NOT NULL,
[MetaKeywords] [nvarchar](50) NULL,
[MetaDescription] [nvarchar](50) NULL,
[PageURL] [nvarchar](50) NULL,
[CategoryID] [bigint] NULL,
[LocationID]...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

March 26, 2009 at 8:16 am

#966695
RE: Long running queries when using DISTINCT with Strings

sorry I am unable to get your point please explain again !
Check the [ID] column in your table. Is it unique or does it have duplicates?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

March 26, 2009 at 7:20 am

#966636
RE: Are the posted questions getting worse?

Roy Ernest (3/26/2009)
Sure, No problem..
Just hop over on the next plane to Curacao. You can lie down on the beach and drink what ever you want. I will take care...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

March 26, 2009 at 7:17 am

#966631
RE: Long running queries when using DISTINCT with Strings

Can you run this query and post the results, please? You may wish to change sensitive data but if you do, please explain exactly which columns have been changed.
SELECT TOP...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

March 26, 2009 at 7:10 am

#966623
RE: Long running queries when using DISTINCT with Strings

musab (3/26/2009)
Column1 is the Text Column
Column2 is the Source Column
I need to concatinate both the columns and then need to Remove the duplicates
The rows are complete duplicates all the data...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

March 26, 2009 at 6:32 am

#966575
RE: Long running queries when using DISTINCT with Strings

musab (3/26/2009)
The Column1 i.e. Text contains questions and I need to find unique questions and there are different questions in it and duplicates as well so I just need to...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

March 26, 2009 at 6:07 am

#966562
RE: Long running queries when using DISTINCT with Strings

Can you tell us something about the distribution of values in column1? Does the column have unique values which could be omitted from your process?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

March 26, 2009 at 5:54 am

#966555

Viewing 15 posts - 8,626 through 8,640 (of 10,143 total)