Topics
Started by
Posts
Last post
edit **This is in SQL SERVER 2000. So ROW_NUMBER () OVER doesnt work I am trying to create a view …
7 replies
I have a query that counts data in my database...but I also need to find the max value of that coun…
9 replies
Hi there I have the following TSQL - SELECT[Tenancy Reference] ,[Place Reference] ,[Tenan…
3 replies
Very simple question with I hope a simple answer. How do you install OSL on a server that does not …
4 replies
I have data in a table that I "reformat" and place into SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER …
7 replies
The cursor below runs within a dts package and obviously takes quite a while to run over approx 6 m…
32 replies
-- This demonstrates how SQL server's decision to not use your DISTINCT -- clause can affect your p…
2 replies
I'm replacing a function in application code. The function does this (pseudo code) Select list of…
3 replies
Good day to all, I'm not sure where to put this inquiry. And here it goes, When I execute a command…
4 replies
Hi Every body, how can know for each table size i need sp_speace used only for one table i need al…
4 replies
Error : Cannot resolve collation conflict for UNION operation. I getting these error becuase one qu…
1 replies
I have a table has a datetime field stored date, e.g. 2010-07-21, and another datetime field store…
2 replies
Hello, I am using SQLServer 2008 R2. I have a requirement to display or highlight which field has b…
5 replies
Hi, I am using dts package to export data to text file.. Query is. select '' as sno, name, comments…
5 replies
Hello all, Hopefully someone can help me with this as I do not have anyone too bounce this against …
1 replies
Viewing 15 topics - 901 through 915 (of 17,082 total)
You must be logged in to create new topics.