Topics
Started by
Posts
Last post
I've googled my issue all weekend, but can't seem to solve the problem So basically, I have a query…
8 replies
Hi all, We have data in this format (slightly simplified): ID &n…
1 replies
Hello Good Morning, How to optimize this code please advise.... SELECT CASECASE WHENWHEN UPPE…
4 replies
Hi,I am a little new to this, but I have been trying to find a good explanation of the different ba…
2 replies
I am importing (transferring) records from one server to another server : TABLE A (SERVER 1) -> …
7 replies
Afternoon, I wonder if someone can offer any suggestions I haven't thought of on the below. I have …
3 replies
CREATE PROCEDURE [dbo].[usp_test]ASSET NOCOUNT ONBEGIN BEGIN TRY DECLARE @First_Par…
5 replies
Hey guys, I have a sproc where Im using select into to load a staging table used for creating flat …
4 replies
Hi, I need help to write a SQL query to pull data as per where clause given below. I have database…
3 replies
Hello all, I have a table:CREATE TABLE [dbo].[udLaborTracking]( [Co] NOT NUL…
11 replies
Is there a way to run a stored procedure or a function for every new sql session automatically.This…
3 replies
Hi,I have a table valued function which is causing serious performance issue when call it from…
8 replies
I have a table with following stats:443114382 rows, reserved 45511728 kb, 680616 kb index size and …
18 replies
Hi All,I have optimized one store procedure. Original is taking 35 seconds to take data and new SP …
8 replies
Im running a query and it has numerous linked tables. I have entered a date parameter of one week (…
18 replies
Viewing 15 topics - 736 through 750 (of 4,984 total)
You must be logged in to create new topics.