Topics
Started by
Posts
Last post
Hello everyone, I am not able to replace the first and last occurance in a string. In my table the …
4 replies
Dear Friends, I would like to know if somebody can help me. I need to generate the number …
7 replies
I have this little query, it is being imported into SQL. My end user would like the 'ecd or emm' fi…
2 replies
Hello. I want to set up an automated email job that will email staff if they meet certain criteria…
2 replies
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
Viewing 15 topics - 5,011 through 5,025 (of 12,234 total)
You must be logged in to create new topics.