Viewing 15 posts - 14,791 through 14,805 (of 14,953 total)
It means one (or more) of the rows of data you are converting to datetime from char isn't acceptable to the database.
Try selecting the columns referenced in those lines of...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 24, 2008 at 1:42 pm
I've never had to change a business process to match the system. I've had business processes that I couldn't enforce with the system, because they weren't things a computer...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 24, 2008 at 12:32 pm
It means you have some strings that aren't strictly numeric in the select.
If you run:
select dsp_sth_ds
from (whatever table that field is in)
where isnumeric(dsp_sth_ds) = 0
You'll find out which rows are...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 24, 2008 at 12:22 pm
If you add the reps as another column, you should be able to use Reporting Services to pivot it the way you want using cross-tab reports. If not, put...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 24, 2008 at 12:18 pm
It looks like it should work, but the only way to be sure is to test it. If you can't, you're just guessing. Always test. Work out...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 24, 2008 at 8:37 am
If I've specialized in anything, it's in learning new things.
I've not done IT work for large multinationals, so I have no idea how specialized things are there. My work...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 24, 2008 at 8:34 am
If you want a clean database (no data in any tables), use "Generate Scripts" in Management Studio (Query Analyzer for SQL 2000).
Right click the database -> Tasks -> Generate Scripts
Select...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 23, 2008 at 8:01 am
Decided to also try:
select number
from common.dbo.numbers
left outer join dbo.serialnumbers
on number = id
where number >=
(select min(id)
from dbo.serialnumbers)
and number <=
(select max(id)
from dbo.serialnumbers)
and id is null
Because that way I'm not assuming I already...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 23, 2008 at 7:55 am
create table dbo.SerialNumbers (ID int primary key)
go
insert into dbo.serialnumbers
select number
from common.dbo.numbers
where number between 1 and 100
go
delete from dbo.serialnumbers
where id in (55, 56, 71, 80, 99)
Opened a separate connection.
set statistics time...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 23, 2008 at 7:45 am
SELECT DISTINCT cdds_Metadata.DatasetId AS ID,
cdds_Metadata.DataCurrencyDate AS CurrencyDate,
cdds_Metadata.DataFormatType AS DataFormat, ...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 23, 2008 at 7:15 am
Personally, I prefer using a single coalesce statement to produce a delimited list:
declare @List varchar(max)
select @list = coalesce(@list ',' + nullif(col1, ''), nullif(col1, ''), @list, '')
from dbo.Table
This will deal with...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 22, 2008 at 3:40 pm
On that final join, when you say there's no relation between them, do you mean you want a "cross join", where you get all rows in those final two tables...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 22, 2008 at 2:34 pm
I'm not familiar with Oracle, so not sure what "spool" does. From what you are describing, the BCP command-prompt utility is what you're looking for.
From a command prompt, you...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 22, 2008 at 2:25 pm
Unfortunately, I'm not familiar with that reporting application. Can't help you on that one.
You're probably stuck with one of the Union queries outlined earlier in this discussion.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 22, 2008 at 2:18 pm
Personally, I found "SQL Server 2005 Bible", by Paul Nielsen (www.isnotnull.com), very easy to read and incredibly helpful in learning SQL.
I found the related "... for Dummies" books to be...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 22, 2008 at 2:14 pm
Viewing 15 posts - 14,791 through 14,805 (of 14,953 total)