No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky0Votes
POSTING TIPS - source code, screen images, details within...
When you're posting a question - please search the forum first! If that fails, and you wish to include T-SQL, C#, or VB code in your post, see below. If you want to show us what you see on ...2 Replies | 37076 Views | Phil Brammer - Tuesday, December 01, 2009 10:19 PM | Last Reply Ed Price - MSFT - Monday, May 20, 2013 2:38 PM -
Sticky0Votes
Solutions to Common T-SQL Problems
The Volunteer Moderators andAnswerers who support the Microsoft MSDN SQL Server Forums have created a Wiki to present Solutions to Common T-SQL Problems. Check here to see if ...0 Replies | 56055 Views | Arnie Rowland - Saturday, April 12, 2008 2:52 PM
-
Unanswered0Votes
Slow INSERT to a table
I have a stored proc that inserts 5 Million records into a table , the SELECT statement has around 10 Joins. There were no issues till last month, but now the table insert is too slow, say 500 records ...2 Replies | 61 Views | kool.rens - 1 hour 20 minutes ago | Last Reply kool.rens - 1 hour 10 minutes ago -
Proposed0Votes
SQL -FUNCTION ISSUE
Hi Experts , I have badly stuck in creating a UDF Function. Please check below Link and help ...2 Replies | 155 Views | Rihan8585 - Thursday, July 04, 2013 1:07 PM | Last Reply RSingh() - 1 hour 59 minutes ago -
Unanswered0Votes
VBscript - Parametrized SQL Insert Statement (CM11874)
Good day all, I need to create a VBscript to perform the following: Gather the Supplier Name information from the Company DB, using a Stored ...2 Replies | 162 Views | GregoryLock - Friday, July 05, 2013 4:35 PM | Last Reply RSingh() - 2 hours 5 minutes ago -
Unanswered0Votes
Extract Values from XML column of SQL
Hi, I have a column named "XMLColumnwhich" in a Table named "demandRequest"contains an XML as follows <RequestEntity ...2 Replies | 107 Views | Stick.Hello - 9 hours 16 minutes ago | Last Reply RSingh() - 2 hours 31 minutes ago -
Proposed0Votes
Could I do this with less code?
create table #jim (name varchar(100), createdon datetime) -- drop table #jim create table #jim2 (name varchar(100), createdon datetime) -- drop ...7 Replies | 235 Views | James R Traub - Friday, July 05, 2013 11:27 PM | Last Reply JRStern - 3 hours 24 minutes ago -
Answered1Votes
SQL udf returns incorrect value
I have a UDF that returns the number of hours worked in a day from ...3 Replies | 95 Views | DeanSanderson - 10 hours 45 minutes ago | Last Reply Duane Dicks - 10 hours 26 minutes ago -
Unanswered2Votes
Ascii table in SQL
create table #ASCII(id int, a char(1)) declare @x INT set @x=0 while @x2 Replies | 108 Views | Bill M. Geronatsios - 14 hours 54 minutes ago | Last Reply Dan Guzman - 12 hours 39 minutes ago -
Proposed0Votes
How to delete rows not in all 3 tables
How do I write a query to delete all the rows in all 3 tables that do not match values in the other tables so all 3 tables have the same values for X in them and the same number of ...15 Replies | 333 Views | duanewilson - Thursday, July 04, 2013 2:37 AM | Last Reply --CELKO-- - 13 hours 51 minutes ago -
Answered0Votes
Distinct in select query
Hi, I have a table with two columns. Table:Station column:Bmu , Cmu Bmu/Cmu 6/ ...2 Replies | 94 Views | syed javid ali - 16 hours 9 minutes ago | Last Reply syed javid ali - 15 hours 35 minutes ago -
Answered1Votes
get the day from date value in SQL Server
Hello, I want to know how can I (in sql server) get the day of week(eg Mon, Tue, Wed, etc) when a specific date is being given to the stored ...5 Replies | 62819 Views | Marais van Zyl - Friday, May 11, 2007 10:53 AM | Last Reply Salahuddin Quazi - 21 hours 38 minutes ago -
Answered1Votes
Getting Previous Date In a new row
I have a task to achieve. I am sure it would be simple but i am confused...Here is following how i need data in a new column name "RECORD END DATE" ID EmpID ...4 Replies | 240 Views | Anji1407 - Friday, July 05, 2013 7:57 PM | Last Reply Anji1407 - Friday, July 05, 2013 9:03 PM -
Proposed0Votes
cannot set the result of a select statement to a variable : Select statements included within a function cannot return data to a client.
I am trying to set a User function to get alphas, Betas and R2 from a linear regression within sql. I can get the data through the select statement, but it fails to register as a ...3 Replies | 162 Views | Upsydian - Friday, July 05, 2013 4:54 PM | Last Reply Tom Groszko - Friday, July 05, 2013 8:12 PM -
Proposed0Votes
Returning 0 when no records exist in a sql query
How can I return a 0 when no records exists in an ms sql query? I'm unable to use ISNULL or COALEASE functions since no rows are being returned at ...14 Replies | 261 Views | ADS97_ - Tuesday, July 02, 2013 6:47 PM | Last Reply Naomi N - Friday, July 05, 2013 7:30 PM -
Proposed2Votes
Insert into table A and Update Table B (Identity_ID)
Hello , I am trying to do some thing like this, Insert into Table_A which has Identity Column , and then update ...6 Replies | 242 Views | SQLServer2k8 - Wednesday, June 26, 2013 4:47 PM | Last Reply Kalman Toth - Friday, July 05, 2013 6:37 PM -
Answered0Votes
How to get previous month data?
Hi, In my SP, I am having a variable which is @As_Date varchar(10) and it is holding date value (MM/DD/YYYY format) Now I want to ahieve the following ...3 Replies | 153 Views | UltraDev - Friday, July 05, 2013 8:52 AM | Last Reply --CELKO-- - Friday, July 05, 2013 6:35 PM -
Answered0Votes
How to subtract 1 from variable which holds date (like 12/31/2013)?
Hi, Can you please advise how do I subtract some number from the variable @Var which is holding some date value (MM/DD/YYYY format) I ...8 Replies | 163 Views | UltraDev - Friday, July 05, 2013 6:39 AM | Last Reply --CELKO-- - Friday, July 05, 2013 6:27 PM -
Proposed0Votes
How to display only 'full' months
Hello, I am looking for some help on the following: How to write a query that displays the result in two columns: Column 1 should contain a sum of all 'completed' ...5 Replies | 169 Views | SPEHE - Thursday, July 04, 2013 11:10 AM | Last Reply --CELKO-- - Friday, July 05, 2013 6:19 PM -
Proposed0Votes
TSQL-UDF-Function Help
Hi Experts , I have a requirement where I have to create a FUNCTION Where I could Pass Two Parameter 1)ColumnName 2)Table Name ...18 Replies | 364 Views | Rihan8585 - Thursday, July 04, 2013 8:48 AM | Last Reply --CELKO-- - Friday, July 05, 2013 5:51 PM -
Unanswered0Votes
Dealing with text, ntext, image pointer problem from VFP
Hi everybody, I had the similar problem before and even documented it in this blog post Dealing with the "The text, ntext, or image pointer value ...2 Replies | 139 Views | Naomi N - Wednesday, July 03, 2013 6:15 PM | Last Reply Naomi N - Friday, July 05, 2013 5:30 PM -
Answered0Votes
sql select query for maximum occurance
Hi, I have a number column , in that i have many repeated numbers. I want to display which number had occured maximum number of times and its allied columns by using a ...12 Replies | 188 Views | syed javid ali - Friday, July 05, 2013 11:37 AM | Last Reply Hunchback - Friday, July 05, 2013 5:28 PM - Items 1 to 20 of 64733 Next ›