Topics
Started by
Posts
Last post
Hi All, I am writing a cursor to capture the indexes that are fragmented and I am sending the outpu…
1 replies
Hi, I was looking for a solution inorder to get the max dates from a cross-tab aka Pivot in the mod…
6 replies
Hello, I would do something like this select t1.f1, t2.f1 from table1 t1 join table1 t2 on t2.f5 …
3 replies
I am looking at what is the best way to run stored procedures against all rows in the insert table …
2 replies
I have some data in sql serve which I am trying to summarize with the following syntax: SELECT SUM…
3 replies
I have a job with almost 10 steps in it. I want to disable the steps as per my wish programatically…
1 replies
I need a query Data is in millions. I am just presenting you some data TableA Col1 Col2 Col…
14 replies
Ok so I am stuck on a query - basically I have a table which stores various money transactions and …
5 replies
I'm tired and need your help... Table: CUSTOMER Columns: col_1, col_2, col_3 What I need is a state…
17 replies
I am trying to compare two tables and identify records in table B that are not in table A based on …
8 replies
We have a parse XML to Int function, it is used in a couple of stored procedure process. But I foun…
9 replies
Hi, I have two tables: -- holding some values for dates CREATE TABLE vals (dt DATETIME, val INT) …
9 replies
Hello, How can I parse a string into rows? Ex: from_ text = "A # B # C" I need to get_: Col_Name --…
19 replies
A former developer created a wayward T-SQL and it's causing an extraction forever in a 2 million ro…
27 replies
We have a table that contains the ownership history of our assets (laptops/desktops). There is a j…
8 replies
Viewing 15 topics - 7,381 through 7,395 (of 10,647 total)
You must be logged in to create new topics.