Viewing 15 posts - 5,941 through 5,955 (of 14,953 total)
Right. Reporting services can do line-numbering for you, if I'm not mistaken, or the query can use the Row_Number() function, or you can modify the insert statements for how...
- 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 22, 2010 at 12:03 pm
Does the shift number need to be stored in the database, or can it just be a number in the report?
- 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 22, 2010 at 11:48 am
You have the identity column defined as a primary key. It can't insert the same value in a primary key column.
- 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 22, 2010 at 11:46 am
Are you inserting the sign-ins through a stored procedure? If so, can you copy that onto this forum? If so, we can probably help you more effectively.
- 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 22, 2010 at 11:44 am
The new version of SQL Server (called "Denali" for now), just went into beta as a CTP. Search for "sql server denali" in Bing or Google and you'll find...
- 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 22, 2010 at 11:25 am
bladerunner148 (11/22/2010)
Now, when I try to run this package from...
- 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 22, 2010 at 11:23 am
Generally, applications for this kind of thing use dynamic SQL of one sort or another. Because of this, it's relatively easy to store the Where clauses of the searches,...
- 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 22, 2010 at 11:09 am
Yes, you do need to update SQL Server.
The details can be found by searching for "sql server patches" in Bing/Google/whatever.
- 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 22, 2010 at 11:07 am
churlbut (11/22/2010)
DROP TABLE #Temp
DECLARE @X int
SET @X = 1
CREATE TABLE #Temp (Phone varchar(17) null)
WHILE @X < 101
BEGIN
INSERT INTO #Temp(Phone) select Phone from People where...
- 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 22, 2010 at 10:56 am
Yes, you'll need to have IS installed and running to run an SSIS package outside of BIDS.
- 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 22, 2010 at 8:31 am
Stefan Krzywicki (11/20/2010)
GilaMonster (11/20/2010)
Craig Farrell (11/19/2010)
And, well, I wasn't sure if Gail was familiar with them
Totally lost. No idea what you're talking about.
Aside: This is why, when I took part...
- 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 22, 2010 at 6:32 am
Craig Farrell (11/19/2010)
WayneS (11/19/2010)
LutzM (11/19/2010)
WayneS (11/19/2010)
Craig Farrell (11/19/2010)
Wayne, Lutz and I are volunteering you for Larry. Well, I am, Lutz isn't convinced your current avatar is less appropriate. 😀
:crazy::crying::Whistling:
Why...
- 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 22, 2010 at 6:30 am
LutzM (11/19/2010)
Alvin Ramard (11/19/2010)
...It's a 3 day work week for many of us in the US. Thanksgiving is on Thursday.
Brings back memories... A huge turkey, so tender I can't forget,...
- 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 22, 2010 at 6:28 am
bladerunner148 (11/21/2010)
I did find one thing when i ran the package from the integration services. Here, I can see the detailed error message..should have done this earlier.
Error: The product level...
- 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 22, 2010 at 6:17 am
You can probably use a Dev license key, but I don't know that for certain.
Otherwise, un- and re-install. Shouldn't take all that long unless you've set up a really...
- 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 19, 2010 at 1:19 pm
Viewing 15 posts - 5,941 through 5,955 (of 14,953 total)