Viewing 15 posts - 211 through 225 (of 291 total)
Just thought I would check, you do know that only one table can have the IDENTITY_INSERT option set to ON during any given users session don't you?
Also if you disconnect...
May 18, 2007 at 11:55 am
Oops! I made the same mistake as Jeff in his post. I got distracted by trying to find how to identify the identity columns and did not follow through on...
May 18, 2007 at 11:28 am
I thought this an interesting enough problem that I went and searched for an answer and found a post by Jeff Moden at http://p2p.wrox.com/topic.asp?TOPIC_ID=52760 that accomplishes what you want:
SELECT so.Name...
May 18, 2007 at 11:24 am
Ok, I have got to know, why would you want to, or need to? Just curious what circumstances would prompt this necessity.
James.
May 18, 2007 at 11:11 am
I've looked through your previous posts and your questions are all over the place, but some appear to be more than typical homework and could be problems encountered at work,...
May 18, 2007 at 11:07 am
--Assuming you have "inventory tables similiar to the following:
--(you should post DDL for all tables involved when looking for this type of help)
declare @invItems_ table (itemNo_ int, itemName_ varchar(20))
declare...
May 18, 2007 at 9:57 am
Here is a quick example that I have tested using a "datename" table. You would of course want to add keys, indexes, etc to the table, but, well you get...
May 18, 2007 at 8:30 am
The easiest way is with "datepart" and a case statement, as in the following:
select
(case datepart(dw
May 18, 2007 at 7:49 am
I just saw your followup post. As far as I know the "Select * into ..." has always copied the definition of the original columns to the new table. If...
May 18, 2007 at 7:15 am
Anders is correct, one of the columns in the original table your did the "select * into .." from had an identity column. The properties of that column were transfered...
May 18, 2007 at 7:09 am
Thanks for the feedback Jeff. I enjoy working out some of the T-SQL problems posted in the forum. In addition to keeping in practice, I also get to see alternative...
May 18, 2007 at 6:48 am
You have to understand what actually occurs when doing this type of update. You original update used a "from" line with an inner join. This results in a "JOINED" (composit)...
May 18, 2007 at 6:43 am
Did you open the permissions on the output file location? Just trying to eliminate the obvious first.
James.
May 18, 2007 at 6:00 am
If table A has a 1 to many relationship with table b, then your first query is actually updating each row in table A that has multiple relationships in table...
May 17, 2007 at 2:26 pm
Does AppointmentDate contain time information, or is the time portion all "zeros"? If it has time values then your query will never return anything. See the "second" select statement in...
May 17, 2007 at 9:34 am
Viewing 15 posts - 211 through 225 (of 291 total)