Topics
Started by
Posts
Last post
I'm migrating a data report from a legacy system to SQL Server/Crystal Rpts. The report is grouped…
3 replies
Is it necessary to master t-sql fro 70029 exam ? If yes which is best book for T-Sql self study ? C…
6 replies
I have a TSQL Problem. I can not seem to reuse a temp table name. We are trying the below code, a…
5 replies
I have two triggers on a table, one for ON INSERT and one for ON UPDATE. The two triggers are desig…
10 replies
Generally speaking, if you have a query with several views joined (also with several tables), do th…
4 replies
We have a field with a compound value which is used to join to another table in the following way: …
5 replies
The identity column provides the value as integers. We need to generate id similar to 'AAA0001' whe…
3 replies
Hello.. I was trying to write a stored procedure that could execute another row-returning stored p…
2 replies
I’m using Microsoft SQL Server 2000 - 8.00.534 (Build 2195: Service Pack 2). In Northwind databas…
2 replies
What is the optimum number of columns that can be grouped by in SQL Server 2000 ?
7 replies
Is it possible to trap an error that occurs when a statement is executed dynamically i.e set @dbexi…
3 replies
How would I get the earliest date for each Case_Number with the following query? SELECT Case_Table.…
4 replies
Can any one please point me in the right direction. I need some T-Sql that will tell me if a given…
3 replies
I am trying to get a string literal of comma seperated values to be parsed as a list of values by t…
9 replies
Can't quite get the correct syntax for this query below. Any help would be appreciated. declare @…
3 replies
Viewing 15 topics - 16,036 through 16,050 (of 17,082 total)
You must be logged in to create new topics.