Topics
Started by
Posts
Last post
Hi all, I'm pulling data from XML into tables, but I'm unsure how to link the data after it's impor…
18 replies
I need to pivot my records in columns into rows. Here is sample data: create table #columnstorows (…
6 replies
I have a query that, in this example, pulls a single row result. I'm dividing 140 by 28 and you'd t…
8 replies
Hi there, Could you please help with some improvements from the below function? Basically, I'm usin…
4 replies
I'm trying to find a specific string (a name) and replace it with another inside of a VARCHAR(7000)…
5 replies
DECLARE @Date SET @Date = 2012 DECLARE @Year int SET @Year = (SELECT DATEPART(yyyy,@Date)) SELECT …
5 replies
I am trying to select records based on a year. Any help would be greatly appreciated. DECLARE @Date…
1 replies
DECLARE @Date SET @Date = 2012 DECLARE @Year int SET @Year = (SELECT DATEPART(yyyy,@Date)) SELECT …
1 replies
Hello, Does anybody has any good explanation as to why the output from both dmv's does'nt show the …
4 replies
Hello, I need to add a join in my select query depending upon a variable @LoggedUser. the Join is t…
4 replies
hi, CREATE TABLE A (ID INT IDENTITY (1,1)) CREATE TABLE B (ID INT, EMPID VARCHAR(10)) INSERT INTO A…
7 replies
I have a database In Recovery. Where do I check the completion status of the recovery?
12 replies
I am trying to find the members who are having monthstartdate continuesly for 11 months ; here in …
8 replies
I have column moddat which is of varchar(10,null) Here is my data: 20020415 20020508 19991104 19990…
2 replies
Hello everyone, I'm looking to dynamically remove records from tables dynamically using the informa…
6 replies
Viewing 15 topics - 2,896 through 2,910 (of 4,984 total)
You must be logged in to create new topics.