Topics
Started by
Posts
Last post
from the given string need to extract the filename: \\CORP-BI-DEV-01\Temp\TIVExplorer\vzwprices-201…
11 replies
I have the following tables:SET ANSI_PADDING ONGO CREATE TABLE [dbo].[StockCurrent]( &nb…
1 replies
Hi, I want to calculate the difference time(minutes) between each I and O flag. Please refer below …
4 replies
Hi colleagues!We have been run into issue after migration from SQL 2008R2 to SQL 2016. Our reportin…
2 replies
I can't believe I'm having to ask this, but I am noticing some incredibly odd behavior with a UNION…
11 replies
We are originally using team foundation server for our .net and database project in visual studio. …
1 replies
I am stuck as to why the query is not returning all rows. My CTE1 has 92 rows and CTE2 has 90 rows.…
3 replies
INSERT INTO dbo.mixedwords (Mixed, MixLen, GoodVa)Values ( SELECT DISTINCT LTRIM(RTRim(mixVa)…
4 replies
How to Create temp table at the time of insert? DECLARE @sql AS NVARCHAR(1000)SET @sql = 'BUL…
6 replies
The basic structure of the significant tables is: Student ---(1,M)-- Takes ---(M,1)---CourseH…
7 replies
CNCB 17 1CNPO 17 &n…
10 replies
I have a history table which takes 15 mins to complete.Delete from table_name where dt_bus =@dt_sta…
3 replies
The prior DBA used FoxPro for a utility. I am rewriting it in SQL and need assistance with a comman…
5 replies
I keep getting this error even if had my identitycolumn explicity mentioned.Explicit value must be …
13 replies
I've got a query that just selects from one database into another.It goes nothing clever , so I'm s…
4 replies
Viewing 15 topics - 2,566 through 2,580 (of 3,091 total)
You must be logged in to create new topics.