Topics
Started by
Posts
Last post
hi i wrote an store procedure: ALTER PROCEDURE [dbo].[DownloadCount_SP] @FileCodesql int AS BEGIN…
3 replies
Does anyone know if you can put a 'Declare' statement in a view statement? Yes I have tried. It (th…
12 replies
I need to combine two result sets, putting two separate values together. Here is what I have so far…
2 replies
Hi, Please could someone help me with this query? I don't have any test data at present. Basically …
9 replies
Is there a proper method for identifying user vs system databases? I've looked in sysdatases as wel…
4 replies
I'd like return a constant value from storedProc/function which type is TinyInt How can I specify i…
2 replies
Scripting help - Need a query to find filenames and filepaths under a certain directory. I need the…
7 replies
Hi All, I am trying these queries - SELECT TOP 10 * FROM Table1 select top 10 * from Table1 WITH (N…
18 replies
Hi All, I have a table that stores staff transfer details. Data as follows. TransferIDRefIDSalesC…
4 replies
Hi all DECLARE @search VARCHAR(50) SET @search = 'Alexan' IF (ISNUMERIC(@SEARCH) = 0) BEGIN SELEC…
2 replies
I have a table and that is having some three column and some 3 rows. So if we query on select colum…
3 replies
Guys: This looks pretty simple. but am unable to find the code. I have access to one proc (say p1).…
8 replies
Hi, I have written a query to get the Max Date for each row. Now I need to find the second to max d…
6 replies
Hey Guys I'm getting a msg:Incorrect syntax near '('. on the following code Set @P_Amt (Select Sum(…
2 replies
Gurus, If I use the following command, Does it rebuild all cluster and non cluster indexes on the t…
1 replies
Viewing 15 topics - 5,011 through 5,025 (of 12,230 total)
You must be logged in to create new topics.