Topics
Started by
Posts
Last post
Sorry for a bit confusing topic, but need your advise, please. I have old good stored procedure, do…
5 replies
Hi I have an issue with Sql Server 2012 and Datastage which extracts the table(just select * from t…
3 replies
We have a table to 100M rows and up until now we were fine with an non clustered index a varchar(40…
9 replies
Hi, I have been given a request at work that requires us to run the SQL scripts that are held in a…
7 replies
Dear All, I have some code to resend failed mail items, as: -- to resend a fail DECLARE @to …
2 replies
Hi Is it possible to pass a sum of vars to a SP ? I've tried this but it gives me an error exec mys…
1 replies
Does anyone know how to retrieve all possible sets of values from a table, with each set having a u…
2 replies
Hi All, Lets say I have a set of columns as follows: Table.Name - Table.ID - Table.Code I want to …
7 replies
Is there a better way to handle this sort of thing? It just doesn't feel right putting a SELECT in…
2 replies
Hi everyone, I'd appreciate it if I could get some help with the query below as I'm struggling to g…
3 replies
I have a .sql script I want to run from sqlcmd. It worked with osql but when I run as a SQL job, I…
1 replies
Hello, I have a view which I'm trying to optimize. Here's original one: ALTER VIEW [dbo].[V_Smeny_D…
3 replies
Hello, I have following problem and I hope someone could help: I have a table with a datetime and a…
15 replies
Hi all, I have the following scenario and looking for some advise: SQL database on SQL 2012 Large P…
25 replies
Hi All below is the sample table structure and problem statement. Request help to form this query: …
4 replies
Viewing 15 topics - 2,776 through 2,790 (of 4,984 total)
You must be logged in to create new topics.