All Posts
question
anthony.green avatar image
anthony.green commented Default

I have a list of customers. For each customer there are n contracts,I need to display the customer with latest contract.Cna you write me a query?

sqlquery

0 Likes

0Answers

1 Comment

question
rohitk avatar image
rohitk answered Default

package execution completed.. and package doesnt execute

ssis ssis error

0 Likes

1Answer

0 Comments

question
veera avatar image
veera published Default

RODBC sqlSave to SQL Server fails when one column is POSIXct to datetime

sqlquery sqlerror

0 Likes

0Answers

0 Comments

question
Jeff Moden avatar image
Jeff Moden commented Default

linked excel to sql

sql_

0 Likes

0Answers

2 Comments

question
Jeff Moden avatar image
Jeff Moden answered Default

unable to delete the data by running the purging job

sqlquery

0 Likes

1Answer

1 Comment

question
Jeff Moden avatar image
Jeff Moden answered Default

ID is primary key value increasing by +15 or +random number every time I add a row

sqlserver table tables primary-key

0 Likes

1Answer

0 Comments

question
Jeff Moden avatar image
Jeff Moden answered Default

Is DBCC CHECKDB is it taking more time than usual? How to tune it?

sql server 2017 checkdb

0 Likes

1Answer

0 Comments

question
premkmr1 avatar image
premkmr1 published Default

Data Flow Task : Error ODBC Source Failed Validation and returned error code 0x80004005

ssis error sql-server-agent

0 Likes

0Answers

0 Comments

question
CarlTevez avatar image
CarlTevez commented Default

problem with where or and query

sqlquery

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
anthony.green avatar image
anthony.green answered Default

NON Equi Join on more than 2 tables

mysql sqlserver2012

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
anthony.green avatar image
anthony.green commented Default

SQL Server service virtual accounts and directories permissions

permissions service-account

0 Likes

1Answer

0 Comments

question
anthony.green avatar image
anthony.green answered Default

SQL Syntax or code syntax suggestions.

sql query

0 Likes

1Answer

0 Comments

question
anthony.green avatar image
anthony.green answered Default

Is there a function in SQL that does the same as the excel forecast.ets function

sqlquery

0 Likes

1Answer

0 Comments

question
louiedba avatar image
louiedba answered Default

how to import this xml into a table in single row?

xml import-data

0 Likes

1Answer

0 Comments

question
Jeff Moden avatar image
Jeff Moden answered Default

SSMS stoped to ask me where I want to save the query result

ssms

0 Likes

1Answer

0 Comments