Topics
Started by
Posts
Last post
Hi! I'm just doing some tests for client solutions using the MERGE statement to combine CRUD operat…
21 replies
Hi Friends, one of my colleague asked me to rewrite this script as this is having a performance iss…
15 replies
Hi all, i have the next problem: i need to extract numbers from a string. Without using CTE, func, …
20 replies
Here is code tsql code using recursion within a cte that producing a syntax error marked *** below!…
9 replies
Hello, I've Table Design and storing data in vertical format as follow CREATE TABLE [dbo].[crpt_Im…
2 replies
Investigating a performance issue, I have placed a number of statements like this throughout the St…
10 replies
I'm trying to figure out a good way to query what in my opinion a less than optimal schema. I creat…
5 replies
I've table as follow, CREATE TABLE [dbo].[tmpaccthist_2013_2014]( [cmpy_code] [varchar](50) NULL,…
6 replies
I have a table called 'Activity' and there is a column called 'Transaction_Date', I am trying to fi…
12 replies
Hi, I want to write a stored procedure with if condition i have two tables Login ------- uname|pwo…
7 replies
Hi, This is a follow on form the previous post. Its related but not directly so I have created a se…
8 replies
I have a table whose dates are represented by a bigint rather than a datetime. e.g. 12/23/2015 is r…
11 replies
Hello, I have the following script: execute sp_operations123 '2015/12/23' If I declare a varia…
2 replies
This query has issues due to the \. If I use a Where = it works fine. How do I get around this smal…
41 replies
Hello, I'm having difficulty in getting the following piece of dynamic sql to execute in the correc…
1 replies
Viewing 15 topics - 871 through 885 (of 10,647 total)
You must be logged in to create new topics.