Topics
Started by
Posts
Last post
I have an SQL issue that I cant solve and I need some help with it please. The attached file is an …
6 replies
With all of the rocket scientist SQL programmers here I was wondering if anyone had a validate emai…
28 replies
CREATE TABLE #Tracking ( ID INT IDENTITY(1,1),COrderID INT,OrderNumber VARCHAR(100),ProjectName VAR…
2 replies
In t-sql 2012 I have a select statement that looks like the following: Select CONVERT(smalldatetime…
2 replies
Hi, TableA Col1 ---- 13.4 13.4 a 13..4 13,.4 Result for Table A needed: Col1 ColCalculated -…
3 replies
Hi I am finding it difficult to find an example that allows for insertion of additional rows into a…
6 replies
Hi, I'm interested in to find out the storage location of a table in MSSQL. I found out, that I can…
4 replies
Hello All, I've 2 tables QuestionAnswers and ConditionalQuestions and fetching data from them using…
4 replies
Hi, What's the best way to calculate a customers age and value by month and year? I need to be able…
1 replies
HI ALL , I HAVE FOLLOWING QUERY I WANT MY SERVICED_AMT SHOULD BE SUBTRACTED FROM TRAN_AMT FOR EA…
2 replies
select CONVERT(VARCHAR(10),LEFT( e.REGION ,10))AS reg ,count(JOINING_DATE) from emp e group by CONV…
4 replies
The following t-sql 2012 works fine in sql management studio. However when I place it in a .net 201…
1 replies
I have been using SQL Spatial for since its inception in SQL 2005. My current environment is SQL S…
1 replies
I have two nvarchar fields with time data 12:34:34 and the second one 12:34 I want to calculate the…
3 replies
SELECT MAX(ID) FROM [LinkedServer].[Database].dbo.[TableName] (NOLOCK) WHERE <Condition> The …
6 replies
Viewing 15 topics - 3,796 through 3,810 (of 4,984 total)
You must be logged in to create new topics.