Topics
Started by
Posts
Last post
Hi there, Is there any equivalent function for this in SQL 2005 SQL? I need to DENSE_RANK() a colum…
1 replies
How do we get value in 1x1 table returning from a Stroed Procedure in side a StoredProcedure with…
10 replies
Hi all, I have written a query to export some data in a specific format and that works but I want t…
22 replies
We'd like to add monitoring of stored procedures to audit/log the following: - Stored procedure nam…
9 replies
Is there any way to determine if a stored procedure was passed a parameter if the value matches the…
18 replies
this sql giving sql syntex error ............ Restore database Crew from disk = 'C:\SQL2005Backups…
5 replies
I'm doing a application integrated with other apps, at one point I could only invoke the stored pro…
5 replies
I have a table variable that I want to reuse like a temp table. How do I clear out the data and re…
4 replies
Hello everyone, I would like to get the column names from a table on a linked server. My query is s…
5 replies
I have a table with column that has codes in a consolidtaed form as follows create table Code( id …
7 replies
Hi, thanks for reading this. I've got a nested SP that goes like this: ALTER proc lmc_sp_rs_SuperSP…
2 replies
i need to insert into a table that has this scenario: insert into table1 (col1, col2, col3, col4) s…
5 replies
I am tryingto automate re indexing based on the fragmentation. some thing like this. IF @frag &…
3 replies
Hi Everyone, Like previous question, if I have a column and that column contains dates only. If I w…
1 replies
Hi All: I have a intesting question. I have a table that I need to run some reports from, but the …
30 replies
Viewing 15 topics - 8,161 through 8,175 (of 12,234 total)
You must be logged in to create new topics.