Viewing 15 posts - 9,406 through 9,420 (of 15,381 total)
Whisper9999 (2/4/2013)
"There is a schema that has the samename as the user you are deleting. Do...
February 4, 2013 at 12:08 pm
greg.bull (2/4/2013)
I am trying to avoid using cursors, and thinking about how to do something column-based. I could do with a few clues on the techniques side.Regards, Greg.
Not to diminish...
February 4, 2013 at 10:29 am
zoom19 (2/4/2013)
I come out with something using cursor but still I am not satisfied with result.Below is my code..
That looks like it will work but I am guessing you are...
February 4, 2013 at 9:16 am
I am having a hard time understanding what you are trying to do here. If you can post what the input looks like and the output should look like I...
February 4, 2013 at 9:09 am
BrottJ (2/4/2013)
OK - thanks for the reply. It was worth a shot for me since I know very little about SQL. 🙂
No problem. Hope you get if figured out. :hehe:
February 4, 2013 at 9:06 am
@steve-2 - thanks for replying. But your query gives me a different result. Your query gives me the number of TIMES custA's status was changed (Ex: custA status1, numdays =...
February 4, 2013 at 8:56 am
BrottJ (2/4/2013)
The reason I think the issue is SQL related is that it shows up on all computers using MP2 and reinstalling the...
February 4, 2013 at 8:52 am
kapil_kk (2/1/2013)
Hi, I have a script from which I have to remove the cursor:
I agree you should get rid of that cursor.
You have been around here long enough to know...
February 4, 2013 at 8:13 am
Hi and welcome to SSC. What you are describing is a running total. Here is an article that explains one way of doing this.
http://www.sqlservercentral.com/articles/68467/%5B/url%5D
If you find that you need more...
February 4, 2013 at 8:06 am
Use an OR condition in your join statement?
February 4, 2013 at 8:03 am
david.alcock (2/4/2013)
Reason I ask is that...
February 4, 2013 at 7:57 am
BrottJ (2/4/2013)
February 4, 2013 at 7:55 am
Why use cascading updates to keep denormalized data in synch? Just normalize it and you don't have to worry about it. Keep the data in one and only one table.
As...
February 4, 2013 at 7:51 am
Also I would avoid using uniqueid's as your primary key unless there is a good reason. It is very wide for a key and they are a PITA to work...
February 1, 2013 at 3:09 pm
You have a lot of denormalized structures here.
Consider these two tables.
create table Division
(
CompanyID int not null,
DivisionName varchar(50) not null,
constraint pk_Division primary...
February 1, 2013 at 3:02 pm
Viewing 15 posts - 9,406 through 9,420 (of 15,381 total)