Topics
Started by
Posts
Last post
Hi, I Have Table called Numbers which Contains Columns Num1 and Num2 of same data type. I want a Si…
5 replies
Any ideas how can I pass date range values from the where clause of an outer query to the inner cor…
12 replies
Hi All, can ant body guide me in the right direction, I have over 400 SP in my database and I have …
4 replies
Hopefully this is a very easy question. I have a table: PersonID int, GroupID int, TestFlag bit &nb…
4 replies
I am doinga select from tablea joining onto tableB. Alll data is retrieved correctly is it po…
6 replies
I would like to concantenate a column of type text with another column of type varchar. When I try …
3 replies
use Northwind declare @check varchar(50) set @check = '''FISSA'',''FOLIG''' print @check select * f…
5 replies
Hi, anyone knows how to create a script to get the column/s that have timestamp. ThanK…
4 replies
Hi, I found this script to display all tables and row count for each, but it only returns tables ow…
5 replies
I see that having a convert in a where clause has some impact on performance when using on VLDBs. I…
1 replies
I have a table with following data col name refNo refNo --- ABC-0 ABC-1 XYZ-0 XYZ-1 XYZ-2 PQR-0 MNO…
27 replies
Hi I need to write a store procedure in which i can chosse multiple values. eg I need to show more …
4 replies
I am having the following problem and I do not know as to treat it in the SQL Server 2000. &nb…
10 replies
I am trying to set up a data dictionary for a software package in which there is 735 tables. I…
3 replies
I have the following query. It was initially a cursor and I'm trying to refrain from the cursor as …
7 replies
Viewing 15 topics - 6,286 through 6,300 (of 17,082 total)
You must be logged in to create new topics.