Forum Replies Created
Viewing 15 posts - 781 through 795 (of 59,078 total)
-
Reply To: cursor not getting next values
LJMoss wrote:There are legitimate reasons to use a cursor..
Just an opinion here...
While I agree with the statement quoted above (because "It Depends" is always a consideration), I've found that a...
-
Reply To: Adding an AI Policy for Authors
Heh... speaking of AI...
Could you use the AI to suggest to you good folks how to fix all the problems with the forum software and the article submission software?
Those two...
-
Reply To: Replace double quotes in derieved column SSIS
lokesh.hyperion@gmail.com wrote:No, it did not work and that was the reason I took time to post it here. I have tried many options including substring.
Yeah... sorry... admittedly, I only took...
-
Reply To: How fast can SQL Server Insert data into table - 40 Million plus
Just to encourage you, I have a table of the following "specs"...
52.1 GB
100 Million Rows
529 Bytes Average Row Size
With the Clustered Index in place, it only took 1 minute and...
-
Reply To: How to substract value from its own column in same tabl through condition basis
manojsemwal1 40990 wrote:table data is like this and out put of the data is mentioned in earlier post
You didn't read the article at the...
-
Reply To: Teams meeting Required to explain a list that has a table embedded in it.
robertukoli22 wrote:Sorry this is an SSRS Reporting services problem
IIRC, you can edit the title of your own original post.
And, are you seriously stuck with SSRS 2008?
-
Reply To: How to substract value from its own column in same tabl through condition basis
Phil Parkin wrote:Once again, if you want coding assistance, please provide consumable sample data for us to experiment with.
In other words, do like I previously suggested... read'n'heed the article at the...
-
Reply To: Replace double quotes in derieved column SSIS
If you're using >= 2017, the TRIM function in T-SQL will handle the removal of double quotes and spaces and whatever other leading/trailing characters you may have to work with. ...
-
Reply To: SQL Query requirements
jcelko212 32090 wrote:You're still writing SQL as if you were in BASIC or Fortran. Let's start off with the create table statement. By definition, and not as an option, table must...
-
Reply To: How to substract value from its own column in same tabl through condition basis
Sorry... originally missed the meaning here and took the post down and replacing it with the following...
Just use a WHERE NOT IN. If something more sophisticated is desired, we'd need...
-
Reply To: Mind Over Milkshake (Thoughts Matter)
Rod at work wrote:Resistance to any change in systems, until they break beyond repair, is a bad practice.
I strongly disagree... especially when someone claims that such a thing is a "practice", either...
-
Reply To: Mind Over Milkshake (Thoughts Matter)
Heh... it's funny... I see so many people saying that people who are resistant to change are stuck in a rut. I guess it's never dawned on those people that...
-
Reply To: Size of DB Log File
The problem is very likely that you're simply not doing any log file backups. Full backups do nothing to clear the log file.
If you want to be able to do...
Viewing 15 posts - 781 through 795 (of 59,078 total)