Viewing 15 posts - 46 through 60 (of 96 total)
Jasmine D.
Thanks for the reply. To test the Permission theory, I ran my smaller bulk insert and the bulk insert that is the topic of this post from the same...
July 12, 2012 at 10:33 pm
Jared,
Thank you that worked. I had written a Bulk Import about 2 years ago and I used that as my model. That older import (which still works) only has a...
July 9, 2012 at 1:19 pm
Jared,
Thanks. That enabled me to get to the original error I needed help with. So that I didn't have to create a second post, I added the date field to...
July 9, 2012 at 12:55 pm
Thanks everyone for your assistance. That should do it for me.
pat
July 9, 2012 at 6:53 am
Gullimeel,
I receive an error, "Invalid object name 'a' ".
If the ItemNo is removed from the Group By in dwain.c's solution, the correct order number is returned.
Thanks,
pat
July 9, 2012 at 4:51 am
A slight modification to dwain.c's solution works and seems simple enough.
--Remove ItemNo from the Group By
Select OrdNo
From OrdLine
where ItemNo IN ('A', 'B', 'C')
GROUP BY OrdNo
HAVING COUNT(ItemNo) = 3
Thank...
July 9, 2012 at 4:47 am
Thanks for the input.
Here is the code to create a table and populate it.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[OrdLine](
[OrdNo] [int] NULL,
[ItemNo] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
Add...
July 9, 2012 at 4:43 am
GilaMonster,
Thank you for your reply. There is a surprise at the end of my reply so please bear with me.
I tried several queries. I stated with Select * from Salestax...
June 14, 2012 at 5:10 pm
I believe I have found the answer. When creating a script from within SSMS, the script does not contain the code to start the Snapshot agent. Once I added that...
December 19, 2011 at 3:30 pm
Graeme100,
Yes, I am starting from scratch. I have been doing this publication and subscription from scratch for half a year. Now I want to incorporate it into a script.
This...
December 19, 2011 at 5:32 am
Celko,
Thank you for your comments. I was unfamiliar with ISO-11179 and 8601. I am sure this may seem odd but the table names do follow a standardized naming convention. It...
December 11, 2011 at 5:26 pm
Paul,
Did I do something wrong? If so it was not intentional. I did a Search and found your two articles. I then emailed that link to two of my frineds....
December 10, 2011 at 11:01 am
That worked perfectly. "Cross Apply", I had never encountered this before. I will go and read up on it.
Thank you so much,
pat
December 9, 2011 at 2:04 pm
Thanks for the advice. I was just looking to see how long the query would take. I didn't really stop to think about the consequences of using a client display...
October 31, 2011 at 8:46 am
First, thank you for following me over here. I do appreciate the replies.
Good to hear that it is a .Net error. I thought it might have something to do with...
October 30, 2011 at 4:33 pm
Viewing 15 posts - 46 through 60 (of 96 total)