Viewing 15 posts - 14,176 through 14,190 (of 15,381 total)
Ninja's_RGR'us (8/25/2011)
SQLRNNR (8/25/2011)
GilaMonster (8/25/2011)
SQLRNNR (8/25/2011)
Grant Fritchey (8/25/2011)
... and Sharepoint and the business, and some PowerShell, and search engines, and a little NoSQL and...
Really, this is a public forum... We...
August 25, 2011 at 10:07 am
Ninja's_RGR'us (8/25/2011)
Sean Lange (8/25/2011)
Ninja's_RGR'us (8/25/2011)
GilaMonster (8/25/2011)
SQLRNNR (8/25/2011)
Grant Fritchey (8/25/2011)
... and Sharepoint and the business, and some PowerShell, and search engines, and a little NoSQL and...
Really, this is a public forum......
August 25, 2011 at 10:05 am
Ninja's_RGR'us (8/25/2011)
GilaMonster (8/25/2011)
SQLRNNR (8/25/2011)
Grant Fritchey (8/25/2011)
... and Sharepoint and the business, and some PowerShell, and search engines, and a little NoSQL and...
Really, this is a public forum... We should...
August 25, 2011 at 9:54 am
Saga... (8/25/2011)
I am a DBA but i never do the hardware stuff. Just wanna say that....IT world changes in short span of time....Everyone needs to be updated.... 😎
Maybe you...
August 25, 2011 at 9:05 am
Sounds like you are on the right path for your needs then. I just pointed it out to make sure it was something you had considered. The catch all audit...
August 25, 2011 at 8:33 am
Wouldn't this be a lot easier if you used a single file?
These are the directions I have given :
To run file 0 just hit Execute
To run file 1 you...
August 25, 2011 at 8:18 am
I think the OP is asking how does SSMS handle the data before it displays the results in the output window? In this case SSMS IS the client so it...
August 25, 2011 at 8:04 am
That error should be pretty clear. You can't use a constant as the order by column in a windowed function. You will have to choose a column to sort by....
August 25, 2011 at 8:00 am
Variable declaration was on the wrong side of the top.
SELECT TOP 1 @MaxIDVal = (AcctID) FROM dbo.tableA ORDER BY AcctID DESC
August 25, 2011 at 7:51 am
The one thing you seriously need to consider is how you are going to pull data to give a snapshot view at a point in time. Take a given record...
August 25, 2011 at 7:33 am
Certainly do NOT use a cursor!!!!!!!!!! I assume you want to insert these new records with a number larger than TableA has? Just use an identity column and seed it...
August 24, 2011 at 2:55 pm
David, depending on the number of tables you may find that just coding them is easier. The amount of effort to create this type of stored proc is pretty large....
August 24, 2011 at 8:07 am
There is very little information in your post so I am speculating but that sounds like a permissions issue. Check your connection string and make sure the user has access...
August 24, 2011 at 7:46 am
Yeah that looks like a close enough skeleton that would work. However, I would suggest putting the presentation on the front end. Otherwise you will have to look at each...
August 23, 2011 at 2:04 pm
I think your audit table approach will be easier to code and maintain and it will be light years faster to produce the history. Breaking it apart column by column...
August 23, 2011 at 1:40 pm
Viewing 15 posts - 14,176 through 14,190 (of 15,381 total)