Topics
Started by
Posts
Last post
Hey All, I am trying to convert cursor based stored proc in to set based simple statements stored p…
1 replies
I'm selecting from three different Views, which are basically these: group leader (vwGL), group par…
1 replies
hello, everyone Help needed in query i have a table which have three field tabId tabPrtId …
3 replies
Hi, I have a T-SQL script to be executed as part of refresh. This script is getting executed fine d…
12 replies
Here is a sample table: CREATE TABLE [dbo].[tbl_My_Test]( [intMain_ID] [int] NOT NULL, [strJob_I…
13 replies
Hi, I want to send mail's from sql , eg: Consider table as Table1 , with 1 column as modifiedon, …
3 replies
Dear Sir, I have created table which contains ClienId,ClientName,Address etc. Table-Client Here Cli…
1 replies
Hi, we have the query in our sp which is now taking more time select main.sno,main.name, (select to…
5 replies
I get the following error while trying to calculate the power value of a negative number. Ex : SELE…
5 replies
I have a table of Case Numbers and Doctors involved in the case. There could be any number of docs…
7 replies
Hi Folks, Is there a way of choosing a specific column of a table in a UDF, given that you can't us…
1 replies
hi, I need to know the query : who had logon to my SQL Server and who accessed the databases ?? I a…
1 replies
Hi sir, i took full Database backup on Monday morning,Next day on tuesday i took differential backu…
5 replies
Hi all, I've got a column, called user_code char(3) that is used to store unique codes. The pattern…
1 replies
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[export_file] AS BEGIN declare …
8 replies
Viewing 15 topics - 886 through 900 (of 17,082 total)
You must be logged in to create new topics.