Topics
Started by
Posts
Last post
Hello Experts,I am trying to merge records with the same contents of different periods. drop table …
2 replies
I am looking in the information schema. I am trying to find the connection between the table column…
7 replies
hi there I have a folder of .sql scripts, in a windows path 'E:\DeploymentScripts'.I want…
6 replies
SELECT tb1.* from tbl1 inner join tbl2 on tbl1.Col1= tb2.Col1&nbs…
1 replies
I'm currently working my way through Itzik's book for 70-761 and I'm struggling a bit with the JSON…
3 replies
Hello, I thought this would be easy but I'm kind of stuck. I need to get Job Position titles …
5 replies
How do i Update Table A columns when Table B is updated. Also I need to update Table B columns when…
6 replies
Dear All, I have below stored procedure. IF I execute it passing just one DB name, it works proper…
5 replies
Hi,I was wondering if someone could help. I wanted a list of all the database sizes for logs and da…
4 replies
I have the longitude and latitude for my location. I don't know how to find the area of the propert…
11 replies
I can't seem to figure out how to write this in SQL. I have searched and read about Pivots but I th…
4 replies
I have Xml like below which got (Table (one or more) , columns , rows ) ..It needs to be …
3 replies
Hello,During my time as a DBA I find that I collect useful scripts to help me identify data, deadlo…
15 replies
All, I would like to add the below script into a cursor so that it loops through all the databases …
1 replies
I have a table with one trigger on it. CREATE TRIGGER [dbo].[trgPersonnel] ON [dbo].[Personnel] FOR…
4 replies
Viewing 15 topics - 2,251 through 2,265 (of 3,091 total)
You must be logged in to create new topics.