Viewing 15 posts - 7,246 through 7,260 (of 14,953 total)
Ray K (1/8/2010)
ddlawal (1/8/2010)
I need a mentor too.......any takers?Just keep posting to these forums. You'll find plenty of 'em! 🙂
Have to agree with that one.
Can't hurt to find 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 8, 2010 at 7:50 am
I would probably encrypt and decrypt in the application, before it ever gets sent to the database. That way, it's not even plain-text on the network between the two....
- 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 8, 2010 at 7:43 am
Yes, I left out 0. Otherwise, I would use Like for the test.
Here's how I'd be likely to write something like this:
if object_id(N'tempdb..#T') is not null
drop table #T;
create table...
- 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 8, 2010 at 7:39 am
jcdyntek (1/7/2010)
Why in the world would we be referencing a standard from 89?
You write from left to write, right? Any idea how old that standard is?
- 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 8, 2010 at 7:24 am
As expected, this has turned into Boot Hill as far as postings from the OP go.
- 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 8, 2010 at 7:22 am
Lynn Pettis (1/8/2010)
Alvin Ramard (1/8/2010)
Hey Lynn, did you get that hippopotamus for Christmas?😀
Thankfully, NO! I (actually the family) did get a few good (IMHO) movies: Star Trek, GI Joe,...
- 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 8, 2010 at 7:20 am
You could convert using style 10, then wrap that in a replace that gets rid of the punctuation.
- 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 7, 2010 at 11:09 am
You could do this:
select
workstation,
date_entered
from
inventory
where
part_number = 'ABC'
and workstation >= 5
union all
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 7, 2010 at 11:07 am
Krasavita (1/7/2010)
How many db can we have per server and how much memory in total can I have?Thank you
Servers usually aren't all that loud, but the limit would really 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 7, 2010 at 11:04 am
Try a few of these to find the limits of IsNumeric:
select IsNumeric('1d10');
select IsNumeric('1e10');
select IsNumeric('0xF');
select IsNumeric('10');
select IsNumeric('Hello');
The only ones that are not "numeric" are the hex number and "Hello". The...
- 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 7, 2010 at 11:02 am
I just tested it to be sure. *= is left, =* is right.
I created a compat-80 database, and tested this:
create table dbo.L (
LNum int primary key);
go
create table dbo.R (
RNum...
- 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 7, 2010 at 10:56 am
Lynn Pettis (1/6/2010)
GilaMonster (1/6/2010)
I know what you mean, I though Lynn was female for a very long time. (just based on the name, Lynn, please don't read anything into that)
Not...
- 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 6, 2010 at 12:38 pm
support 79032 (1/6/2010)
Nowever only a complete xenophobe (named after Queen Xeno a notorious bigot) could wish to drag nationality into an unrelated discourse.
Whoah! "Queen Xeno"??? Where did 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 6, 2010 at 11:41 am
Create either a permanent or inline calendar table and join to that.
Here's an example using a Numbers table to generate an inline calendar. I've got an add that ran...
- 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 6, 2010 at 7:33 am
lmu92 (1/6/2010)
SELECT
c.value('column1[1]','varchar(30)') as c1,
c.value('column2[1]','varchar(30)') as c2,
c.value('column1500[1]','varchar(30)') as c1500
FROM @xml.nodes('NewDataSet') a(b)
CROSS apply...
- 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 6, 2010 at 7:27 am
Viewing 15 posts - 7,246 through 7,260 (of 14,953 total)