Topics
Started by
Posts
Last post
Hello, I have a framework where dynamic generated sql is executed like the following: exec sp_exec…
4 replies
I have a table with appdt as first appointment date and the another record for the same customer# h…
5 replies
Hi, I have some logging procedures that work fine, like this: BEGIN TRANSACTION sp_start_log... (wr…
11 replies
Hi, I use SAP Crystal Report V.14 and SS2012, my task is to build a report/pivot with CR for the la…
8 replies
I have a very simply SQLCLR project. using System; using System.Data; using System.Data.SqlTypes; u…
8 replies
Hi I have two tables like, create table dbo.#Status( ID varchar(50), Status varchar(50), Effect…
6 replies
Hi! I have some T-sql procedures and function witch are getting from system sth like this @days='20…
37 replies
Hello. I put on the site excell file where I explained what I want to get . It is easier to explain…
11 replies
WHERE @var = 0 OR NOT EXISTS (SELECT 'x' FROM ...) Will MS sql evaluate the NOT EXISTS if @var = …
14 replies
Hi Guys, I have a table called "Connections" which is used to store connection requests between two…
5 replies
I need to use the same SQL source code in more than one stored proc. Is there a way to -include mys…
9 replies
Hi I have a temp table with 146525 records: CREATE TABLE #temp ( ID int, amount bigint, Ty…
15 replies
Hi alll, I was wondering if anyone has any ideas on how I could achieve a ranking number, where I h…
3 replies
below is the scenario I have implemented a solution to bring sql backup history from all servers u…
3 replies
Hi All, In a table, I'm updating datetime values as below : create table testdate (id smallint, fi…
1 replies
Viewing 15 topics - 2,821 through 2,835 (of 4,984 total)
You must be logged in to create new topics.