I tried to just add a column to the table with a default value of the current day but it errors out with because there is no date (Column 14)...

declare @t table (tablename varchar(100))

insert into @t values 
('dbo.mytable'),
('etl.dbo.table'),
('koagvakjnonsenseajg4648.dbo.RandomTableForSSChahfhaijfhfhf5664646'),
('nonsensetable')

select tablename,
Substring(tablename, charIndex('dbo.',tablename), len(tablename))
from @t
where charIndex('dbo.',tablename) > 0

removed

• This reply was modified 4 years, 4 months ago by Mike01.

if you provide more relevant data, we can maybe help

Try joining to it

Create table #table1 (PrintOrderNo int, 
PayGroupID int,
LineNumber int,
CompensationDescription varchar(10))
insert into #table1 values 
(1,1,1,'test1'),
(1,1,2,'test2'),
(2,1,1,'test3'),
(2,1,2,'test4'),
(3,1,1,'test1')

select 
PrintOrderNo as "@PrintOrderID"
,PayGroupID as "@PayGroup"
,(
select 
LineNumber as "@DetailNo"
,CompensationDescription as "@Description"
FROM #Table1...

Remove the comp alias.  Also, that nested select is returning all rows from Table1 for LineNumber and CompensationDescription regardless of which print order no it belongs to

Create...

This is the best line, I'll make sure I skip over any of your questions.  Glad you got it 'resolved'

Doing it with create scripts and DDL and all the bullshit...

Not sure what you are asking.  Max of what??

is c.name really = to 'x'??  what does this return?

SELECT CASE

WHEN

(

CS.replica_server_name IS NULL

OR CS.replica_server_name = ''

) THEN

N'NOTPRIMARY'

ELSE

CS.replica_server_name

END,

c.name

FROM sys.availability_groups_cluster C

INNER JOIN sys.dm_hadr_availability_replica_cluster_states CS

ON CS.group_id = C.group_id

INNER JOIN sys.dm_hadr_availability_replica_states RS

ON RS.replica_id =...

• This reply was modified 4 years, 6 months ago by Mike01.

I think you want to check the entre table for fields that are null or have an empty string.  You can try something like this

DECLARE @tb nvarchar(512) = N'dbo.[salescube_export]';

DECLARE @sql...

declare @NumRecords int = 1555201,
@NumInBatch int = 800,
@NumGroups int = 0,
@count int = 0

while (case when @Count = 0 then @NumInBatch else @NumRecords/(@count) end) >= @NumInBatch
begin
print('ID =...

I believe that the fast forward cursor of SQL Server is a great tool to use if, and only if, multiple actions need to be taken on each record...

Have you thought about how many rows are in the table to begin with? If 35m and you're deleting 30m, maybe a faster approach, to

begin with, is to insert 5m...

I echo what the others are saying.  Can you provide some sample data as well as how you are determining the @DaysToAdd  parameter for each date?

You query produced the correct results. You need to use your reporting tool to handle the display that you want. SQL will not produce what you are looking...