Topics
Started by
Posts
Last post
I have a windows login that is part of sysadmin, that is trying to run a stored procedure that incl…
5 replies
create table #T ( VisitID varchar(30), ER_Date date, HR int ) insert into #T(VisitID, ER_Date, HR) …
12 replies
I have a table which is being written to by another application. A few things of note I can't alter…
6 replies
--------------------------------------------------------------------------- NESTED DEPENDENCIES:&nb…
10 replies
I use the following code to list replicated tables: SELECT Name FROM sys.views WHERE is_replicated…
9 replies
CREATE TABLE [dbo].[zA]( [InvoiceNo] [nvarchar](255) NULL, [Code] [nvarchar](255) NULL, [Date] [dat…
4 replies
By: kevinyl
Hi Gang- I have some stored procedures that do updates using table aliases, like this: UPDATE Table…
6 replies
Hello I have a query that works as a loop but it is slow. How can I do this with a standard query? …
15 replies
I have a table that I need to run off a different server\db and looking for the most efficient way …
14 replies
By: Bruin
Hello. I have data in a table that I want to pivot from 1 row to multiple columns. I only want the …
5 replies
I have a large table being written too every second with equipment (PLC) information. I need to fig…
12 replies
I have a large table being written too every second with equipment (PLC) information. I need to fig…
2 replies
Hi I know I'm doing something wrong in my row_number logic, just not sure what.. My data loo…
5 replies
Hi I know I'm doing something wrong in my row_number logic, just not sure what.. My data loo…
1 replies
Hi I know I'm doing something wrong in my row_number logic, just not sure what.. My data loo…
1 replies
Viewing 15 topics - 1 through 15 (of 4,983 total)
You must be logged in to create new topics.