ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,446 through 8,460 (of 10,143 total)

RE: DML in Functions

mithun.gite (4/22/2009)
Dear friends,
Need understanding, that y v can perform DMLs in Functions?
We can use DMLs using table variable in fucntion then y can with actual tables..
Please guide me thru..
Mithun
From BOL:
The...
^{“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, 2009 at 1:52 am

#981983
RE: Error between unicode and non-unicode string data types!

Assuming the table you're importing into is a staging table - which it should be - then change the data type of the receiving column to NVARCHAR.
Staging tables can...
^{“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, 2009 at 1:37 am

#981979
RE: Update table using procedure - Help

jchandramouli (4/21/2009)
Hi,
Please run this query in a new window. This will give 2,3 as result. Now i need to update the procedure output (results : 1) to the table 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 22, 2009 at 1:30 am

#981977
RE: t-sql question

UPDATE t SET overbook_flag = 'Y'
FROM #temp1 t
INNER JOIN (SELECT ROW_NUMBER() OVER (PARTITION BY doctor ORDER BY apptcreatedate) AS Appt_Number,
appt_count, appt_limit, apptcreatedate, doctor
FROM #temp1) d
ON...
^{“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, 2009 at 12:58 am

#981967
RE: unique problem in performance of a procedure

Can you post the code please Kavin?
^{“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 21, 2009 at 12:59 am

#981216
RE: Distinct Query Problem

sward (4/20/2009)
I am applying it to DISTINCT ilr.person_code but i would need to have access to all the other columns related to the results that the distinct defines. Maybe there...
^{“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 20, 2009 at 1:32 am

#980536
RE: What's the best way to compare two tables?

WayneS (4/17/2009)
Chris Morris (4/17/2009)
What do you want as your output, Wayne?/quote]
I'm trying to get things from table1 that are different from table2. I was able to get it through above...
^{“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 17, 2009 at 11:01 am

#979842
RE: What's the best way to compare two tables?

What do you want as your output, Wayne?
If you want to find out fast if two tables match exactly on a set of columns, then here's a simple place 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

April 17, 2009 at 10:42 am

#979825
RE: Reverse string without built in functions

Pinal Dave's reverse function has this code in it:
RETURN (REVERSE(@StringToReverse))
^{“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 17, 2009 at 10:17 am

#979793
RE: t-sql joins

Hello
Here's your daily table create statement, and some sample data. If you can do the same with the other table, then it will make it much easier for someone 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

April 17, 2009 at 9:54 am

#979769
RE: combining select statement in mssql

bvinay57 (4/17/2009)
Hi
thanx for ur immediate response in my db i have Table1,Table2,Table3 tables i want to retrive data using select statement first i want to retrive data from Table1 after...
^{“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 17, 2009 at 9:38 am

#979758
RE: Are the posted questions getting worse?

jcrawf02 (4/17/2009)
RBarryYoung (4/17/2009)
Chris Morris (4/17/2009)
RBarryYoung (4/16/2009)
john.arnott (4/16/2009)
Am I so obsessed with big round numbers that I would ...
Coincidentally, that's also how I got my first date... :w00t:
C'mon Barry ya...
^{“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 17, 2009 at 8:59 am

#979731
RE: combining select statement in mssql

Hello
Please can you provide more information about your tables, the columns, and the expected output?
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

April 17, 2009 at 8:55 am

#979729
RE: Are the posted questions getting worse?

There's nothing wrong with being a chubbychaser!
Dammit, where are those screenwipes? 😀
^{“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 17, 2009 at 6:08 am

#979567
RE: CASE statement kills performance

David, I reckon there's an error in the WHERE clause - it's challenging writing code with no data to test against - but try this:
WHERE date_sent between @start_date and @end_date
and...
^{“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 17, 2009 at 6:01 am

#979563

Viewing 15 posts - 8,446 through 8,460 (of 10,143 total)