Topics
Started by
Posts
Last post
I am using the following code SELECT userid, username, billed,SUM(grossamt) FROM EMNCommon WHERE (t…
1 replies
i have table a with two columns.. Testtable vai1 int vai2 varchar(50) values vai1 =1 vai2= 1234,578…
5 replies
By: ps.
Hi, I have a table as: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Questio…
7 replies
I wrote this view a while back whose only purpose is to add a single field from anther table that w…
11 replies
Hi everybody, i work with sql server 2005 and i must to create a batch with some t sql commands ins…
2 replies
Can anyone advice how to join results from two (or more) SELECTs with aggregate function? Select 1 …
2 replies
Hi All, I have a dropdown list which is a multi selection field, when multiple value is selected it…
4 replies
I'm executing several discrete queries in a single batch against SQL Server. For example: update ta…
5 replies
So I know how to do a begin and commit with rollback on one tran or a try catch block. This is a l…
3 replies
Hello ALL, If in my database SQL 2005 as value NULL where is an empty cell, and I wish to display i…
10 replies
Hi all, I am trying to create index views but i get error as follow: Remote access is not allowed f…
5 replies
I thought it might be interesting to create a consolidated Tips and Tricks thread. These should be…
1 replies
By: Garadin
I have been asked to develop a report that returns similar output as the attached excel file. I am …
2 replies
By: 2Tall
Sorry if this is the most basic of questions. I've searched high & low but I cannot find an an…
2 replies
what are the Common Mistakes in T-SQL ? For example: @@Error gives correct value in next line onl…
73 replies
Viewing 15 topics - 7,771 through 7,785 (of 12,234 total)
You must be logged in to create new topics.