Topics
Started by
Posts
Last post
Hi, I have two queries the first shows all students that have attended a course: SELECT DISTINCT t…
2 replies
I am selecting data from a table using Select id = NULLIF(SPACE(0)) etc. I did this because I did n…
11 replies
I've table and rows as follow, declare @t1 table (idx int identity(1,1), TID varchar(20), SeatN var…
4 replies
Hi all, I am having hard time forming this query to dedulicate - duplicate rows in a table: select…
21 replies
Dear Greater SQL Intellect, Is there a way to update table data values. I have this table: CREATE…
4 replies
Hi, I've been logging the active processes history for some time and found that values for cpu_time…
1 replies
Hi All, Can anybody please tell me how to use the bookmark in SSRS. Thanks in advance. 🙂
1 replies
Hi All, I have a simple SP that I'm trying to write that adds the row count of a number of tables i…
9 replies
I've tried to post this several times with the code, but it wont work, so the code is attached as a…
4 replies
Hi, I am new to SQL. I am using SQL2005. I have a table that has the following structure SET A…
17 replies
SELECT CHARINDEX('AAAAAAAAâ„¢BBBBBBBBBBBBBB',Char(153)) I can not seem to get the trademark to work i…
3 replies
I have to update millions of rows. I'm breaking it into batches based on date. I have an index on d…
4 replies
I'm writing a sproc that pulls data for one, or more years (i.e. 2009, 2010). My challenge (I think…
4 replies
Hello everybody, basically i have a column which contains data like (string1, string2......etc) (o…
7 replies
I've run into a situation where a drug data source provides two fields that contain delimited value…
2 replies
Viewing 15 topics - 3,886 through 3,900 (of 12,234 total)
You must be logged in to create new topics.