Topics
Started by
Posts
Last post
SET NOCOUNT ON DECLARE @MyTable TABLE ( Code …
6 replies
Hello All, I know this is simple but for some reason I cant get it to work. Here is my SQL: select&…
2 replies
I have this result from a SQL command year Mb Ca Si Ca Cu Nq Tg ----------------…
10 replies
I am trying to sum an amount field, but when I try to enter the sum function, sql wants me to group…
3 replies
Hello, Given a start date and end date, is it possible to construct a select statement whose result…
5 replies
Hi I have table1 with a column "id" and table2 with a column "id". The id column is supposed …
13 replies
I'm trying to write a bit of TSQL into a job that will return the job step name (or ID) so I can pi…
1 replies
Hello, I have been trying to find a way to search for a certain string within all stored procedur…
5 replies
Hi all, Stupid question: I want to select data from another SQL Server (for now, I'll be happy to d…
6 replies
When a stored procedure is created, the SET QUOTED_IDENTIFIER and SET ANSI_NULLS settings are captu…
5 replies
Hello all, I need to create a view of two tables, a case table and an owner audit trail updated whe…
3 replies
I am trying to sort numerically on an alphanumeric column in a table. The SQL I have used works wel…
4 replies
OK, I've got a stored procedure with a query like this: select column1 from table where column2 in …
11 replies
Hi, Can someone help with the following problem please (SQL Server 2000) I have two tables tblStude…
2 replies
I have a table as such: EmpID WeekID Result 1 …
3 replies
Viewing 15 topics - 9,691 through 9,705 (of 17,081 total)
You must be logged in to create new topics.