Topics
Started by
Posts
Last post
Hi, When i run the follwoing query select * from dbo.Part_Mast where Part_Num in (select convert(va…
24 replies
I can select eliminating duplicate rows by using DISNTICT keyword but how can I select the rows whi…
11 replies
I have a Column in a Table called TraceDate of DATETIME DataType. I also have another Column in the…
2 replies
How to generate 'CREATE TABLE' script using Stored procedure ? I want to pass table name to sp and …
5 replies
select avg (select sum(duration) duration from cutlog group by datepart(dy,date)) from .......…
3 replies
Hi guys, Need your help I a database column called FILE_EXT and holds file data eg intra_005561.pd…
2 replies
Hi, May i know the query i need to use to list the database name as well as other databases …
2 replies
I’m hitting a brick wall or something. I’m trying to take a monthly running total of commissi…
8 replies
Hi We have a 3rd party app that is using sp_prepexec for all its queries on the database. A simple …
1 replies
When Iam trying to insert a table I am getting follwin mesg. Server: Msg 515, Level 16, State 2, Li…
8 replies
Hi SQL Server Central. The following script takes at least a couple of hours to run and I'm w…
8 replies
Hi All. SQL Server 2000 Can someone please help with the following: - Structure: tblCustomer Custom…
4 replies
Hi I have a stored procedure that creates automatically orderlines in a ERP system. The source is …
6 replies
Hi, I need to create a separate DTS Package to upload data from a different server. Data from 10 di…
2 replies
I have created a link between two sql server database and what I want to be able to do is create a …
2 replies
Viewing 15 topics - 8,911 through 8,925 (of 17,082 total)
You must be logged in to create new topics.