Viewing 15 posts - 14,521 through 14,535 (of 15,381 total)
Without something that makes easy for me or others to readily start working on a solution you are not likely going to find much help. I was asking for a...
June 15, 2011 at 2:00 pm
Remember we can't see over your shoulder and have no intimate knowledge of your project. Please help us help you by providing ddl, sample data (insert statements), desired output (based...
June 15, 2011 at 1:32 pm
Not sure what you mean by not working but I suspect it is not producing the desired results? The replace statement is probably not doing what you think/expect.
Select Col1, Replace(Col2,'...
June 15, 2011 at 11:12 am
Yes following the lines of your previous discussion it is preferable to have each module of code do one and only one thing. If you have combined them you have...
June 15, 2011 at 11:08 am
Hi and welcome to SSC. It is pretty hard to provide anything resembling a real answer to your question based on what you have posted. Take a look at the...
June 15, 2011 at 10:43 am
I agree the problem is in the cursor...in fact i would suggest that the problem is using a cursor in the first place. If you can post some sample data...
June 15, 2011 at 8:43 am
I would be willing to bet that you don't need a **cough**cursor**cursor** to do an update. You will benefit in huge performance gains by converting to a set based solution....
June 14, 2011 at 1:53 pm
select column1 + column2 from table
June 14, 2011 at 1:42 pm
Hi and welcome to SSC!. Reports can frequently be some of the most complicated queries. Sounds like you are new to sql? I don't know that diving straight into SSRS...
June 14, 2011 at 12:16 pm
Rich Yarger (6/14/2011)
June 14, 2011 at 10:30 am
nullif([your column here], '''')
June 14, 2011 at 10:11 am
bopeavy (6/14/2011)
vmssanthosh
our manager is giving a new idea of having only one procedure for insert update and deleting all the master tables.
he wants to specify the table name and the...
June 14, 2011 at 10:02 am
Lowell (6/14/2011)
One Procedure To Rule Them All? Lord Of The Rings Style?
+1000
June 14, 2011 at 10:01 am
Like I said you already posted this question and you got an answer. In fact, I gave you pretty much the same answer.
June 14, 2011 at 8:29 am
Viewing 15 posts - 14,521 through 14,535 (of 15,381 total)