SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Error converting datatype varchar to bigint

  Hi Tried a few things here but can't seem to get past the 'Error converting datatype varchar to big…

  krypto69

  5 replies

  1 year, 8 months ago

  By: Jeffrey Williams

• Why is BigQuery Sandbox saying its ERROR: Expected keyword AS but got "(" at [1:

  Is this an issue with BigQuerry. I was follwing along with this youtube video and for some reason t…

  willdabeast28

  1 replies

  1 year, 8 months ago

  By: Mr. Brian Gale

• How to extract number that is greater than or equal to 16 digits

  Good Morning,   I am using sql server 2022, I have a table I would like to extract 16 Digits o…

  Zond Sita

  7 replies

  1 year, 8 months ago

  By: Phil Parkin

• Basic query performance

  Hi, I have this pretty basic query that is starting to perform slowly. It returns over 22m records …

  krypto69

  22 replies

  1 year, 8 months ago

  By: Mr. Brian Gale

• Column Name Is Different in Power BI Than SQL View

  Hi all, Using Snowflake. When I Describe my View the first columns shows as Nielsen Market Name (KU…

  winston.snyder

  2 replies

  1 year, 8 months ago

  By: Mr. Brian Gale

• Aggregate date series

  I have a an EmployeeTable with data for each day. I need to aggregate that into a table with From a…

  hebjTS

  4 replies

  1 year, 8 months ago

  By: hebjTS

• How to query selected multiple rows into multiple colums

  How to display datas using query data from multiple specific rows in one table sql into multiple co…

  harrytiadi

  3 replies

  1 year, 8 months ago

  By: Phil Parkin

• Return

  Self taught novice learning SQL and would welcome some help with the following code problem In my d…

  Cybodz

  11 replies

  1 year, 8 months ago

  By: Cybodz

• Freezing of multiple databases using VDI snapshot backup command.

  Transact-SQL snapshot backup for SQL Server 2022: Suspend all user databases on the server for a sn…

  Vivek Luhaniwal

  1 replies

  1 year, 8 months ago

  By: Vivek Luhaniwal

• Last value in a row containing..

  I've inherited code in which I need to designate each PATID as either Rel_Exempt or Med_Exempt, dep…

  boehnc

  7 replies

  1 year, 9 months ago

  By: boehnc

• Replication for archive server with longer retention period

  I want to set up SQL Server transactional replication from a main SQL Server to an archive SQL Serv…

  Jon 0x7f800000

  4 replies

  1 year, 9 months ago

  By: Jon 0x7f800000

• Retrieving First Word, First + Second Word, First + Second + Third Word, First

  Hi All, I have the company names in one column. Need a sql server query to  fetch in separate colum…

  sathishkm

  8 replies

  1 year, 9 months ago

  By: Jeff Moden

• Why don't these two queries return the same data?

  I have a table-value function that returns data for a report.  However, it's not returning the corr…

  edwardwill

  3 replies

  1 year, 9 months ago

  By: edwardwill

• SQL Challenge: Employee Salary Analytics

  onsider an employees table: employee_id (int) employee_name (varchar) department (varchar) joining_…

  Piyushbhatt

  4 replies

  1 year, 9 months ago

  By: Mr. Brian Gale

• Lead Updates Not Working, Only Rendering Nulls

  I hav a table that holds sports betting lines that i am using in a pseudo SSIS environment, and i'm…

  Zososql

  9 replies

  1 year, 9 months ago

  By: Phil Parkin