Viewing 15 posts - 76 through 90 (of 129 total)
Kind of but not completely...If I run that SELECT statement as is, there is 4458 records...
But when I ran it with the UPDATE statement - it only changed 3906 records...So...
August 26, 2011 at 1:11 pm
No I dont have a WHERE clause in my SELECT query...I want to update table A...This query returns a result set and want to update those columns that this query...
August 26, 2011 at 12:49 pm
I apologize Im not understanding the where clause...what is the condition clause = condition to be met...all i have is a SELECT query
August 26, 2011 at 10:12 am
Ok let me try to explain this better...
I have written a query and it returns me a result set of 4000+ records...I want to flag those records...How can I update...
August 26, 2011 at 9:45 am
Yes i installed under my local default instance...I looked in the Configuration Manager for SSMS and Reporting Services is running...
I just cant connect to it through SSMS...
August 23, 2011 at 2:45 pm
No it says Internet Explorer cannot display the webpage...
Its crazy b/c when I go thru the configuration, it connects to it fine...but when I try connecting in SSMS, I type...
August 23, 2011 at 12:29 pm
I had not went through the configuration services...But I just did and it says Reporting Service started, but still cant connect to the instance...
August 23, 2011 at 12:04 pm
Thank you so much Lowell...
That did it for me! Just for giggles: Can you explain that Row Number function and OVER PARTITION BY clause as it relates to these queries?...
June 27, 2011 at 1:24 pm
There are no records in the other table yet...Here is the breakdown of what I am trying to do:
3 Tables:
Primary Table: all records - no constraints
Good Table : currently no...
June 27, 2011 at 10:56 am
Oh trust me...That was my first thought when Transactional Replication didnt work...I asked if we could modify the tables and just insert a TableID as indentity, but we cant modify...
June 21, 2011 at 3:00 pm
Yep that is what the problem was...
Thanks to all for the responses!
June 16, 2011 at 9:11 am
yeah i would like to test that but that server that needs it is a production server and all our other boxes have been upgraded!
June 16, 2011 at 7:39 am
I got ya...I thought you were referring to the server that I was going to set up as a subscription...Ok the information from the server that I successfully set up...
June 16, 2011 at 7:27 am
I was just setting up a publication and received that error so I wasnt connecting to another server...I point it to the other server when I set up the subscription...
June 16, 2011 at 7:12 am
Viewing 15 posts - 76 through 90 (of 129 total)