Viewing 15 posts - 6,106 through 6,120 (of 14,953 total)
The cases for and against "null" in databases is argued endlessly.
Ask the dev how he/she wants to handle known-unknowns without using nulls. If the answer is something that can...
- 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
November 11, 2010 at 12:19 pm
Craig Farrell (11/11/2010)
GilaMonster (11/11/2010)
http://twitter.com/#!/GFritchey/status/2742141222658049Websense hates me. Have to check that from home.
BWAHAHAHAHAHAHAHA. Dear gods, did I just generate a meme?
Yep, and it looks like you beat 4chan to...
- 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
November 11, 2010 at 12:17 pm
Something like this:
DECLARE @BATCHES TABLE (
BATCH_NUM int NOT NULL,
BATCH_TIME datetime NOT NULL)
INSERT INTO @BATCHES (BATCH_NUM, BATCH_TIME)
SELECT 1, '20101108 08:37:00.000' UNION ALL
SELECT 2, '20101108 09:26:12.000' UNION ALL
SELECT 3, '20101108 12:35:00.000' UNION...
- 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
November 11, 2010 at 11:37 am
Actually, what I wrote is it depends on what you're selecting from.
In order to do a Select Into, SQL has to determine data types, and potentially data sizes, from 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
November 11, 2010 at 11:31 am
Since holidays are subject to change, and in many cases are business-specific, yeah, it'll require human intervention at some level. However, just about every job I've ever had, 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
November 11, 2010 at 11:24 am
In your select query, you have a different Where clause than in the Update query. Make them match and see what you get.
Also, keep in mind that if 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
November 11, 2010 at 11:04 am
Check out the recursive CTE Microsoft has in MSDN. It's for a hierarchy crawl, which is what this is (think of the second batch ID as a child ID)....
- 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
November 11, 2010 at 11:01 am
Craig, you need to include a column name that's an SQL keyword, at the very least.
billyholliday: Ignoring Joe's usual trollishness, and Craig's humor, did my sample hierarchy crawl get 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
November 11, 2010 at 10:58 am
The best way to do this kind of this is a time table and a calendar table.
The calendar table stores days, including which ones are business days. The 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
November 11, 2010 at 10:54 am
Beat me to it! Was about to post almost the same thing.
- 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
November 11, 2010 at 10:51 am
pmscorca (11/11/2010)
I think that create a CLR procedure isn't the easiest solution and requires VSTO programming. I would like using T-SQL language.Thanks
T-SQL doesn't have a file creation command for general...
- 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
November 11, 2010 at 10:42 am
WayneS (11/11/2010)
You could use the sp_OA procedures, with "Scripting.FileSystemObject", to create files.
Part of the reason CLR was added into SQL 2005 is that the sp_OA procedures are a pain to...
- 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
November 11, 2010 at 10:40 am
GilaMonster (11/11/2010)
jcrawf02 (11/11/2010)
Craig Farrell (11/10/2010)
Must be the week...http://www.sqlservercentral.com/Forums/Topic1019000-392-1.aspx
Nice sig 😉 To be perfect, should start with "Yea" instead of "'lo", and have an extra thy in "Thy spool and...
- 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
November 11, 2010 at 9:48 am
It's a multi-step AD authorization error.
When you're running it, are you running it automatically, are you running it manually from a workstation, or are you running it while using remote-desktop...
- 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
November 11, 2010 at 8:05 am
It's saying you already have T: assigned as a drive name, and then failing because of that.
First, I'm not sure if you meant to, but it looks to me like...
- 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
November 11, 2010 at 6:38 am
Viewing 15 posts - 6,106 through 6,120 (of 14,953 total)