Topics
Started by
Posts
Last post
i have data like this AssetIdFailureIdRootCauseId 112210141016 11221019NULL 112210291016 11…
1 replies
The below query has to give Y if it's equals to zero but it gives always zero. can you modify this …
11 replies
-- create the tally table SELECT TOP (30) IDENTITY(INT,0,1) AS N INTO #Tally FROM Master.dbo.SysCol…
4 replies
FILE ATTLOG.txt TARJETA | HORA | FECHA | RELOJ 30 | 02/08/2010 08…
3 replies
Hi hope this is the correct forum to this question if not please redirect to me the correct forum r…
4 replies
Hi, Is it best to use varchar or char for small text columns, max 5 to 10 chars? An example is curr…
9 replies
Hi guys, Need help in sql query, Let me let you what i need, during the S.P i want to like to use …
3 replies
Hi All, I am querying the system tables to get SQL Agent Jobs and schedules information. One field …
11 replies
This is a strange. I had a TVP field name that was very close to the table field name. It took me …
2 replies
I need to create a Directory table for a project within an institute. How shall I implement a prim…
2 replies
Hi I have something like this and the tables have no foreign keys. I am using date in where clause …
2 replies
How to create table by using select command return data. Export utility not possible to create anot…
9 replies
I have a stored procedure that uses "WITH EXECUTE AS" to allow the querying of some system views, t…
4 replies
Hi all I have a datetime column in my DB and I am trying to fetch all records from yesterday using …
12 replies
I have a table with data. I need a query that need to insert only new rows instead of whole data. S…
5 replies
Viewing 15 topics - 4,906 through 4,920 (of 10,647 total)
You must be logged in to create new topics.