No announcements
Found 1135652 threads
-
0 Votesselect from select query
As you have not specify what type of query you are trying to execute, we can try simply as, SELECT FIELD1,CASE WHEN ID = 0 THEN (SELECT TOP 1 * FROM ...Answered | 1 Replies | 2963 Views | Created by Gaurav Arora IT professional (busy infotech) - Monday, September 16, 2013 11:14 AM | Last reply by Ch. Rajen Singh - Monday, September 16, 2013 11:22 AM
-
0 Votes
SELECT query
> need some help with SELECT query.Answered | 6 Replies | 550 Views | Created by green2004 - Friday, May 15, 2015 12:20 PM | Last reply by --CELKO-- - Friday, May 15, 2015 3:05 PM -
0 Votes
select query
I have added a select query on top for testing the output.Answered | 9 Replies | 3720 Views | Created by Sudeep Puvvadi - Tuesday, February 7, 2012 7:57 AM | Last reply by arun.passioniway - Tuesday, February 7, 2012 3:55 PM -
0 Votes
select query
You can prevent the XML encoding with the option TYPE: DECLARE @val varchar(20) SET @val = 'Hello ' + CHAR(13) + CHAR(10) + 'World' -- Result with ...Answered | 1 Replies | 801 Views | Created by emaak - Wednesday, August 6, 2014 5:30 PM | Last reply by Olaf Helper - Wednesday, August 6, 2014 5:54 PM -
0 Votes
Select Query.
Kindly have a look at below code to see how to to obtain desired results --Sample Data declare @t table ( empNo int , empName nvarchar(100) , dateReceived ...Answered | 1 Replies | 3038 Views | Created by AnirbanSingha - Tuesday, July 10, 2012 12:39 AM | Last reply by Chintak Chhapia - Tuesday, July 10, 2012 6:00 AM -
0 Votes
SELECT QUERY
Otherwise you're correct and this query would work.Answered | 8 Replies | 3980 Views | Created by Cool Tech - Wednesday, December 2, 2009 6:34 PM | Last reply by Arif Hasan - Thursday, December 3, 2009 7:06 AM -
1 Votes
Select Query
_________________________________________________ Please mark post/s answered/ helpful if they answer ur query -- kunalAnswered | 7 Replies | 3540 Views | Created by Seeta Rama Raju - Wednesday, November 11, 2009 10:05 AM | Last reply by Kunal Joshi - Thursday, November 12, 2009 12:23 PM -
0 Votes
select query
from what i understood.. may be this declare @ClientManager table(Id int,Organization varchar(20)) insert into @ClientManager values ...Answered | 1 Replies | 1154 Views | Created by emaak - Thursday, July 9, 2015 8:39 PM | Last reply by Stan210 - Thursday, July 9, 2015 8:57 PM -
0 Votes
Select Query ?
But i need to SELECT QUERY about my sample.Answered | 4 Replies | 1004 Views | Created by MSDN.CSharp - Monday, August 19, 2013 8:21 PM | Last reply by --CELKO-- - Tuesday, August 20, 2013 1:24 AM -
0 Votes
SELECT query
How can I invert this selection .Answered | 3 Replies | 5942 Views | Created by robhare - Wednesday, December 16, 2009 6:14 AM | Last reply by Melissa Suciadi - Wednesday, December 16, 2009 2:33 PM -
0 Votes
select query
= 6 AND CAST( substring( stuid, 4, Len(stuid)) AS INT)Answered | 6 Replies | 3989 Views | Created by Iniyan - Thursday, October 23, 2008 6:35 AM | Last reply by Eric Han - Friday, October 24, 2008 4:45 AM -
0 Votes
Select Query
Hi, Below is the code SELECT ID, COL1, COL2,COL3,COL4,COL5 FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY COL1, ...Answered | 6 Replies | 592 Views | Created by Shayaan - Monday, November 24, 2014 8:28 PM | Last reply by Sandeep Prajapati - Tuesday, November 25, 2014 6:38 AM -
0 Votes
VBA Select Query Issue
I create a table in Access and three queries like below: Query1: SELECT * FROM Table1 WHERE id ...Answered | 6 Replies | 1244 Views | Created by zaveri cc - Thursday, October 1, 2015 8:40 PM | Last reply by Fei Xue - Tuesday, October 6, 2015 7:25 AM -
2 Votes
columns in select query
Yes, you have write the 14 column names in the select query.Answered | 5 Replies | 5169 Views | Created by Sudeep Puvvadi - Friday, August 5, 2011 6:33 AM | Last reply by Kasturi Rajesh - Tuesday, August 9, 2011 6:30 AM -
1 Votes
select query
This query works if you have same subjects for each student The subject names should be hardcoded in the Pivot Statement If a student doesn't have a subject he will get a NULL in ...Answered | 8 Replies | 4828 Views | Created by smanian - Sunday, November 8, 2009 2:30 PM | Last reply by Murty Addanki - Wednesday, November 11, 2009 11:12 AM -
0 Votes
Select Query - Killing SQL
Do you have proper indexes on the tables used in the query?Answered | 6 Replies | 3652 Views | Created by Caz1224 - Wednesday, August 18, 2010 11:10 PM | Last reply by Arbi Baghdanian - Thursday, August 19, 2010 6:50 PM -
0 Votes
Select query not getting data
i am using a query in my asp.net application "select * from tablename" it is not working. the table is in relationship with two other table i removed relation but still not ...Answered | 6 Replies | 1207 Views | Created by Ifitikhar Iffy - Monday, March 16, 2015 6:47 AM | Last reply by Carl Cai - Wednesday, March 25, 2015 8:41 AM -
1 Votes
query with randomly selected textBoxes
What kind of query?Answered | 13 Replies | 2790 Views | Created by Mitja Bonca - Wednesday, May 27, 2009 3:58 PM | Last reply by Mitja Bonca - Tuesday, June 2, 2009 6:37 PM -
0 Votes
Update Query with subquery and select
if you have the common column that join Userlog & DebitInvHeader table, below is the update query UPDATE a set a.TransactionDate = b.Logindate from ...Answered | 1 Replies | 801 Views | Created by Password storing in SQL DB with different in SQL - Monday, March 14, 2016 5:41 AM | Last reply by SaravanaC - Monday, March 14, 2016 6:56 AM -
0 Votes
INSERT Query with SELECT max
Try this: sInsertCommand = "INSERT INTO criticalSummaryJustification " + "(criticalSummaryJustificationID, criticalSummaryJustificationLastUpdateDateTime) ...Answered | 4 Replies | 2129 Views | Created by REvans611 - Tuesday, August 27, 2013 7:24 PM | Last reply by REvans611 - Wednesday, August 28, 2013 11:49 AM - Items 1 to 20 of 1135652 Next ›
No announcements
