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...

Does the shift number need to be stored in the database, or can it just be a number in the report?

You have the identity column defined as a primary key. It can't insert the same value in a primary key column.

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.

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...

bladerunner148 (11/22/2010)

---

Ok, i installed IS with the WorkStations. The package now runs fine from the Integration Services. Before, this was errored out.

Now, when I try to run this package from...

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,...

Yes, you do need to update SQL Server.

The details can be found by searching for "sql server patches" in Bing/Google/whatever.

churlbut (11/22/2010)

---

Here is one way of doing it:

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...

Yes, you'll need to have IS installed and running to run an SSIS package outside of BIDS.

Stefan Krzywicki (11/20/2010)

---

GilaMonster (11/20/2010)

---

Totally lost. No idea what you're talking about.

Aside: This is why, when I took part...

Craig Farrell (11/19/2010)

---

WayneS (11/19/2010)

---

LutzM (11/19/2010)

---

WayneS (11/19/2010)

---

:crazy::crying::Whistling:

Why...

LutzM (11/19/2010)

---

Brings back memories... A huge turkey, so tender I can't forget,...

bladerunner148 (11/21/2010)

---

Hi,

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...

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...