No announcements
Found 1026029 threads
-
0 Votessql query
Hi Naomi, Your query returns 0 rows.Answered | 16 Replies | 1239 Views | Created by Shaky1988 - Tuesday, April 29, 2014 12:11 PM | Last reply by HimanshuSharma - Wednesday, April 30, 2014 11:24 AM
-
0 Votes
Access query vs SQL query
I think your query has got the wrong WHERE conditions.Answered | 6 Replies | 4008 Views | Created by Swan_E - Wednesday, July 1, 2009 11:28 AM | Last reply by John Ang_ - Wednesday, July 1, 2009 1:46 PM -
0 Votes
With in sql query
WITH can either denote the start of a common table expression (CTE) or a locking hint so in the case of a CTE the semi colon is mandatory to end the statement preceding its declaration so the ...Answered | 6 Replies | 1420 Views | Created by miruan - Tuesday, May 7, 2013 10:58 AM | Last reply by Andre Ranieri - Tuesday, May 7, 2013 2:07 PM -
0 Votes
SQL QUERIES
i used following queries --GET all database name SELECT * FROM sys.sysdatabases Select name,filename,crdate,version From ...Answered | 4 Replies | 2281 Views | Created by Esha2nk - Tuesday, September 25, 2012 12:37 PM | Last reply by SQLZealots - Tuesday, September 25, 2012 1:00 PM -
0 Votes
SQL Query
Please get a book on basic RDBMS and SQL.Answered | 4 Replies | 663 Views | Created by Ryan88878 - Sunday, July 10, 2016 12:25 PM | Last reply by PrasadSahoo - Monday, July 11, 2016 8:14 AM -
6 Votes
SQL Query
You can either use an aggregate function along with CASE statement or a PIVOT operator like below; DECLARE @Attendance AS TABLE ( Name ...Answered | 5 Replies | 1077 Views | Created by Sunil404 - Friday, November 14, 2014 10:48 AM | Last reply by Krishnakumar S - Friday, November 14, 2014 11:26 AM -
0 Votes
SQL Queries
That means you can connect to the server but failed to execute queries?Answered | 2 Replies | 5950 Views | Created by adrw - Tuesday, October 12, 2010 1:50 PM | Last reply by Rick Byham, Microsoft - Wednesday, October 13, 2010 3:21 PM -
0 Votes
SQL Query
Second, since there are 10 different time related types in SQL Server, you don't want to keep adjusting this "fraction of second" part checking at the column's exact type ...Answered | 5 Replies | 1998 Views | Created by Raj ku - Friday, February 22, 2013 9:31 PM | Last reply by TiborK - Saturday, February 23, 2013 7:29 AM -
0 Votes
sql query
is there any query in sql to print next line like:- abc xyz You can use the carriage return or line feed to achieve this.Answered | 2 Replies | 5918 Views | Created by Varu007 - Friday, February 12, 2010 8:44 AM | Last reply by Clive Strong - Saturday, February 13, 2010 2:27 PM -
0 Votes
SQL Query
The minimal polite behavior on an SQL forum is to post DDL.Answered | 4 Replies | 1295 Views | Created by akhilrajau - Tuesday, April 23, 2013 12:53 PM | Last reply by --CELKO-- - Tuesday, April 23, 2013 1:35 PM -
0 Votes
SQL QUERY
Hi NZ-D, Uri's query can be the best answer for your requirement.Answered | 7 Replies | 636 Views | Created by Peter8444 - Thursday, June 18, 2015 10:42 AM | Last reply by Peter8444 - Friday, June 19, 2015 6:45 AM -
4 Votes
Sql Query
your query is costing 0.0183403 while with union it is ...Answered | 8 Replies | 2968 Views | Created by Gangadhar Thumu - Monday, February 13, 2012 6:28 AM | Last reply by David Frommer - Saturday, February 18, 2012 11:05 PM -
0 Votes
SQL Query
--http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/6217a37e-82b5-40c3-8401-50236a328f26 --drop table [dbo].Answered | 4 Replies | 1857 Views | Created by Sam_cs123 - Friday, September 6, 2013 7:24 AM | Last reply by Jingyang Li - Friday, September 6, 2013 2:21 PM -
0 Votes
SQL query
Dataset query: select username, userrights from yourtable Row Group: username Column Group: ...Answered | 3 Replies | 862 Views | Created by SQLrocket3003 - Sunday, November 2, 2014 10:40 PM | Last reply by cruellogic - Monday, November 3, 2014 5:37 AM -
3 Votes
SQL Query vs VB Query
Hi alltaken, jwavilla has already given a detailed explanation to SQL Query and VB.Answered | 2 Replies | 6089 Views | Created by alltaken - Thursday, April 7, 2011 10:28 PM | Last reply by Kee Poppy - Tuesday, April 12, 2011 6:23 AM -
2 Votes
sql query
Try this: SELECT cash_on_hand.DCCR_FORM_ID ,SUM(CAST(COALESCE(cash_on_hand.coh, 0) AS NUMERIC(12, 2))) AS coh_amount FROM ( SELECT ...Answered | 2 Replies | 2570 Views | Created by auwi987 - Friday, July 13, 2012 2:51 PM | Last reply by Chuck Pedretti - Friday, July 13, 2012 2:59 PM -
3 Votes
Monitoring SQL Queries
Hi Brenda, if you trace the report execution with SQL Profiler (or the modern XEvents) you will see the executing query with the start and end time.Answered | 8 Replies | 1796 Views | Created by TheBrenda - Friday, April 25, 2014 1:06 PM | Last reply by Sean Gallardy - Saturday, May 3, 2014 5:12 PM - Items 1 to 20 of 1026029 Next ›
No announcements
