Topics
Started by
Posts
Last post
I am a forever learning new DBA. I have been handed a project I have no idea how to complete. I hav…
7 replies
Hello all, We are in the process of replacing SQL-Anywhere with to SQL-Server. Over a year ago I ha…
5 replies
I have 2 tables (1 reference and other actual table)with 30 similar columns (and only 1 row) but wi…
1 replies
Two tables, they are not completely known at design time. They have no column_names in common. At r…
5 replies
Is it possible to create a table with composite primary key(ID+Identity (1,1)) and identity will in…
15 replies
Create TABLE #TableA ( TaskNameA nvarchar(100), GovernA bit, ToolTypeA nvarchar(10), ResourceN…
8 replies
Dear Group: I have a text file I am trying to use BULK INSERT to import the data but getting an err…
5 replies
Hi all, 99% sure the answer to this question is "it is not possible", but figured I'd check anyway.…
14 replies
In a table, I have a field (text format) which contains sometimes 2 or 3 consecutive empty lines of…
2 replies
DECLARE @JsonData NVARCHAR(MAX) =N'[{"preview":true,"offset":0,"result":{"pkid":"3e1900e5-e997-4ae2…
1 replies
Dear Group: I am not sure if this is a T-SQL / SSMS issue, or Excel, so if this is off-topic please…
11 replies
Hi, I have a table of sites where the there are multiple site names with different site managers. S…
4 replies
-- EXEC SP_DROP ##XXX -- For older versions of SQLserver DROP TABLE IF EXISTS ##XXX select t…
8 replies
I have fine tune the query to great extent but these nested loops are something that eat up most in…
3 replies
Dear Group: This is my first attempt at using the xp_cmdshell command, but right now, I am trying t…
5 replies
Viewing 15 topics - 346 through 360 (of 1,544 total)
You must be logged in to create new topics.