Viewing 15 posts - 1,741 through 1,755 (of 2,894 total)
this should be reset for each district and incremented at each new dq_rec_start_cycle_ind
If I understand you correctly, you want something like:
district | dq_rec_start_cycle_ind | cycle_count
1 ...
April 17, 2012 at 8:10 am
...I was making the assumation (bad thing to do at times) that the OP was talking about joining tables together on multiple columns...
You never know for sure :hehe:
April 17, 2012 at 7:51 am
RAISERROR ('My debugging text', 10,1) WITH NOWAIT
Will return message back to caller immediately. Using ADO.Net SqlInfoMessage you can subscribe to it and get it back during stored proc asynchronous...
April 17, 2012 at 7:34 am
Cannot see your attachment and your question is not very clear. However, I guess, what you need is:
ROW_NUMBER() OVER (PARTITION BY [ditsrict column name] ORDER BY [whatever column you want...
April 17, 2012 at 7:08 am
What do you mean "full permission"?
You can remove permission from role using REVOKE
April 17, 2012 at 7:03 am
Placed your code into my query window and executed it.
No problems at all! All five records inserted with Location set to USA a per default.
Are you sure you are getting...
April 17, 2012 at 4:30 am
CELKO (4/16/2012)
April 17, 2012 at 4:26 am
For the purpose you need, the best way is to use RAISERROR like that:
RAISERROR ('My debugging text', 10,1) WITH NOWAIT
It's the same as PRINT, but it guaranteed to be returned...
April 17, 2012 at 4:19 am
l090475 (4/16/2012)
Can you join a table to multiple columns?
The correct answer to this question is: NO! You cannot join table to multiple columns!
More than that, you cannot joint table...
April 17, 2012 at 4:14 am
If you have default constraint on the column and do not specify this column in the column list of insert statements it should work.
Could you please post full ddl of...
April 17, 2012 at 4:08 am
I'm glad it did help you.
But it worth to mention that I would just use normal cursor and dynamic sql. That is exactly the case where using cursor is...
April 17, 2012 at 4:02 am
...
Note that using Dynamic SQL is an expensive SQL operation.
...
What do you mean by "expensive"? It's as affordable as anything else.
Just use it properly with sp_executesql and parameters...
April 17, 2012 at 3:53 am
Good for you! It is easy now. Here is an answer:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 16, 2012 at 9:53 am
sqlbi.vvamsi (4/16/2012)
I've a table with a numeric and date columns. Assuming a,b are the column names, I'm writing a query which isn't returning any rows. Below is the query
select *...
April 16, 2012 at 9:50 am
Another way, using sp_msforeachtable:
create table dbo.OutputTable (OriginTableName nvarchar(500), RecordCount INT)
create table dbo.TableList (Name nvarchar (500))
insert dbo.TableList
select '[dbo].[swap]'
union select '[dbo].[products]'
union...
April 16, 2012 at 9:14 am
Viewing 15 posts - 1,741 through 1,755 (of 2,894 total)