Topics
Started by
Posts
Last post
Looking for a SQL junkie to rewrite the following SQL statement ~ This statement renders the LAST D…
3 replies
i have a cursor with an if/else statement inside it. at the end of each if, or else i have a line: …
1 replies
Hi all, Is there a way to assign a default value to a stored procedure parameter to compensate for …
3 replies
Based on current date, I need SQL to derive: -- the last day of the Last Quarter w/ TIME = 00:00:00…
2 replies
Need to render 2 timestamps: a) 1st day of LAST QTR w/ TIME=00:00:00.000 SQL to get st…
3 replies
Hello, how can I determine the name of the remote application that triggers a transaction? In Profi…
2 replies
IAM UNABLE TO DROP A TABLE IN SQL SERVER 2000. DROP TABLE TABLE1, I WAITED FOR ONE HOUR NO RESPONSE…
1 replies
Can you have a Delete Statement which joins multiple tables and delete records from each of these t…
3 replies
I am getting diffrent results when i run a stored procedure than if i run the same query (which is …
9 replies
I have a problem where i have some digital data with a time value indicating when the digita…
2 replies
Folks, I want to use a View or a Stored Procedure to get a derived table which is generated by us…
3 replies
Is it possible to display a prompt a user for input (set variable) so I can write one sql to do man…
3 replies
Does anyone know how to include carriage returns, line feeds, tabs, etc. in the Find & Rep…
8 replies
I have a table that have date column with some dates such as DateCol StringCol 02/…
4 replies
Hi, I'm trying to write a query to select all user stored procedures in a db (and exclude system st…
3 replies
Viewing 15 topics - 7,531 through 7,545 (of 17,082 total)
You must be logged in to create new topics.