Topics
Started by
Posts
Last post
hi, i have a stored procedure: create proc pBaseValues @kennung int as if @kennung = 1 select …
3 replies
Hi, I have tableA that has a primary column named "EmployeeID". Then there are 10 other tables th…
5 replies
The syntax is sp_recompile @objname = 'objname' The object name can be the name of a stored procedu…
6 replies
i want to pass to_date and from_date to a SP and wanted to get the latest modified SP's,Views and F…
2 replies
My dear Friends! I have got a task, I want to manage the tables in database when user are u…
1 replies
Hi All I have 2 tables that have, the structure is as given below, i need to change a vi…
5 replies
Hi All, I have a table that has more than 3 Million rows. I preferably do not want to do a RBAR 😀 L…
14 replies
I have a recursive query that gives me the management hierarchy, but now I need to retrieve the $ a…
4 replies
I have minutes coming in as varchar. I can change that to int or float if that is necessary How to …
4 replies
We have about 4,000 tables that need to be dropped if the record count is 0. I have come up with s…
3 replies
1 replies
Hi, I am trying to call a user defined stored procedure from within a function I have created. …
6 replies
Ummm, ok, stupid question or stupid person ?? Why is the following not working? Or why is the pos…
6 replies
Hi, I can only get this done with a cursor.... can anyone help to get it done without a cursor? I h…
5 replies
I have following table if object_id('tempdb..#TEST') is not null drop table #TEST; CREATE …
2 replies
Viewing 15 topics - 7,321 through 7,335 (of 12,234 total)
You must be logged in to create new topics.