Topics
Started by
Posts
Last post
I have the following query and need to add a Primary Key to the Column of Employeenumber: SELECT […
1 replies
Hi I have created the below UDF from SQl CLR database Project from Visiual Studio 2010 and after di…
1 replies
----- Select code, codesubcode from failurecodes where active =1 and productcode in (select distinc…
2 replies
HI I got to execute a stored procedure but i'm getting error here is the stored procedure that i am…
1 replies
I have the following query: SELECT DISTINCT [ScratchPad5].EmployeeNumber, SUM( case when [sumhours…
5 replies
I'm having some troubles getting a query to work appropriately, and was hoping someone could assist…
8 replies
Hi All, Is it possible to create a view from stored procedure , like i need to create a view which …
13 replies
I have the following TSQL script - SELECT dbo.DW_SALESORDERS_F.Reference AS [Soh.Reference] …
3 replies
I need to retrieve the @@RowCount value from within a proc like so: select @RowCount = @@RowCount F…
7 replies
Hi I have an SQL statement using a CASE statement which searches across 14 columns (named 'Diagnos…
5 replies
I am having sql 2000. I have one insert query like below insert into tbl1 select f1,f2 from tbl2 He…
11 replies
Hi there - Getting the following error when I run this code - SELECTTOP 100 PERCENT [PlaceRef]…
1 replies
I am having some trouble with the code below. I have a table variable for invoices, and another fo…
4 replies
I have this stored procedure: SELECT Name,NEWID() FROM Persons WHERE ADUserName = @ADUserName UNIO…
8 replies
Hi There, I am new to sql. I am using SQL server 2000. Here i wanna to import excel data to my data…
1 replies
Viewing 15 topics - 616 through 630 (of 17,082 total)
You must be logged in to create new topics.