ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,541 through 9,555 (of 10,143 total)

RE: Populating an IDENTITY column

It won't do any harm to have an identity column in your table, one which isn't populated with data from your spreadsheet but which is automatically assigned a value as...
^{“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

September 22, 2008 at 7:42 am

#874973
RE: SELECT

Here's a little sample data in case this thread is revisited.
[font="Courier New"]SET NOCOUNT ON
DROP TABLE #Entity
CREATE TABLE #Entity (entity_id INT, template_id INT, [name] VARCHAR(20))
INSERT INTO #Entity (entity_id, template_id, [name])
SELECT...
^{“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

September 22, 2008 at 7:13 am

#874950
RE: Subquery error!

Thanks for the feedback Neil, good luck!
^{“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

September 22, 2008 at 5:48 am

#874898
RE: Subquery error!

Hi Neil
I reckon this is what you want. Note that there were a couple of missing commas in the SELECT list.
[font="Courier New"]SELECT CL1.CLIENT_UNO, CL1.NAME_UNO, MA1.MATTER_UNO, MA1.CLNT_MATT_CODE, CL1.CLIENT_NAME, NA1.[NAME],
PE2.LOGIN,...
^{“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

September 22, 2008 at 5:21 am

#874885
RE: Simple query to return weeks within date range

Hi Glen
You will probably find some useful material in the following post:http://www.sqlservercentral.com/Forums/Topic570892-145-1.aspx
Cheers
ChrisM
^{“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

September 22, 2008 at 4:42 am

#874867
RE: Procedure

Hi Ramya
If you set up your formula expression as a string and EXECute it, then any variables defined in the calling batch will be out of scope to the batch...
^{“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

September 22, 2008 at 4:19 am

#874862
RE: Procedure

Hi Ramya
Can't you run the statement as it is? I can't see a need for EXEC:
[font="Courier New"]IF @AssessableValue > 0
   SET @BED_BaseAmt = @AssessableValue * @Qty
ELSE
   SET @BED_BaseAmt = @price...
^{“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

September 22, 2008 at 3:54 am

#874853
RE: Procedure

Hi Ramya
You are getting this error message because the batch executed by the EXEC statement cannot reference variables declared in the batch from which it was called.
You could use...
^{“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

September 22, 2008 at 3:12 am

#874841
RE: Group by Date....

Not at all b_boy, it's a learning experience for us all. How about posting up some sample data and results? Everybody would appreciate this.
^{“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

September 19, 2008 at 3:18 pm

#874477
RE: Use String Function

'Number' is the Tally table - check the link in Matt's earlier post.
^{“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

September 19, 2008 at 3:14 pm

#874474
RE: help wit "IF" sub query

John
It's a bit of a guess, as Lynn has pointed out, but I reckon this is what you're looking for:
DECLARE @x VARCHAR (5)
SET @x = 'true'
SELECT id1, id2, id3
FROM...
^{“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

September 19, 2008 at 9:32 am

#874327
RE: Using Joins and Derived tables

It's too big a step in one go. You need to find out how many rows are returned by each temp table without aggregation, and in particular, how many rows...
^{“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

September 19, 2008 at 9:14 am

#874307
RE: getting week number of the current year

ALZDBA (9/19/2008)
I'm used to that :w00t:
1) married
2) dba
:D:):P:w00t::hehe:
And if you have children you will lose your voice completely 😛
^{“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

September 19, 2008 at 8:48 am

#874281
RE: Using Joins and Derived tables

beruken (9/19/2008)
I think I understand that. I was able to build the derived output but still had the problem with master table. IS it possible to keep this result in...
^{“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

September 19, 2008 at 8:43 am

#874277
RE: Using Joins and Derived tables

Not sure you need to do that. First thing I'd do is check the joins. You've got TT_StaffingPlan INNER JOIN TT_Users
but
TT_EntryLog RIGHT OUTER JOIN TT_Users
You need to find out...
^{“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

September 19, 2008 at 8:27 am

#874260

Viewing 15 posts - 9,541 through 9,555 (of 10,143 total)