ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,181 through 9,195 (of 10,143 total)

RE: Problem on OPENROWSET

Zahran, there is an error in the provider string in your openrowset statement.
The syntax should be like this
SELECT * from OpenRowSet('SQLOLEDB', 'Server=BARENELL;Trusted_Connection=yes;', 'select SERVERPROPERTY(''MachineName'')')
where BARENELL is the name of...
^{“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

December 10, 2008 at 8:40 am

#910425
RE: Are the posted questions getting worse?

Ouch!
I don't mind working hard at a sport, taking a few risks is ok too, but getting hurt is not on the agenda.
Give me this anytime:
http://s279.photobucket.com/albums/kk123/leafy_bow/wye%20valley%202008/?action=view&current=IMGP0139.jpg
^{“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

December 10, 2008 at 8:25 am

#910414
RE: Are the posted questions getting worse?

Grant Fritchey (12/10/2008)
Excellent form on the roll.
I don't have a good one of flying. However, from here:
http://www.alandallessandrokarate.com/images/shihan_and_foxwoods_pictures.jpg
to here (look way off in the background):
http://www.alandallessandrokarate.com/images/shihan_and_foxwoods_pictures.jpg
Flight was involved.
They don't work, Grant,...
^{“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

December 10, 2008 at 8:11 am

#910400
RE: Are the posted questions getting worse?

GilaMonster (12/10/2008)
I don't have any photos of what Steve's taking about. I was too busy getting pounded into the mat by Kalen.
I do have a couple of fairly good photos...
^{“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

December 10, 2008 at 8:08 am

#910399
RE: Unit Availibility Query

What values did you assign to startdate and enddate?
^{“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

December 10, 2008 at 7:45 am

#910368
RE: Dynamically add column in procedure

Also, why use dynamic sql for this?
SELECT @SQL= 'ALTER TABLE MARKS_SHEET ADD OPTION VARCHAR(50)'
EXEC SP_EXECUTESQL @SQL
^{“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

December 10, 2008 at 7:03 am

#910314
RE: Unit Availibility Query

Hi Mark
What you'd normally do now is use the output from this bit which you've figured out - which is "bookings" - and use it as a filter in a...
^{“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

December 10, 2008 at 6:59 am

#910310
RE: Problems with 'Invalid Column Name' when executing dynamic SQL

Hi Neal
The easiest way to debug dynamic SQL is to print the content of the variable, paste it into a window and attempt to execute it.
Printing your first version gives:
[font="Courier...
^{“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

December 10, 2008 at 6:02 am

#910264
RE: Problem on OPENROWSET

Zahran (12/10/2008)
This code lists databases available in the local server, not remote server 10.0.172.53. ODS database is available in the remote server. So, ODS database does not listed in 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

December 10, 2008 at 5:49 am

#910254
RE: Problem on OPENROWSET

Chris Morris (12/10/2008)
Can you see the database ODS in the output generated by this:
SELECT a.* FROM OPENROWSET(
'SQLOLEDB',
'Trusted_Connection=yes;Integrated Security=SSPI;DataSource=''10.0.172.53'';' ,
'SELECT [name] FROM master.dbo.sysdatabases') AS a
This code...
^{“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

December 10, 2008 at 5:38 am

#910245
RE: Problem on OPENROWSET

Zahran (12/10/2008)
I get list of databases available in the local server. But I need to retrieve data from Remote server.
What is the name of the database on the remote server...
^{“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

December 10, 2008 at 5:14 am

#910231
RE: Slow function

pino_daddy (12/10/2008)
ALTER FUNCTION [dbo].[ConvertGMTToEST](@DateTime DateTime)
-- converts the GMT time to EST time based on the siebel S_TIMEZONE and S_TIMEZONE_TMP tables.
-- returns the datetime in EST
returns datetime
as
BEGIN
RETURN DATEADD(MINUTE, ISNULL((SELECT TOP 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

December 10, 2008 at 5:11 am

#910226
RE: Problem on OPENROWSET

Zahran (12/10/2008)
ODS database is not available in the local server. It is available in the remote server. I need get data from remote server.
Thanks for your reply. When I execute...
^{“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

December 10, 2008 at 4:52 am

#910217
RE: Problem on OPENROWSET

Zahran (12/10/2008)
Hi Chris Morris,
Thanks for your reply. When I execute your code I get database available in the local server. Not the remote server(10.0.172.53).
Then you don't need OPENROWSET. Run 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

December 10, 2008 at 4:44 am

#910215
RE: display Full date values which falls under 2 input date values

sabarichandru (12/10/2008)
Hi chris,
i need a o/p in column .
This will do it:
DECLARE @InputDate DATETIME, @DayCount INT
SET @InputDate = '01-12-2008'
SET @DayCount = 1 + DATEDIFF(dd, @InputDate, GETDATE())
SELECT DATEADD(dd, 1-N.number, GETDATE())...
^{“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

December 10, 2008 at 4:42 am

#910214

Viewing 15 posts - 9,181 through 9,195 (of 10,143 total)