Lengkap

SQL SERVER Stored Procedure -- 2

I have 233 tables in a database. 2 columns are of my interest. Table_Name, Delta_byte(this only has 3 values A,C or D).

i need help to write a query that goes through all these tables and gets a count of the Delta_Byte column of each table.

Output like

Table Name | Delta_Byte| Record

T1 , A , 50

T1 , C , 3

T1 , D ,10

T2 , A , 27

T2 , C , 7

T2 , D ,11

and so on for all the tables. With the output i can get and aggregate sum of all the delta_Byte values

e.g.

Delta_Btye | Records

A 77

C 10

D 21

Hope that makes sense. i could use a UNION ALL query.. but that would mean specifying each table name and a where clause for the delta byte column...and there is a high chance of getting new tables added or previous ones deleted..

Help is appreciated...

Kemahiran: Pelayan Microsoft SQL, SQL, Pengaturcaraan C#, Pentadbiran Pangkalan Data, MySQL

Lihat lagi: sql server stored procedure resize image, sql server stored procedure copy data table, transaction sql server stored procedure, sql server stored procedure zip proximity, sql server stored procedure zip code radius search, sql server stored procedure longitude latitude, copy table sql server stored procedure, jasper report call sql server stored procedure, sql server stored procedure zip code radius, zip radius sql server stored procedure, sql server stored procedure copy data tables, sql server stored procedure execute externa script, xml sql server stored procedure, perl execute sql server stored procedure, sql server stored procedure optimization, write excel macro sql server stored procedure, sql server stored procedure import access, sql server stored procedure with parameters

Tentang Majikan:
( 3 ulasan ) Fort Worth, United States

ID Projek: #29038557

Dianugerahkan kepada:

tutulsoft

-- 20 years Store Procedure expert for any complex, I have ready store procedure to read all table schema for a particular field value, so get this out put for sum of particular field i can easily solve you , i am read Lagi

$40 USD dalam sehari
(32 Ulasan)
5.6

10 pekerja bebas membida secara purata $32 untuk pekerjaan ini

Proolancer

I m a database administrator with 9 years of experience in this industry. I read your project details and I understood your needs ,I can do what you want in the deadline just contact me and we can discuss more about th Lagi

$50 USD dalam sehari
(61 Ulasan)
6.2
SqlDevelopment

I can efficiently and qualitatively develop script for required calculation through all existing tables because I am Senior MS SQL Developer with 10-plus years' seniority and with exceptional professional expertise in Lagi

$25 USD dalam sehari
(29 Ulasan)
4.6
habib9861

hi hope you are doing well. i have been a professional developer for more than 6 years, I have great expertise in different databases like oracle sql server and mysql. Kindly text me for further details. Regards, M.H Lagi

$25 USD dalam 2 hari
(16 Ulasan)
3.9
bizmanas

Hi I have 15 years of experience in SQL server Database development. I can build the query for you in 3 hours. please ping me offline we can close it quickly.

$56 USD dalam sehari
(2 Ulasan)
1.5
tiagoaurich

Hi. Best regards. If you have the tables name list, I may do it in ONE hour only and send the sql script to you. Att. Tiago

$30 USD dalam sehari
(0 Ulasan)
0.0
gonzalojuan93

Wide knowledge about the lenguage, strong logical thinking and a resolutive profile that fits with your request

$25 USD dalam 7 hari
(0 Ulasan)
0.0
hariszia92

Hi there, I am Haris Zia , Senior Software Engineer. I have 6 year experience as .Net developer (full stack). I have experience in Asp.net MVC (Razor syntax), Asp.net core ,entity framework ,MSSQL Server, HTML, CSS, Bo Lagi

$20 USD dalam 7 hari
(0 Ulasan)
0.0
vtolentino3

Hello, i’m a post-graduated DBA with 11+ years of experience, i can help you on this query. Hope we could chat.

$30 USD dalam sehari
(0 Ulasan)
0.0
fabianbarragan18

Hola amigo, tengo conocimientos en sql con el gestor MSQLSERVER, soy ingeniero de sistemas, espero que me contactes. gracias.

$18 USD dalam 7 hari
(1 Ulasan)
0.0