Topics
Started by
Posts
Last post
I have the following query that is supposed to update a date-column in a table based on the lowest …
23 replies
Hi All, I am trying to do paging with T-SQL, and I managed to do it for a small table, retreiving p…
2 replies
Any idea what Latin1_General_CI_AS stands for? I mean what CI and AS stands for? I think the defaul…
3 replies
I have address data that contains City, ZipCode, and CityType. For any given distinct city and zipc…
4 replies
Hi, I cannot use ORDER BY clause in view unless TOP is specified. Without using top I get following…
3 replies
I have a production table called 'County2' with the following columns: CountyID (identity), [Name],…
2 replies
Hi, I need to randomly assign values to a column in a table. I need to update a column in a table w…
6 replies
can I have composite index on identity column? Regards - JL
1 replies
i am just stuck in a simple and complex query.. i hope that one of you will surly help me.. i have …
5 replies
In the Latin1_General collation, ss is treated like ß (German sharp s) in comparisons: 'ss' = 'ß' -…
5 replies
CREATE PROCEDURE CsatDataPull_SP_DP AS IF EXISTS (SELECT 1 FROM SYS.SYSOBJECTS WHERE NAME = 'AllReq…
1 replies
Hi, Replicating a procedure that exists on our legacy system which takes a letter template, perfor…
6 replies
I have a column c1 in a table T1, there is another table t2 with column c2. I am required to prepar…
3 replies
while running below statement in SQL server 2005 getting error message Ambiguous column name 'firs…
14 replies
I wanted to calculate the date difference between first row and the second row in the same table. I…
8 replies
Viewing 15 topics - 8,941 through 8,955 (of 12,234 total)
You must be logged in to create new topics.