Topics
Started by
Posts
Last post
I have scenario to update a col A, with col B. If col A has a record like '%A' and col B is blank, …
4 replies
Hi masters, i have learned in this site that if i want to protect my stored procedures, from ex…
4 replies
Hi is it possible to use %SystemRoot% as part of a CmdExec command in a Job Step? Some of our olde…
5 replies
Hello I wrote the following query to create a function: CREATE FUNCTION [lookupTest] (@prefix nvarc…
6 replies
Good afternoon all, I am working on a script that will remove duplicate records from a very large t…
7 replies
This delete statement gives me an error: delete from transtatushistory where transtatusidold 17 a…
5 replies
Hi, I'm getting an invalid column error (Invalid column name 'EPPO') and was wondering if anyone co…
2 replies
This cursor isn't terribly complicated, but it's a step in a long query that is a pain to run and h…
3 replies
Hi, This is probably a simple one for someone with more experience than me but it's got me stumped.…
5 replies
CREATE TABLE [dbo].[MemberLabResult] ( [MemberLabId] [int] IDENTITY (1, 1) NOT NULL , [MemberId] …
29 replies
WHILE I SELECTING THE TABLE LIKE SELECT * FROM TABLE NAME THIS BELOW ERROR HAS OCCURRED TELL ME A W…
5 replies
Hi, I have a datafile that contains a terminator within the datavalues (,) and when importing that …
3 replies
Hi All, I have one scenario. Say for example, create view v1 as begin select eno,ename,ecode from e…
8 replies
Hi I need to transpose the data in Sql 2000, can some one help me Eg: Main Table : Item Price …
1 replies
Hi Everyone, I need a little help with a query. I have 2 tables First Table tblSalesMan has the fo…
4 replies
Viewing 15 topics - 1,726 through 1,740 (of 17,082 total)
You must be logged in to create new topics.