ChrisM@Work

Forum Replies Created

Viewing 15 posts - 946 through 960 (of 10,143 total)

RE: Counting Values from a database

paul 69259 - Friday, January 27, 2017 7:46 AM
ChrisM@Work - Friday, January 27, 2017 7:35 AM
^{“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

January 27, 2017 at 7:52 am

#1925334
RE: SQL Server Managment Studio 2008 R2 hanging with blue circle

chris.asaipillai-624309 - Friday, January 27, 2017 4:09 AM
Hi there
I am running SQL Server Management Studio (version 2008 R2) on Windows 7 (64...
^{“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

January 27, 2017 at 7:49 am

#1925333
RE: Counting Values from a database

Focus first on ensuring that your existing query is correct. Comment out
s.SALESDESCRIPTION
^{“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

January 27, 2017 at 7:35 am

#1925330
RE: Muliple Comma Seperated values insert into table without using cursor

Twice in the same day 🙂 Try this thread.
^{“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

January 27, 2017 at 7:01 am

#1925315
RE: Counting Values from a database

paul 69259 - Friday, January 27, 2017 2:48 AM
Hi, I have created a view here is the code ..............
USE [Quartz]
GO
/******...
^{“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

January 27, 2017 at 6:51 am

#1925311
RE: Convert number stored as text to number

eddiewillcox - Friday, January 27, 2017 6:15 AM
ChrisM@Work - Friday, January 27, 2017 6:09 AM
^{“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

January 27, 2017 at 6:31 am

#1925307
RE: Convert number stored as text to number

If dtDateTime is a datetime field then it's stored internally as a number - but displays according to local settings. Are you absolutely sure it's a datetime? If it is,...
^{“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

January 27, 2017 at 6:12 am

#1925300
RE: Convert number stored as text to number

It looks like it's not a space in the middle then...it's a different character.
Put this
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

January 27, 2017 at 6:09 am

#1925299

RE: Convert number stored as text to number

Thanks Eddie. Have a play with this. Order by the two prices, ascending and descending, and do a "stare and compare" - you're looking for values which won't convert 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

January 27, 2017 at 5:45 am

#1925293

RE: Convert number stored as text to number

eddiewillcox - Friday, January 27, 2017 4:08 AM

ChrisM@Work - Friday, January 27, 2017 3:01 AM

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 27, 2017 at 4:12 am

#1925275

RE: Convert number stored as text to number

funbi - Friday, January 27, 2017 2:53 AM

eddiewillcox - Friday, January 27, 2017 2:38 AM

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 27, 2017 at 3:01 am

#1925269

RE: Convert number stored as text to number

SELECT
OldPrice

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 26, 2017 at 9:43 am

#1925104

RE: Count Year,Month,Day

Msg 241, Level 16, State 1, Line 44

Conversion failed when converting date and/or time from character string.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 26, 2017 at 7:45 am

#1925061

RE: Count Year,Month,Day

Deny Christian - Thursday, January 19, 2017 12:28 PM
Comments posted to this topic are about the item Count Year,Month,Day

Did you try...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 26, 2017 at 7:36 am

#1925057

RE: Checking for NOT NULL condition

mcfarlandparkway - Tuesday, January 24, 2017 9:34 AM

I have a function where i have to check column not null

if @sen like 'BY%'...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 25, 2017 at 2:00 am

#1924802

Viewing 15 posts - 946 through 960 (of 10,143 total)