ChrisM@Work

Forum Replies Created

Viewing 15 posts - 4,771 through 4,785 (of 10,143 total)

RE: Different in count of records.

Kumara1011 (4/22/2013)
If we take specific column in the count function, its fine.
But when i am using count(*), it showing difference.
i found that in background one command is executing i.e.,
DBCC...
^{“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

April 23, 2013 at 1:39 am

#1608960
RE: The Cascading (CROSS) APPLY

Divya Agrawal (4/22/2013)
ChrisM@Work (4/22/2013)
Divya Agrawal (4/19/2013)
DECLARE @T TABLE (auditlogid int, userid int , auditlog varchar(max))
INSERT into @T
select 1,1,'ProgramCompletionStatus - ProgramNotCompleted, '
union all
select 1,1,'InputValidationStatus - Success, IsValidUserID - Yes,...
^{“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

April 23, 2013 at 1:21 am

#1608957
RE: Are the posted questions getting worse?

jcrawf02 (4/22/2013)
Brandie Tarvin (4/22/2013)
So this morning as I'm getting ready for work, I can't find earrings to match my shirt and I say "I need more jewelry."
The SO looks at...
^{“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

April 22, 2013 at 6:57 am

#1608673
RE: Is it possible to create tables Dynamically using Cursors from another table with csv values

Jeff Moden (4/22/2013)
ChrisM@Work (4/19/2013)
This is an unusual transport file with metadata (partial, column names only) and data as string on the same row.
BWAAAA-HAAA!!!!! I say the same thing everytime...
^{“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

April 22, 2013 at 6:36 am

#1608664
RE: Different in count of records.

darren.morgan 32557 (4/22/2013)
Could it be ignoring rows that have a null value for the field you are performing sum on?
-- No
SELECT COUNT(*), SUM(Total)
FROM (
SELECT ID = 1, total = 10...
^{“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

April 22, 2013 at 6:00 am

#1608651
RE: Is it possible to create tables Dynamically using Cursors from another table with csv values

sravan.here (4/19/2013)
All the similar rows should go into one table. In my example, row 1 and 3 will be in table and 2 will be another table. but my metatable...
^{“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

April 22, 2013 at 5:27 am

#1608642
RE: The Cascading (CROSS) APPLY

Divya Agrawal (4/19/2013)
DECLARE @T TABLE (auditlogid int, userid int , auditlog varchar(max))
INSERT into @T
select 1,1,'ProgramCompletionStatus - ProgramNotCompleted, '
union all
select 1,1,'InputValidationStatus - Success, IsValidUserID - Yes, IsValidProgramID -...
^{“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

April 22, 2013 at 1:25 am

#1608605
RE: Is it possible to create tables Dynamically using Cursors from another table with csv values

sravan.here (4/19/2013)
Yes there are tables with 4 or 5 or more columns as well as you doubted.
I have just provide a simple example here.
But the maximum column names (with csv)...
^{“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

April 19, 2013 at 5:36 am

#1608155
RE: Are the posted questions getting worse?

rodjkidd (4/19/2013)
wolfkillj (4/19/2013)
ChrisM@Work (4/19/2013)
Sean Lange (4/18/2013)
patrickmcginnis59 10839 (4/18/2013)
Time and again I've read in the news folks absolutely ruin their own lives over dumb forum stuff even when posting under what...
^{“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

April 19, 2013 at 5:30 am

#1608153
RE: how to convert the below subquery to joins

surendiran.balasubramanian (4/19/2013)
how to convert the below subquery into join ..
SELECT CtryId, WrkflwId, Dt
FROM stepHistory H
WHERE EXISTS
(SELECT * 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

April 19, 2013 at 3:24 am

#1608126
RE: need help in creating a procedure which uses cursor and variables

Luis Cazares (4/18/2013)
I wish I could help you, but I don't understand what you're trying to do.
Please take a look at the article linked in my signature to obtain better...
^{“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

April 19, 2013 at 2:55 am

#1608116
RE: Are the posted questions getting worse?

Sean Lange (4/18/2013)
patrickmcginnis59 10839 (4/18/2013)
Time and again I've read in the news folks absolutely ruin their own lives over dumb forum stuff even when posting under what they perceive 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

April 19, 2013 at 2:52 am

#1608114
RE: Is it possible to create tables Dynamically using Cursors from another table with csv values

sravan.here (4/18/2013)
Hi,
Yes please see the Create table script for source table and the insert script as well
CREATE TABLE yt
([ID] int, [Name] varchar(14), [text] varchar(21))
;
INSERT INTO yt
([ID], [Name], [text])
VALUES
(1, 'SID,DOB', '123,12/01/1990'),
(2,...
^{“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

April 19, 2013 at 2:49 am

#1608113
RE: Find number of weekdays(Monday,Tuesday..) between two dates monthwise

Stephen Yale (6/18/2008)
.....
How do I do it without using a cursor?
.....
Here's one way:
CREATE FUNCTION [dbo].[IF_Calendar]
(
@StartDate DATE,
@EndDate DATE,
@FirstWeekDay VARCHAR(10)
)
RETURNS TABLE WITH SCHEMABINDING AS
RETURN
(
-- inline tally table
WITH E1(N)...
^{“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

April 18, 2013 at 9:43 am

#1607842
RE: Rewrite query using LEFT JOIN

Or this:
SELECT
active_flag = CASE WHEN c.active_flag = 1 THEN 'Active' ELSE 'Inactive' END,
c.name,
c.company_code,
d.active_users,
d.new_users,
d.inactive_users,
test_company_flag,
parent_company_flag
FROM dbo.company c
LEFT JOIN (
SELECT
company_code,
active_users= SUM(CASE WHEN active_flag = 1 AND unregister_flag = 0 THEN 1...
^{“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

April 18, 2013 at 6:54 am

#1607711

Viewing 15 posts - 4,771 through 4,785 (of 10,143 total)