Topics
Started by
Posts
Last post
i hav a table in which am entering answers .....i want to calculate answer /hour....means tht on a…
6 replies
I have a table that holds audit data. For every row that's inserted, updated, or deleted into the d…
4 replies
Hi all, I ran bcp out from sql server database for the table below: TRLC table: est_no varchar(10)…
13 replies
I have a SELECT query that is searching for the maximum value for each person in a varchar field, b…
11 replies
Hi all, What I really want to do in the below statement is have the three values display on one row…
11 replies
I have recently been introduced to the wonders of using APPLY. I've been working on a report, and …
6 replies
Hi guys, I have one XML file which has 3 smaller xml files and would like to split it into3 pieces …
7 replies
we have a query that creates a recordset like the one shown below. I'm looking for a different way…
13 replies
I need to search a product code field, if nothing is found i want to search the description field l…
3 replies
HI All, DECLARE@sqlNVARCHAR(512) DECLARE@MaxCountINT DECLARE@CountINT DECLARE@FieldName N…
3 replies
select coalesce(col1,0) from openquery(mySourceDB, ' SELECT MIN(con_id) AS col1 FROM myTable WHERE …
5 replies
i'm new in sql server 2005 plz help me i try to sum totalquantities both receiving an Sales and sub…
9 replies
Hi, I have two order tables that I am trying to join. Both have have 13 records in them but when I …
3 replies
CREATE TABLE #TEST(A varchar(40),B varchar(30)); INSERT INTO #TEST(A) VALUES('A'); INSERT INTO #TES…
3 replies
I want to assign a value in a column in a table based on values in other columns on the same row. …
5 replies
Viewing 15 topics - 2,251 through 2,265 (of 12,234 total)
You must be logged in to create new topics.